150
22
33
11
2
Click New.
3
Click Sample templates.
•
To use an Office Online
template, click a category
in the Office.com Templates
section. Click the template
you want to use, and then
click Download.
1
Click the File tab.
Create a New Workbook from a Template
You can save time and effort by creating a new
workbook based on one of Excel’s template
files. Each template includes a working
spreadsheet model that includes predefined
labels and formulas, as well as preformatted
colors, fonts, styles, and more.
Excel 2010 offers seven templates, including
Expense Report, Loan Amortization, and
Personal Monthly Budget. However, there are
many more templates available through
Microsoft Office Online.
Create a New Workbook
from a Template

Can I create a new workbook based
on an existing workbook?
Yes. This is useful if you want to create a
new workbook that is the same or similar
to an existing file. Click File, click New,
and then click New from Existing. In the
New from Existing Workbook dialog box,
click the existing workbook and then click
Open.
10_577639-ch08.indd 15110_577639-ch08.indd 151 3/15/10 2:45 PM3/15/10 2:45 PM
152
22
33
44
11
55
1
Click the File tab.
2
Click Save ( ).

You can also click in the
Quick Access Toolbar, or you
can press
+ .

If you have saved the document
previously, your changes are
now preserved, and you can
skip the rest of these steps.

avoid losing your work, you should save a
workbook as often as is practical.
Save a
Workbook
10_577639-ch08.indd 15210_577639-ch08.indd 152 3/15/10 2:45 PM3/15/10 2:45 PM
153
CHAPTER
8
22
33
11
55
44

The Open dialog box appears.
3
Select the folder that contains
the workbook you want to
open.
4
Click the workbook.
5
Click Open.

The workbook appears in a
window.
1
Click the File tab.
•
You can click Recent to see

2
Click the View tab.
Arrange Workbook Windows
You can view two or more workbooks at once
by arranging the workbook windows within the
main Excel window. This enables you to easily
compare the contents of the workbooks.
Arranging workbook windows also enables you
to more easily copy or move data among
workbooks.
Excel offers four view modes for arranging
workbook windows: Tiled, Horizontal, Vertical,
and Cascade.
Arrange Workbook
Windows
10_577639-ch08.indd 15410_577639-ch08.indd 154 3/15/10 2:45 PM3/15/10 2:45 PM