Microsoft Office Tutorials and References
In Depth Information
To Add a Worksheet to a Workbook
Save As dialog box
• Click the Open button in the Open
• When Excel displays the NextDVR
Proﬁ t Potential Template, click the
Ofﬁ ce Button and then click Save
As on the Ofﬁ ce Button menu.
• When the Save As dialog box
appears, type NextDVR Proﬁ t
Potential in the File name box.
• Click the Save as type box arrow
and then click Excel Workbook
Save as type box
ﬁ le name
• Click the Save button in the
Save As dialog box to save the
instructs Excel to
save template as
How does Excel automatically select
the ﬁ le type and ﬁ le name?
In a production environment in
which templates are saved to the
Templates folder, Excel automati-
cally selects Excel Workbook as
the ﬁ le type when you attempt to
save a template as a workbook.
Excel also appends the digit 1 to
the template name as described
A workbook contains three worksheets by default. The number of worksheets you can have in a workbook is
limited only by the amount of memory in your computer.
Identify additional worksheets needed in the workbook.
The NextDVR Proﬁ t Potential workbook requires four worksheets — one for each of the
three regions and one for the company totals. Thus, a worksheet must be added to the
When you add a worksheet, Excel places the new sheet tab to the left of the active tab. To keep the worksheet
with the dummy data shown in Figure 6–29 on page EX 443 on top — that is, to keep its tab (Sheet1) to the far
left — spreadsheet specialists often add a new worksheet between Sheet1 and Sheet2, rather than to the left of
Sheet1. The following steps select Sheet2 before adding a worksheet to the workbook.