Page Breaks
To set page breaks within the worksheet, select the row you want to
appear just below the page break by clicking the row's label. Then choose
Insert|Page
Break from the menu bar. You may need to click the double down arrow
at the bottom of the menu list to view this option.
Page Setup
From the File menu, select Page Setup to format the page,
set margins, and add headers and footers.
-
Page Tab
-
Select the Orientation under the Page
tab in the Page Setup window to make the page Landscape or Portrait.
-
The size of the worksheet on the page can also be formatting under Scaling.
-
To force a worksheet to print only one page wide so all the columns appear
on the same page, select Fit to 1 page(s) wide.
-
Margins Tab
-
Change the top, bottom, left, and right margins under the Margins
tab.
-
Enter values in the header and footer fields to indicate how far from the
edge of the page this text should appear.
-
Check the boxes for centering horizontally or vertically on the page.
-
Sheet Tab
-
Check Gridlines in the Sheet Tab
if you want the gridlines dividing the cells to be printed on the page.
-
If the worksheet is several pages long and only the first page includes
titles for the columns, select Rows to repeat at top to choose a
title row that will be printed at the top of each page.
Print Preview
From the File menu, select Print Preview to
view how the worksheet will print.
-
Click the Next and Previous buttons at the top of the window
to display the pages
-
lCick the Zoom button to view the pages closer.
-
Make page layout modifications needed by clicking the Page Setup
button.
-
Click Close to return to the worksheet or Print to continue
printing.
-
Click the Page Break button. The dotted
lines can be dragged to adjust the position of the page breaks.
Print
From the File menu, select Print from the menu bar.
The "Print" dialog box will appear.
-
Printer - select the printer on your network which you want to use.
-
Print Range - Select either all pages or a range of pages to print.
-
Print What - Select selection of cells highlighted on the worksheet,
the active worksheet, or all the worksheets in the entire workbook.
-
Copies - Choose the number of copies that should be printed. Check
the Collate box if the pages should remain in order.
Click OK to print.
|