Mac Tips – Deleting Bookmarks From Firefox One thing I’ve seen many people (including myself) searching for is how to delete a bookmark you have made in Firefox. If you have placed this bookmark within a folder on the bookmark menu, you cannot simply right-click on it and delete it when you want to remove…
Read More
Excel Worksheet Tips: Unlocking Specific Areas of a Protected Worksheet If you create a workbook that others are going to use, but you don’t want them to corrupt certain parts of the workbook, you will want to protect the workbook. However, if they are required to modify cells, having a locked worksheet will stop any…
Read More
Excel Worksheet Tips: Extract Date or Time from Date/Time Do you have a cell that contains both a date and time value but only need one or the other? To extract the date Assuming the date time value is in cell A1, you can use the following formula: =DATEVALUE(MONTH(A1) & “/” & DAY(A1) & “/”…
Read More
WIP: Fifth Update I set myself a challenge last week to finish all of the back stories by the end of today. I am happy to report that I have completed them! I am glad that I decided to do this, as it helped strengthen the characters. By creating their pasts, it has shown how…
Read More
iTunes Help – How Many Artists? One count is easy to see, the number of songs in your library. This is at the bottom of the screen when you are in your library. How do you see how many artists are in your library? Simple! Ensure you are in the library and then press Ctrl…
Read More
Excel VBA Tips: Convert Number to Text I have covered how to do this using worksheet formulae, but it can also be done using vba. If your variable (that is a number) is called Number, to convert this to text, use the following code: Number = CStr(Number) It will now be stored in text format.…
Read More
Excel Worksheet Tips: Keyboard Shortcuts I was searching for a particular shortcut but unfortunately I was unable to find the one I was looking for; however I have found many more. Check out all these useful shortcuts here. Come check out the directory for the rest of my excel tips! Submeg IT
Read More
SUBMEG 