by John MacDougall | Feb 1, 2017 | Tips
Here are 7 great keyboard shortcuts to quickly perform file menu commands. Ctrl + N Create a new blank workbook. Ctrl + O Open the menu to open a saved workbook. Ctrl + S Save the current workbook or open the Save As menu is the file has not previously been...
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 4, 2016 | Tips
Unlimited Format Painter When you click the format painter you will be able to use it once, but if you double click it then you will be able to use it an unlimited number of times until you click the button again to turn it off. Highlight the area you...
by John MacDougall | May 1, 2016 | Tips
Is your text data not fully visible or your numerical data appears as #’s? Then here’s a quick way to expand columns in Excel to the exact width needed to view all the data. Here we see the text data is not fully visible and our numerical data has...
by John MacDougall | Apr 20, 2016 | Tips
These are the keyboard shortcuts I have found essential. There are a lot of others, but I think these are the most useful. If you use Excel a lot in your job or personal life, these are really worth knowing and using. Shortcut Description Ctrl + A Select all...
