Microsoft Office Tutorials and References
In Depth Information
Chapter 7: Maintaining Multiple Worksheets
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
When 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 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, and
Sheet3) that are like the tab dividers in a loose-leaf notebook.
Juggling Multiple Worksheets
You need to understand how to work with more than one worksheet in a
workbook, but it’s also important to understand why you’d want to do such a
 
Search JabSto ::




Custom Search