Skip to Main Content
Excel Macros For Dummies
book

Excel Macros For Dummies

by Michael Alexander
June 2015
Beginner content levelBeginner
288 pages
5h 27m
English
For Dummies
Content preview from Excel Macros For Dummies

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

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Excel Macros For Dummies, 3rd Edition

Excel Macros For Dummies, 3rd Edition

Dick Kusleika

Publisher Resources

ISBN: 9781119089346