- WRITTEN BY Jorge Rojas POSTED ON September 26,2017
If you’re like most people, you only use the most basic features in Excel. Why? Because you probably believe that other tasks are too daunting to learn. This simply isn’t true. In fact, it’s the exact opposite!
You can automate repetitive and tedious tasks with the macros in Microsoft Excel. For example, let’s say you have dates displayed in random formats. Did you know that you can apply a single format to all of them at once? With a macro, you can do this—Plus, you can replicate this format whenever you need to.
- 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 firstname.lastname@example.org
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!