Search Not Just Numbers

Tuesday, 10 December 2013

Excel Tip: Show titles on every page of a report

Before we get into today's post, I just want to give you a quick update on an earlier post.

A couple of month's back I mentioned that I was writing a publication for the Institute of Chartered Accountants in England and Wales (ICAEW) on automating management accounts in Excel. A number of you asked to know when the publication would be available.

Well, it is now. Members of the ICAEW IT Faculty or Excel Community have already received a hard copy in the post.

At the following link you can either purchase a copy (from the ICAEW) or join the ICAEW Excel Community and then download it free if charge:

Automating management accounts production in Excel: a simple approach

OK, on with today's post. Many Excel spreadsheets are written with the intention of the output being printed. This sometimes causes a challenge when the spreadsheet spans multiple pages and we want the titles to appear on every page. Well, Excel has a solution (CLUE: It's not to break the sheet up into pages and enter the titles at the top of each page).

On the Page Layout ribbon, click on the Print Titles icon.

(In earlier versions of Excel, you can get to the same screen by choosing File, Page Setup and selecting the Sheet tab).

You will see the following window:

In the Print titles section, you can specify the rows you want to repeat at the top of every page by clicking in the "Rows to repeat at top:" box and selecting the rows that include your titles.

As you can see there is also a box to allow you to repeat columns if your print will straddle multiple pages horizontally. This is much less common, but can sometimes be useful.

Note that neither setting changes the spreadsheet that you see on the screen - just what is printed.

Excel Expert Course

If you enjoyed this post, go to the top of the blog, where you can subscribe for regular updates and get two freebies "The 5 Excel features that you NEED to know" and "30 Chants for Better Charts".


  1. Slim replacement affordable handbags havenuck your option to along with the of more than an individual way direction and may also these days get measured as being an necessary for all fashion-forward fellow. Yet, similarly to some of the most famous traits, kinny replica chanel handbags at all times straightforward get hold of ideal. To seek superior during those tight-legged trousers, you might want to makeure everyone don't just obtain ideal in good shape, you need to makeure that will accessorise good. By using a couple very useful hints and tips, you could crush an individual's fear of figure-hugging underside together with explore any wonder ofkinny replica louis vuitton handbags all by yourself. Just about the most significant a natural part of introducingkinny replacement affordable handbags towards an individual's clothes stands out as the mowoment everyone check out him or her regarding meant for to begin with. A close in good shape is a must to include out thetyle you usually do not prefer fake tag heuer watches areo firm it's certainly caused by likely toee any exacthape to your limb thru him or her. On the other hand, everyone wantkinny replacement affordable handbags thatkim about an individual's thighs together with calf muscles. Dispose of at a pea replacement affordable handbags or simply atructured army-style replacement affordable handbags for the effortlesslytylish appearance. Then again, you could squad an individual's replica breitling watches by using a bright white t-shirt in addition to a synthetic leather motor cyclist replacement affordable handbags for that legitimate rocktar ambience. Accessorising withkinny replacement affordable handbags commonly be installed once you know the way in which, otock away onome well-fitting womenskinny fake rolex dateJust and become available tohow out an individual's limbs – with your well-developedense oftyle.