MS Excel Tip: Printing - repeating column headers

If your rows spill over onto multiple pages, you can specify rows to repeat at the top of each page, so that each printed page shows the column headers. This is so much easier than having to flick back to page 1 to determine the heading of the column that you’re looking at on page 5! Page Layout > Print Titles will get you to the right place within Page Setup window. With your cursor in the Rows to Repeat at Top field simply select the row(s) to repeat by dragging your cursor across the relevant row numbers and click on OK.

MS Excel Tip: Printing

One often needs to do a quick Print of a worksheet or part thereof. In the old days, this required either scissors, sticky tape and glue or a radical manipulation of one’s spreadsheet layout. Now there are some neat features in the printing options of Excel which can help avoid all that! Printing Selection: If you just want to print a portion of your spreadsheet, simply highlight the Cells that you want to Print and then under your Print Settings change from Print Active Sheet to Print Selection. Scaling the content to fit on One Page: Sometimes the content we want to Print doesn’t quite fit on one page which can be frustrating. Some columns may push over to a new page or sometimes we have a

Training Offices:


106 Johan Avenue, Sandton


1 Tamarind Close, Umhlanga


400 Old Howick Road, Hilton

Corporate Onsite Training Available Countrywide

  • Summit Solutions Excel Training
  • Summit Solutions Excel Training
  • Summit Solutions Excel Training

Tel: 086 167 3923


Head Office: Hilton Quarry Office Park, 400 Old Howick Road, Hilton.

2020 | Copyright | Summit Solutions