Instructions for downloading your free shortcuts
- download and copy the Macrostarter.xlsm to your desktop
- go to the windows button in the bottom left hand corner of your computer screen
- search for the folder XLSTART
- drag and drop or copy and paste the Macrostarter.xlsm file from your desktop into the XLSTART folder
Now you’re ready. Open up a blank Excel sheet then open the file you want to work with. Your Macrostarter.xlsm file is hidden in the background.
Cool Free Excel Shortcuts
So what is contained in the Macrostarter.xlsm file???? Well to give you a clue, we think that these are two of the coolest Excel shortcuts around….Ok, so maybe you won’t be able to guess.
Well they are….
Number formatting – puts a comma to separate thousands and also puts dashes for zeros – simply push CTRL+SHIFT+C on any number to apply
Date formatting – puts any numbers which are meant to be dates into the following format dd-mmm-yy. i.e. 31-Jan-11 – simply push CTRL+SHIFT+D
These two shortcuts are sure to save you plenty of time, formatting your Excel spreadsheet or financial model.
Do you want to become a Excel shortcut pro? If yes, then check out our Excel shortcuts training course