![]() |
double freeze pane
Excel 10 (office XP) sp3
Is it possible to freeze the top few lines and the bottom few lines of a sheet so that when you scroll down only the middle section moves. I have headings at the top and totals at the bottom and I would like them visible at all times if possible. Thanks |
double freeze pane
I don't know about double freezing, but you cd put the totals at the top just under the headings, and enlarge the frozen pane to accomodate. -- Nyq ------------------------------------------------------------------------ Nyq's Profile: http://www.excelforum.com/member.php...o&userid=35380 View this thread: http://www.excelforum.com/showthread...hreadid=551675 |
double freeze pane
"Nyq" wrote in message
... I don't know about double freezing, but you cd put the totals at the top just under the headings, and enlarge the frozen pane to accomodate. .... or fire up a second (new) window, arrange horizontally, and have the lower window with just the totals, and freeze-pane the upper window containing the headings and the data in the middle section. |
All times are GMT +1. The time now is 11:07 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com