Chapter 5

Working with Worksheets

In This Chapter

arrow Adding and naming worksheets

arrow Protecting and unprotecting worksheets

arrow Creating a table of contents

arrow Highlighting active rows and columns

arrow Hiding and unhiding worksheets

arrow Moving and sorting Worksheets

arrow 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.

Adding and Naming a New Worksheet

The chapter starts with one of the simplest worksheet-related automations you can apply with a macro: adding and naming a new worksheet.

How the macro works

When you read through the ...

Get Excel Macros For Dummies now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.