It doesn’t bother some folks to keep re-inventing the wheel, but for us power users, we want to streamline things so that we can save time and keystrokes. Isn’t that the whole point of using the Microsoft Office Suite? It is supposed to make life easier for us and save time and it can absolutely do that. We just have to set it up to do our bidding.
If you find that you are always clicking around to find something that you do fairly frequently in your worksheets, it is time to customize things to save time. For instance, using macros.
Follow the steps below to learn how:
- Click on Tools | Customize.
- Be certain the Commands tab is selected.
- In Categories, select either the category of commands you would like to add to your menu, or select Macros if you would like to add a macro to a menu.
- In the list of available commands for the category, select the one that you would like to add to a menu.
- Drag your selected command to the menu where you would like it added.
- The menu appears as you move the selected command over the command name.
- Once you have reached the point where you would like your item to be added, release your mouse button.
Life will now be much simpler for you!
Versions 97, 2000, 2002, 2003