Excel Worksheet Tips: Switch Between Formula and Results If you have created a worksheet in excel with formula all over the sheet and want to quickly see what the formulae are, use: Ctrl + ~ (Where ~ is tilde; which is located underneath the Esc key) You can even print in this mode and the…
Read More
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 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
WIP: Third Update Last week I was able to create all the different plots that will intertwine to form the story. This week was spent on a different variety of activities. The majority of my writing time was spent looking for information about how to avoid amateur mistakes. Some of the articles I have read:…
Read More
Excel VBA Tips: Closing All Non-Active Workbooks If you ever need to close off all the workbooks you have open in the background but don’t want to have to navigate to each one, this code is extremely useful. Public Sub CloseAllInactive() Dim Wb As Workbook Dim AWb As String AWb = ActiveWorkbook.Name ‘Your code here,…
Read More
Excel VBA Tips: Large concatenation OR concatenating multiple ranges One of the useful worksheet functions in excel is being able to concatenate cells into a single cell. However, if you try to concatenate a large number of cells or a multiple ranges, it can become very problematic. However, after searching today, I came across this…
Read More
Mac Tips – Switching between firefox sessions One of the things that is different between windows and mac is alt + tab. Sure there is Cmd + Tab, but that switches between different programs. What happens when you have two instances of the same program open? Use: Cmd and ~ Problem solved! Come check out…
Read More
Writing Tips: Spot the Difference 12: Lightening vs Lightning I’ve seen this once a few times and Microsoft’s spellchecker is notorious for changing it to the wrong one! Lightening: to become lighter or illuminate Lightning: a brilliant electric spark discharge in the atmosphere, occurring within a thundercloud, between clouds, or between a cloud and the…
Read More
SUBMEG 