Microsoft® Office Excel® 2007 Inside Out

Managing Worksheets

You can have as many worksheets in a workbook as your computer’s memory will allow (probably hundreds of worksheets, depending on how much data each contains); consequently, you don’t need to try to fit everything onto one worksheet. The following sections present the features you can use to organize your worksheet world.

Inserting and Deleting Worksheets

To insert a new worksheet into an existing workbook, click the Insert Worksheet tab, which you can see in Figure 6-14 on the left. The new sheet tab appears to the right of the last worksheet in the workbook. You can also quickly insert worksheets by right-clicking any sheet tab to display the shortcut menu shown in Figure 6-14 on the right. Clicking Insert on this menu opens ...