Question

Suppose you have columns of data that span more than one printed page. How can you automatically print the column headings on each page?

• A. Click Page Setup on the File menu, click the Sheet tab, and enter the row that contains these column headings under Print titles
• B. Click Page Setup on the File menu, click the Page tab, click the Options button, then enter your choices
• C. Click Page Preview on the File menu, click the Sheet tab, and enter the row that contains these column headings under Print titles
• D. Click Page Setup on the File menu, click the Sheet tab, and make a selection under the Print heading

Answer 1

The correct option is A Click Page Setup on the File menu, click the Sheet tab, and enter the row that contains these column headings under Print titles

Suppose you have columns of data that span more than one printed page. How can you automatically print the column headings on each page Click Page Setup on the File menu, click the Sheet tab, and enter the row that contains these column headings under Print titles

On the Ribbon, click the Page Layout tab. In the Sheet Options group, under Headings, select the Print check box. Note: You can also click the small expansion icon , and then under Print, select the Row and column headings check box . To print the worksheet, press CTRL+P to open the Print dialog box, and then click OK.

Set print titles. Step 1 Select the worksheet range that you want to include titles when print. Step 2 Under 2013 style interface of Spreadsheets 2013, go to Page Layout tab, click Print Titles. Step 3 In the Page Setup dialog that pops up, click on the select button in Rows to repeat at top area and select a title row.

Press the F5 key to run the code. Then a Kutools for Excel dialog box pops up, please select the row you need to print repeatedly at bottom of every printed page, and then click the OK button.