Eliminate Extra Excel Worksheets
Provided by: Luke Chung, FMS President
By default, a new Excel spreadsheet includes three
Typically, most users only need to have one worksheet available.
Having the extra worksheets does not matter, but if you give the spreadsheet
to someone else, they may need to look at the extra worksheets to verify
nothing is there, or may miss something the few times you put information
the steps below to modify the default behavior to include
only one worksheet. (Note that you can always add
additional worksheets as you need them.)
Office Excel 2003 and Earlier
the Excel menu,
select Tools -> Options to open the Options dialog.
to the General tab, and change the "Sheets in new workbook" option to 1:
Office Excel 2007
- Click on the Office button
(in the upper left corner), and select "Excel Options" to open the
- With "Popular" selected in the Left Menu, change the
"Include this many sheets" option to 1.
If you should need additional worksheets:
- Right click on a worksheet tab
- Select "Insert..."
- Select "Worksheet" and click the OK button, or
double-click on "Worksheet".
Return to the tips page