Category: Excel

Automatically hide and unhide all Excel sheets with this global macro

17 Aug, 2022

3 min read

If you find yourself constantly hiding and unhiding all sheets in Excel (except for the current sheet) you are working on, then this tutorial will allow you to do it quickly and automatically with a press of a button!
read more

Global reference style toggle in Excel

26 Apr, 2022

2 min read

There many applications for using A1 and R1C1 reference styles in Excel. Here is how I made a global toggle to easily switch between the two on all Excel workbooks.
read more