June 2015
Beginner
288 pages
5h 27m
English
Chapter 5
In This Chapter
Adding and naming worksheets
Protecting and unprotecting worksheets
Creating a table of contents
Highlighting active rows and columns
Hiding and unhiding worksheets
Moving and sorting Worksheets
Copying worksheets to new Workbooks
Excel analysts can save time and gain efficiencies by using macros to automate tasks related to worksheets. Two common example tasks are unhiding all sheets in a workbook and printing all sheets at the same time. In this chapter, I cover some of the more useful macros related to worksheets.
The chapter starts with one of the simplest worksheet-related automations you can apply with a macro: adding and naming a new worksheet.
When you read through the ...