Organizing the Worksheets in a Workbook

When you create a blank workbook, Excel gives it the number of sheets set in the Sheets in new workbook box in the General preferences pane—by default, a single worksheet. If you need more worksheets, you can easily insert them. And you can get rid of any worksheets you no longer need.

Excel gives each worksheet a default name at first—Sheet1, Sheet2, and so on. Usually, you want to give the worksheets descriptive names so you can easily identify them. You may also need to rearrange the worksheets into a different order.

Inserting a New Worksheet

To insert a new worksheet, take one of these actions:

  • Insert a new worksheet after the last existing worksheet. Click the Insert Sheet button that appears on ...

Get Learn Excel 2011 for Mac 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.