Mad Moe
Member
Registered: 14th Jun 01
Location: Northumberland
User status: Offline
|
Right I've got a spread sheet that runs on to a few pages and wondered if there was a way to fix the column headings so that when I print they are still visable on the subsequent pages?
|
Matt L
Member
Registered: 17th Apr 06
User status: Offline
|
i wanted to know this aswell the other day.
|
Ojc
Member
Registered: 14th Nov 00
Location: Reading: Drives : Clio 197
User status: Offline
|
File>PageSetup>Sheet>Print Titles>Rows to repeat at top
And just highlight the rows you want at the top of each page.
|
Mad Moe
Member
Registered: 14th Jun 01
Location: Northumberland
User status: Offline
|
Spot on, cheers mate
|
Brett
Premium Member
Registered: 16th Dec 02
Location: Manchester
User status: Offline
|
No probs
|