9. Tables, Freeze Panes and Printing

An Excel Table (Ctrl+T) turns a range into an object: a header row with filters, banded rows, automatic expansion when you add data, and a Total Row. Formulas inside it use structured references: =[@Price]*[@Qty] or =SUM(Sales[Amount]). They are easier to read than $C$2:$C$500 and do not break when the table grows.

Freeze Panes (View › Freeze Panes) keeps the header row in place while you scroll.

Merged cells get in the way of sorting, filtering and copying. To center a title across several columns, it is better to use Format Cells › Alignment › Center Across Selection.

Printing: on the Page Layout tab you can set the orientation and margins, use "Fit All Columns on One Page" (or Fit to 1 page wide), set Print Titles (rows to repeat at the top), and add a footer with page numbers. To save as PDF, go to File › Export.

The trainer has no Excel Tables or printing, so these topics are covered by the quiz. Try them in real Excel on the file from the Project P01 lesson.