Excel 2016 For Dummies

Chapter 7

Maintaining Multiple Worksheets

IN THIS CHAPTER

Moving from sheet to sheet in your workbook

Adding and deleting sheets in a workbook

Selecting sheets for group editing

Naming sheet tabs descriptively

Rearranging sheets in a workbook

Displaying parts of different sheets

Comparing two worksheets side by side

Copying or moving sheets from one workbook to another

Creating formulas that span different worksheets

W hen you’re brand new to spreadsheets, you have enough trouble keeping track of a single worksheet, and the very thought of working with more than one may be a little more than you can take. However, after you get a little experience under your belt, you’ll find that working with more than one worksheet in a workbook is no more taxing than working with just a single worksheet.

Don’t confuse the term workbook with worksheet. The workbook forms the document (file) that you open and save while you work. Each new workbook (file) normally contains a single blank worksheet, to which you can add as many worksheets as you need by clicking the New Sheet button on the Status bar (the one with plus sign in a circle). Multiple worksheets in a single workbook act like the loose-leaf pages in a notebook binder; you can add or remove sheets as needed. To help you keep track of the worksheets in your workbook and navigate between them, Excel provides sheet tabs (Sheet1, Sheet 2, ...