Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I freeze different rows? Can anyone help?
Hi Everyone, My excel skills are basic so hopefully you'll understand what I want to do... I have created a sheet with headers/titles at the top of the columns on a sheet and at the bottom of the sheet (all on one page) are the totals. I wish to freeze the top 4 rows so they dont move and the bottom 3 rows so when you use the scroll bar only the middle part of the sheet moves. This is so you can see the headers for each column and the totals at the bottom of the screen at all times. Is this even possible? Hope someone understands what I mean. I have tried using the freeze pane function but it seems I can only freeze either the top or the bottom not both. Any help would be greatly appreciated. Thanks Grant -- starlet ------------------------------------------------------------------------ starlet's Profile: http://www.excelforum.com/member.php...o&userid=36569 View this thread: http://www.excelforum.com/showthread...hreadid=563144 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying multiple rows to other worksheets (but amount of rows varies) - How? | Excel Discussion (Misc queries) | |||
(Unsuccessfully!) Unhiding Rows in Excel 2003 | Excel Worksheet Functions | |||
Rows & Columns in Excel | Excel Worksheet Functions | |||
Hiding Rows if the linked rows are blank | Excel Discussion (Misc queries) | |||
Row selections by row # OR by even/odd rows in another spreadsheet | Excel Discussion (Misc queries) |