Excel - Print Page Set Up
You’ve just spent ages sorting out your spreadsheet and are very pleased with the end result. Now it’s time to print. You press the print button, then you see it…. “Printing 1 of 150 pages”!!! In your panic you can’t press the cancel button quickly enough…already you hear tutting and comments around the printer as people realise that their print job will not come out for ages and that whoever is printing is churning out dozens of pages with only 1 character on each page. Easily done, but equally easy to prevent.
Before pressing the print button check out the page break view on the view tab.
Next problem you have though, only the first page has your column headings displayed which makes reading the other sheets a bit more difficult. No doubt, like everyone has at some point, you work out where the page breaks are and copy/paste the first row so that each page has its own headings. Problem is, that if you add or remove any rows you then have to go through everything again to reset the headings to the correct row.
No need!
Go to the page layout tab and click on print titles.
This opens a new window and you’ll see the option to repeat rows at top or repeat columns at left. Select the row(s) and/or columns you want to see repeated…job done!
So now if you have a long document it automatically repeats the headings on every sheet or if your document is very wide it repeats the row headings for you too.
