Transcript Lesson 5: Manage Workbooks

2
Excel 2007®Business and
Personal Finances
What are the different ways you can
create and display your Excel 2007 files?
2
Lesson 5: Manage Workbooks
In Microsoft
Excel 2007,
you can create
worksheets
using
templates,
print your data
to display it,
and make your
worksheet into
a Web page.
2
Lesson 5: Manage Workbooks
Lesson 5 Objectives:
 Use a template
 Organize worksheets
 Split, freeze, hide, and arrange workbooks
 Save and preview worksheets as Web pages
 Set up pages for printing
 Rename folders and convert files to different
formats
2
Lesson 5: Manage Workbooks
To create workbooks that complete specific tasks, use a template.
Excel comes
with common
templates such
as invoices,
sales and
expense
reports, and
budgets that
contain useful
formulas and
preset
formatting.
You can also download templates
online from Microsoft Office Online.
2
Lesson 5: Manage Workbooks
If you need to add more information to a workbook,
such as additional weeks to a time card…
Insert a new worksheet.
If you no longer need a
particular worksheet, delete it.
2
Lesson 5: Manage Workbooks
To change the
order of
worksheets, use
the Organize
Sheets command
or drag them to
the desired
location.
Excel allows you to arrange worksheets in
the order most logical to you.
2
Lesson 5: Manage Workbooks
To navigate through a large worksheet, you
can split, freeze, hide, and arrange windows.
2
Lesson 5: Manage Workbooks
If two parts of a worksheet are too far apart
to view at the same time, split the window.
Splitting the
window divides
it into two
panes that you
can scroll
independently.
To restore the single window, doubleclick any part of the split bar.
2
Lesson 5: Manage Workbooks
If you move
far enough
down or to
the right in a
worksheet,
you will no
longer see
the row and
column
headings.
Freeze headings to keep them in place while you move around.
2
Lesson 5: Manage Workbooks
You can
Arrange
several
workbooks
to organize
them on
the screen.
You can also Hide a workbook from view without closing it.
2
Lesson 5: Manage Workbooks
To convert a
worksheet
to a Web
page, open
the Publish
as Web
Page dialog
box.
This will convert the information into a
format that can be viewed on the Internet.
2
Lesson 5: Manage Workbooks
Saving an
Excel
workbook to
a Web format
means that
people can
view
it even if they
do not have
Excel.
They can view your data through a common Web browser.
2
Lesson 5: Manage Workbooks
You can save a workbook in another format so it can be used by another
program.
To save a
workbook
in a
different
format,
open the
Save As
dialog box.
You can save a workbook as a Web page, as text for Word document, or
as data for a database program, such as Microsoft Access 2007.
2
Lesson 5: Manage Workbooks
To set up a page for printing, first use Print Preview.
Print
Preview
shows you
what a
worksheet
will look
like before
you print it.
This helps you decide whether your worksheet will be
formatted the way you want it when you print it.
2
Lesson 5: Manage Workbooks
Use Page Setup to change paper size and page orientation.
The default
page
orientation
is portrait,
or vertical.
For a horizontal layout,
change the orientation to landscape.
2
Lesson 5: Manage Workbooks
Click Print
to print the
entire
worksheet.
To print only a selection of the worksheet,
such as a range of cells, set the print area.
2
Lesson 5: Manage Workbooks
If you want your
worksheet to fit
on a single
printed page,
you can
decrease the
margins.
To change a worksheet’s margins. Use the Page
Setup group or Page Setup dialog box.
2
Lesson 5: Manage Workbooks
By default,
when you click
Print button
and click OK,
the current
worksheet
prints.
To print all the worksheets in the file, click Entire Workbook.