Free Bonus Excel Shortcuts

Blog Downloads:

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

By | 2011-09-28T19:59:57+00:00 September 28th, 2011|Blog|4 Comments

4 Comments

  1. Vishal February 20, 2012 at 6:32 pm - Reply

    Hi, I downloaded and copied the file in the XLSTART folder but when I open excel, it gives me this msg: “Excel cannot open the file ‘Macrostarter.xlsm’ because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file.”

    I am able to open other macro enabled excel files. Thanks

    • admin June 28, 2013 at 9:46 am - Reply

      Vishal

      What version of Excel do you have? i.e. 2007.

      It might be that you need to save the macrostarter file as an xls file if you have an older version of Excel.

      Let me know how you get on.

      Regards
      Brett

  2. obs100 May 18, 2013 at 11:53 am - Reply

    Hello,

    Unfortunately, the links to the above macrostarter file does not seem to work. Would it be possible to email me a copy please?

    Regards

  3. admin July 7, 2013 at 5:01 am - Reply

    obs100, the files have now been uploaded again and you should be able to access them. Let us know if you have any problems. Thanks Brett

Leave A Comment