The Complete Excel Guide: Beginners to Advanced - Print Titles

This video tutorial covers the setup of print titles in Excel, allowing users to print column headings on every page of a multi-page spreadsheet. It demonstrates how to select rows to repeat at the top of each page and provides a walkthrough of the print preview and print options. The tutorial also explains how to repeat columns on every page and concludes with a transition to the next section on working with comments.

Why might it be problematic to print a multi-page spreadsheet without setting print titles?

• The spreadsheet will not print at all.

• The spreadsheet will print in reverse order.

• Subsequent pages will lack column headings.

• The spreadsheet will print in black and white.

What is the first step in setting up print titles in Excel?

• Go to the 'Home' tab.

• Open the 'Data' tab.

• Select the 'File' tab.

• Navigate to the 'Page Layout' tab.

How do you select rows to repeat at the top of each page in Excel?

• Type the row numbers manually.

• Select the 'View' tab.

• Click on the row heading itself.

• Use the 'Insert' tab.

What additional option does Excel provide for printing long documents?

• Adding page numbers.

• Printing in landscape mode.

• Repeating columns on every page.

• Printing in color.

Which option is more commonly used when setting up print titles?

• Rows to repeat at top.

• Pages to repeat at end.

• Columns to repeat at left.

• Sheets to repeat at bottom.