> > >

Excel MCQs

If you have a worksheet that's several pages long, how can you get the column headers across row 5 to print at the top of each page?

Copy row 5 on page 1. In Page Layout view, scroll down and paste into the top row of the remaining pages.

From the View tab, click Headers. Click in the box on the top of the page, then type $5.

Right-click the header of row 5. From the pop-up menu, select Print on Every Page.

From the Page Layout tab, click Print Titles. In the Sheet tab, click in Rows to Repeat at Top, then click the header of row 5.

Answer

Correct Answer: From the Page Layout tab, click Print Titles. In the Sheet tab, click in Rows to Repeat at Top, then click the header of row 5.

Explanation:

Note: This Question is unanswered, help us to find answer for this one

Excel Skill Assessment

Your Skill Level: Poor

Retake Quizzes to improve it