Question: You have a worksheet in Excel that will print as 10 pages. How can you ensure that the header row is printed at the top of each page?
- Use Print Titles on the Page Layout tab.
- Use Page Setup from the Backstage View.
- Use Freeze Panes on the View tab.
- Format your data as a table; the header prints automatically.
Answer: The correct answer of the above question is Option A:Use Print Titles on the Page Layout tab.