Question

Which feature in MS Excel can be used to display column headings on every printed page ?

• A. Pagebreak
• B. Header
• C. Print Titles
• D. Cell Alignment

Answer 1

Answer:

C. Print Titles

Print Titles in MS Excel

• The Print Titles feature allows users to repeat specific rows or columns on every page of a printed document.

• This is essential for large datasets where column headers would otherwise disappear on subsequent pages, making the data difficult to read.

• Steps to access:

  • Navigate to the Page Layout tab on the Ribbon.

  • Click on the Print Titles button located in the Page Setup group.

  • In the Page Setup dialog box, under the Sheet tab, locate the field Rows to repeat at top.

  • Select the row(s) containing the headers that need to be repeated.

  • Click OK to save the settings.

  • The Print Titles command is disabled if you are in Cell Edit Mode, if multiple sheets are selected, or if the printer is not installed.

  • The headers defined in this feature will not appear on the screen during standard editing; they are exclusively applied to the Print Preview and the physical output.

  • Other related options in the Page Setup dialog include Gridlines, Row and column headings, and Comments, which can all be toggled for printing.