From: Summer on 30 Apr 2010 18:04 I'm working with multiple Ledger Sheets (Account Balance, Credit Card Statement, etc...) and the column headers will only show on the first page, and I would like to see them at the top of every page. Freeze Panes is grayed out, but freezing the top row is exactly what I want to happen. Do ledger sheets have another way to freeze the top row? I've looked through the discussion boards and couldn't find anything about ledger sheets. I'm working on a Mac using Office 2008 for Mac. Thank you.
From: Simon Lloyd on 1 May 2010 02:39 Unless you have the sheet or workbook structure protected there shouldn't be any reason why you can't click A2 and then freeze panes! S u m m e r ; 7 1 4 1 5 0 W r o t e : > I'm working with multiple Ledger Sheets (Account Balance, Credit Card Statement, etc...) and the column headers will only show on the first page, and I would like to see them at the top of every page. Freeze Panes is grayed out, but freezing the top row is exactly what I want to happen. Do ledger sheets have another way to freeze the top row? I've looked through the discussion boards and couldn't find anything about ledger sheets. I'm working on a Mac using Office 2008 for Mac. Thank you. -- Simon Lloyd Regards, Simon Lloyd 'Excel Chat' (http://www.thecodecage.com/forumz/chat.php) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?u=1 View this thread: http://www.thecodecage.com/forumz/showthread.php?t=199898 http://www.thecodecage.com/forumz
|
Pages: 1 Prev: linking to access database Next: ! Stolen by Sanketham ! Excel Function Dictionary |