PRINTING WORKSHEETS AND WORKBOOKS

When printing large worksheets with lots of rows, it's difficult to tell what the data represents on pages 2 and higher. Use the _______ command to set the row(s) that contain the column headings to print at the top of each page.

Print Rows

To print only the cells that you have selected, use the ________ command on the Print tab.

Print Selection

print area

a selected portion of the worksheet that will be printed

Print Titles

a setting that repeats rows and/or columns on each page of a worksheet

gridlines

the vertical and horizontal lines that display in a worksheet to outline the cells

Margins

the white space left around the edges of the paper when a worksheet is printed

center on page

command that centers worksheets horizontally and/or vertically on a page

Text and graphics inserted in this area print at the top of every page?

headers

The white space around the top, bottom, left and right edges of a printed page are knows as the ________.

margins

scale to fit

scales worksheets to print smaller or larger than the actual font size

Common letter-sized paper used in the United States has what dimensions?

8.5" x 14"

Use the _______ command to center worksheets vertically and/or horizontally on a page.

Center on Page

The default page orientation in a Microsoft Excel worksheet is landscape

False

If a worksheet has only a few columns that will print on a second page, change the Scale to Fit ________ command to 1 Page.

Height

page break

determines where a new page will start

Page Orientation

direction the text prints on the page

Print Preview

displays the worksheet as it will look when printed

Text and graphics inserted in this area print at the bottom of every page.

footers

print settings

option to print the active sheets, print the entire workbook, or print the selected cells

Page Setup

options for page settings such as margins, page orientation, and paper size

footer

text and/or graphics that print at the bottom of each page

headers

text and/or graphics that print at the top of each page

Headings

the column letters and row numbers in the worksheet