Multiple choice technology

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

  1. Click Page Setup on the File menu, click the Sheet tab, and enter the row that contains these column headings under Print titles.

  2. Click Page Setup on the File menu, click the Page tab, click the Options button, then enter your choices.

  3. Click Page Setup on the File menu, click the Sheet tab, and make a selection under the Print heading.

  4. none of the above.
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

To print column headings on each page in Excel, you need to use the 'Print titles' feature in Page Setup. This is found under the Sheet tab where you specify which rows contain the column headings. These rows will then repeat on every printed page, making large multi-page printouts easier to read. The other options either don't address this specific need or are incorrect menu paths.

Keep practicing — related questions