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.
Select File|Page Setup from the menu bar to format the
page, set margins, and add headers and footers.
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
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.
Add preset headers and footers to the page by clicking the drop-down
menus under the Header/Footer tab.
To modify a preset header or footer, or to make your own, click
the Custom Header and Custom Footer buttons. A new
window will open allowing you to enter text in the left, center,
or right on the page.
Format Text - Click this button after highlighting the
text to change the font, size, and style.
Page Number - Insert the page number of each page.
Total Number of Pages - Use this feature along with the
page number to create strings such as "page 1 of 15".
Date - Add the current date.
Time - Add the current time.
File Name - Add the name of the workbook file.
Tab Name - Add the name of the worksheet's tab.
Check Gridlines 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.
Select File|Print Preview from the menu bar to view how
the worksheet will print. Click the Next and Previous
buttons at the top of the window to display the pages and click
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
To print the worksheet, select File|Print from the menu
- Print Range - Select either all pages or a range of pages
- 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.
||Page Properties and Printing
FGCU does not provide personal support for Office 2000 programs to outside parties.