Question

Eleanor wants a title row to be printed at the top of every sheet when she prints her data in an MS Excel file. What will she do in step X in the following series of clicks/tasks to do so: Page Layout tab > Print Titles > Page Setup Dialog box > X > OK?

A. Click on the select button in Rows to repeat at top area and select a title row.
B. Click the check box before Row and column headings under Print.
C. Click on the select bitton in Columns to repeat at left area and select a title row.
D. Click the check box before Gridlines under Print.

Answer 1

Option A.

Click on the select button in Rows to repeat at top area and select a title row

Step-by-step explanation:

In excel, before you can finally print a row title at the top of each page you need to click on the select button in "Rows to repeat at top" option in the print dialog box and select row the row which you need to appear at the top.

Hence, the complete steps to print a row title in excel are:

1. Go to Page Layout tab

2. Select print titles and a page dialog box will open

3. Click in the "Rows to repeat at top" box that appears and select the row which you need to appear at the top.

4. Click okay.