MSOffice-Excel_Chp05_Notes

							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.
2Lesson 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…




                              If you no longer need a
Insert a new worksheet.
                              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, double-
                            click 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.