Learn
Macro 27: Unprotect All Worksheets You may find yourself constantly having to unprotect multiple worksheets manually. The following macro does ...
Macro 26: Protect All Worksheets Before you distribute your workbook, you may want to apply sheet protection to all of the sheets. Instead of ...
Macro 25: Print Specified Worksheets If you want to print specific sheets manually in Excel, you need to hold down the CTRL key on the ...
Macro 24: Create a New Workbook for Each Worksheet Many Excel analysts need to parse their workbooks into separate books per worksheet tab. In ...
Macro 23: Copy a Worksheet to a New Workbook In Excel, you can manually copy an entire sheet to a new workbook by right-clicking the target sheet ...
Macro 22: Group Worksheets by Color Many of us assign colors to our worksheet tabs. This allows for the visual confirmation that the data in a ...
Macro 21: Sort Worksheets by Name You may often need to sort worksheets alphabetically by name. You would think Excel would have a native function ...
Macro 20: Moving Worksheets Around We've all had to rearrange our spreadsheet so that some sheet came before or after other sheet. If you find ...
Macro 19: Unhide All Worksheets in a Workbook If you've ever had to unhide multiple sheets in Excel, you know what a pain it is. You need to ...
Macro 18: Hide All but the Active Worksheet You may not want to delete all but the active sheet as we did in the last macro. Instead, a more ...
