Word has a keyboard shortcut to convert lowercase to uppercase. Shift + F3. Excel doesn’t. Macros to the rescue again.
Monthly Archives: May 2013
Hiding sheets when opening an Excel File
Only show the sheets you want
If you need to hide certain sheets every time an Excel file is opened then a macro may be your solution. Maybe the sheets are working sheets and don’t need to be visible to the user.
Printing certain sheets in an Excel file
Speed up printing
If you need to print certain sheets in a file in one step you can set up a macro to do it automatically and flexibly.
Macro to save all open Excel files
Time saver
If you have a number of linked Excel files and you make a structural change (insert rows or columns) you need to save all the open files to ensure that the links are updated and retained. This can be tedious as there is no Save All option in Excel. Word has a Save All option, but not Excel.
How to make the most of Excel Macros
How to use and install macros
I get many questions from Australian CPA’s and sometimes the solution involves a macro. Not everyone knows how to install and run a macro. This post will take you through the basics.