Printing

Core Training for Microsoft Office Excel 2003

Printing

Printing Worksheets

1	To begin previewing a worksheet to be printed, on the Standard toolbar, click the Print Preview button.
2	To increase the display size of the previewed worksheet, in the Print Preview window, click Zoom.
3	To restore the display size of the worksheet, click Zoom again.
4	To begin modifying the worksheet setup, click Setup.
5	To change the orientation of the page to horizontal, in the Page Setup dialog box, in the Orientation section, click the Landscape option, and click OK.
6	To begin realigning the margins so that the company logo fits, click Margins.
7	To realign the margins, position the pointer over the indicated horizontal margin, and when the pointer changes to a double-headed arrow, drag it up to the indicated location.
8	To begin modifying the page breaks, click Page Break Preview.
9	To change the page width, position the pointer above the vertical page break line, and when the pointer changes to a double-headed arrow, drag the line to the border between columns G and H.
10	To switch back to Normal view, click the View menu, and click Normal.
11	To begin specifying which parts of the workbook should be printed, click the File menu, and click Page Setup.
12	In the Page Setup dialog box, click the Sheet tab.
13	To display cells containing error notifications as blank cells in the printed worksheet, in the Print section, click the Cell errors as box arrow, and click <blank>.
14	To change the print order of pages, in the Page order section, click the Over, then down option, and click OK.
15	To select noncontiguous worksheets, press the CTRL key, on the tab bar, click the March tab, and release the CTRL key.
16	To begin printing the selected worksheets, click the File menu, and click Print.
17	To print the active worksheet, click OK.

Printing Part of a Worksheet

1	To begin printing pages from a multiple-page worksheet, click the File menu, and click Print.
2	To begin selecting pages to be printed, in the Print dialog box, in the Print range section, click the Page(s) option.
3	To select the first page to be printed, in the From box, click the Up arrow two times, and then press TAB to move the cursor to the To box.
4	To select the last page of the page range to be printed, in the To box, click the Up arrow three times (until the number 3 appears).
5	To print the selected range of pages, click OK.
6	To begin modifying the print range to fit on a single page, click the File menu, and click Page Setup.
7	To resize the worksheet, so that the entire worksheet fits on one printed page, in the Page Setup dialog box, in the Scaling section, click the Fit to option, and then click OK.
8	To begin defining portions of the worksheet to be printed, press and hold down the SHIFT key, click cell G12, and release the SHIFT key.
9	To set the selected area as the print area, click the File menu, point to Print Area, and click Set Print Area.
10	To preview the selected print area, on the Standard toolbar, click the Print Preview button.
11	To begin changing the alignment of data on the printed page, in the Print Preview window, click Setup.
12	To adjust the margins of the print area, in the Page Setup dialog box, click the Margins tab.
13	To align the selection horizontally at the center of the page, in the Center on page section, click Horizontally to select it.
14	To align the selection vertically to the center of the page, in the Center on page section, click Vertically to select it, and then click OK.
15	To return to the active worksheet, in the Print Preview window, click Close.
16	To select a different area for printing, click the File menu, point to Print Area, and click Clear Print Area.
17	To select a portion of the worksheet that you do not want printed, drag from column head D to column head G.
18	To prevent the selected columns from being printed, click the Format menu, point to Column, and click Hide.
19	To preview the section of the worksheet to be printed, click the File menu, and click Print Preview.
20	To return to the active worksheet, in the Print Preview window, click Close.
21	To unhide the hidden columns, click the Format menu, point to Column, and, click Unhide.

Printing a Chart

1	To begin selecting the chart for printing, in the January worksheet, click the Total Sales by Hour chart.
2	To begin printing a chart on a page by itself, click the File menu, and click Print.
3	Notice that in the Print dialog box, in the Print what section, the Selected Chart option is selected. To print the chart, click OK.
4	To begin formatting the chart area so that you can print the January worksheet without the chart, click the Format menu, and click Selected Chart Area.
5	In the Format Chart Area dialog box, click the Properties tab.
6	To prevent the selected chart from being printed, on the Properties tab, click Print object, and then click OK.
7	To deselect the chart, and select a cell in the worksheet you intend to print, click cell D9.
8	To print the worksheet that contains the selected cell, on the Standard toolbar, click the Print button, as indicated.
9	To begin printing the chart at its actual size, click the blank chart area to the left of the Total Sales by Hour title, click the Format menu, and click Selected Chart Area.
10	To allow the chart to be printed, on the Properties tab of the Format Chart Area dialog box, click the Print object to select it, and click OK.
11	To preview the chart before printing it, click the File menu, and click Print Preview.
12	To begin modifying the chart's print settings, click Setup.
13	In the Page Setup dialog box, click the Chart tab.
14	To set the chart so that it is no longer resized to fill the page, on the Chart tab, in the Printed chart size section, click the Custom option, and click OK.
15	To begin printing the chart at the size shown, in the Print Preview window, click Print.
16	To print the chart, in the Print dialog box, click OK.