Microsoft Office XP for Windows: Visual QuickStart Guide

Chapter 16. Special Excel Techniques

Each Excel workbook can contain multiple worksheets. If you want, you can use just the first worksheet for all your data and calculations. But you also might want to organize your information by placing certain data on each worksheet and using one of the sheets to consolidate data from other sheets.

In this chapter, you’ll learn how to take advantage of multiple sheets and other, more advanced Excel tasks and capabilities.

Changing to Another Sheet

You can use the worksheet tabs visible at the bottom of the current sheet to switch easily from sheet to sheet (Figure 16.1).

Figure 16.1. A workbook containing five worksheets. ...