- Open your spreadsheet.
- Select the cells you want to format.
- Click on View.
- Click on Macros>Record Macros.
- Type in the Name of your Macro. Excel provides a default name but it’s best to use a name you’ll remember like date-formatting (with no spaces).
- You can now assign a Shortcut Key. Click the Shortcut Key Box and enter Shift+D (for an uppercase D) as the shortcut key.
- Now you can execute the macro by clicking Ctrl+Shift+D.
- Save it in a Workbook, and name it by entering text in the Description Box (such as Date Formatting Macro).
- Once you click OK, the Macro Recorder will be turned on.
- Click on Home>
- Format the cell by selecting
- Enter the format you want (e.g., ddd, mmm, dd) for day, month, number/ or Fri. Sept. 5
- Go to Macros, Start Recording and the change will be complete.
Step Three: To apply this format to all your selected cells:
Select the cells you want to format.
And the cells will be formatted as you specified above!
We hope this helped. To learn more about Microsoft Excel Macros, or to find about how Tektonic can help your business take advantage of the latest technology, please contact us at: (416) 256-9928 or email@example.com
Tektonic Managed Services is an IT Support and Computer Services company serving Toronto GTA. We provide services in and around Toronto, including York Region, Durham Region and Peel Region. Businesses like yours need technology support to run highly-effective organizations. Leverage pro-growth technology services for your company now!