printing question for excel 2003

  rsturbo 16:07 14 Jul 2006
Locked

i have a spreadsheet i need to print but it goes onto a second landscape page (no problem there) all i need to do is print the 1st page (no problem) and the 2nd page (here is the problem!) with the headings of the columns.

any help would be greatly appreciated

  sean-278262 16:24 14 Jul 2006

Reduce the font size. To be quite honest I read that 3 times and it still makes little or no sense so I am not really sure what you are after.

A

  GroupFC 16:33 14 Jul 2006

Go into file>page setup>sheet and in there should be a box "rows to repeat at the top" type a:a for example to repeat row a on each page (or a:b, which will repeat the first 2 rows) - job done!

  VoG II 16:58 14 Jul 2006

Actually you need to enter 1:1 to repeat row 1.

  GroupFC 18:21 14 Jul 2006

That was me trying to be quick and beat you to it!-LOL!

  rsturbo 09:27 24 Jul 2006

help much appreciated, can always rely on you guys to provide fast and helpful advice to a novice like me

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

OnePlus 5 review

Alice Saey's mesmerising animation for Dutch singer Mark Lotterman

iPad Pro 10.5in (2017) review

Comment booster votre iPhone ?