Take Excel to the UPPER class
Word has a keyboard shortcut to convert lowercase to uppercase. Shift + F3. Excel doesn’t. Macros to the rescue again.
(more…)Hiding sheets when opening an Excel File
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.
(more…)Printing certain sheets in an Excel file
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.
(more…)Macro to save all open Excel files
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.
(more…)How to make the most of Excel 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. (more…)