by John MacDougall | Dec 9, 2016 | Tips
If you’ve ever wanted to quickly email a link to a file you’re working on to a colleague, then you know it can be a little bit painful. Open windows file explorer and find the file. Copy the path into the email, then copy the file name into the email. The...
by John MacDougall | Dec 8, 2016 | Tips
Excel has a great feature called AutoFill that allows you to save time entering data manually in a worksheet. If you want to list all the months or all the days of the week, all you have to do type the first in the list and then drag the cell cursor from the lower...
by John MacDougall | Dec 7, 2016 | Tips
Do you know about Excel’s clipboard feature? If you copy and paste a lot in Excel (which everyone does), then it’s worth finding out about. Most people are familiar with Excel’s copy and paste feature and usually know about the Ctrl + C and Ctrl + V...
by John MacDougall | Dec 7, 2016 | Tips
In this post we’ll find out how to get a list of all the sheet names in the current workbook without using VBA. This can be pretty handy if you have a large workbook with hundreds of sheets and you want to create a table of contents. This method uses the little...
by John MacDougall | Dec 6, 2016 | VBA
In this post we’re going to explore how to find and replace multiple text strings from within another string. Download Example File Excel has a great built in function called SUBSTITUTE which allows you to find one bit of text within another text string...