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 at the left of Figure 6-14. 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 at the right in Figure 6-14. Clicking Insert on this menu opens ...

Get Microsoft® Excel® 2010 Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.