By
default, Excel adds three worksheets to each new workbook
opened. What if you need more? Can you change the
default? How do you move or copy a sheet? Can you move
or copy more than one sheet at a time? How do you delete a
sheet? Read on to answer these questions and more.
Changing
the Default Setting
If
you normally create workbooks that need a specific number of sheets
(other than 3) you can change the default setting for the number of
sheets in a new workbook. From the Tools menu, choose Options
and move to the General tab, as shown below.
Change
the number for Sheets in new workbook, and choose OK.
Also notice that this is where you can change your default file
location. If you normally use a directory other than My
Documents, you can type in the path here and save time when opening
and saving files.
Naming
Sheets
The
easiest way to rename a sheet, is to double-click on the sheet tab,
type the name, and press Enter.
You
can also rename a sheet by right-clicking on the sheet tab and
choosing Rename, as below.
Inserting
Sheets
Remember
that when you insert a sheet in an Excel workbook, the default is to
insert the sheet before the current active sheet. So,
to insert a sheet:
Select
the sheet tab for the worksheet you want to be after the
inserted sheet.
From
the Insert menu, choose Worksheet.
Alternatively,
you can right-click on the sheet tab and choose Insert.
This brings up the Insert dialog box which gives a few more
options.
To
insert a worksheet, select Worksheet and choose OK.
Another option here is to insert a chart. Selecting Chart
and choosing OK brings up the Chart Wizard to help you
make a chart.
When
you need to insert a new worksheet at the end of your sheet tabs,
you will need to select the last sheet tab, insert the sheet, and
then move the sheet to the end. For example, I may have a
workbook with data for four quarters of the fiscal year with each
quarter being displayed on a separate tab. At the end of the
year, I want to include a sheet at the end for yearly totals.
So, I have inserted a sheet before the last sheet tab, as below.
Notice: You have the author's
permission to use the tutorials on this site for your personal
use only. If you would like to use these tutorials for
training classes or other commercial use, please contact kstille@esmartweb.com.
Distribution in print or on the Web without the author's permission
is strictly prohibited.
Featured Sites
HandofGrace.com
Quality,
affordable sterling silver beaded bracelets & mothers
bracelets. Swarovski crystals, fresh water pearls, Venetian
glass and other unique findings are featured in our bracelets.
The perfect gift for any occasion!
BakedByMom.com
Offering homemade cookie and candy boxes or gifts at reasonable prices, Baked by Mom strives to provide the best quality product in it's class. Try the White Chocolate Chip & Lime cookies, Rocky Road Candy and Caramels - they get rave reviews!
