• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL

Part I: Everyday Worksheet Tasks > Reorganizing Workbooks and Sheets

Chapter 9. Reorganizing Workbooks and Sheets

  • Change the default number of sheets in new workbooks

    Excel starts with three sheets in each workbook, but you can change this number.

  • Insert and remove sheets

    If you need more sheets, you can insert them. If you have sheets you don't need, you can delete them.

  • Copy and move sheets

    You can copy or move sheets to the same workbook or another workbook.

  • Rename sheets

    Use descriptive names for your sheets so that you can tell what they contain.

  • Group sheets for editing, formatting, and reorganizing

    To save time, group sheets and make changes to them all at once.

  • Troubleshoot 3-D references when sheets have been reorganized

    If you have problems with formulas after rearranging sheets, you may need to check the references.

Workbooks and the sheets they contain are the foundation for the work you do in Excel. Within a workbook you can place the sheets containing formulas, databases, charts, slides, macros, and Visual Basic procedures.

Workbooks make it easy to group all the pieces related to a job you are doing in Excel. Because sheets are grouped into one file, you can give a file to a coworker and know that all information and automation necessary for a particular Excel job is in the file.

Use some thought when designing your workbooks. You may want to create a workbook template to give to all of the plant accountants so that their reporting procedures are consistent and it will be easier to consolidate numbers.

When you first open a new workbook, it has a default number of worksheets. You do not need to keep all of them. You can insert or delete additional Excel sheets of any type, and you can copy or move sheets within or between workbooks.


When you organize a workbook, keep in mind that all sheets within the workbook open with the workbook and that you use memory for each sheet. So if you have a large worksheet that you use only on occasion, you may want to keep it in a separate workbook.



Not a subscriber?

Start A Free Trial

  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint