Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
locking multiple rows in excel 03
I am trying to lock two seperate rows in excel 03 so that I can view both the
column titles at the top of work sheet and the column totals at bottom of work sheet simultaneously. In other words, I'd like to be able to freeze rows 1-3 at the top of the sheet and row 101 at the bottom of the sheet and scroll the remaining 97 rows in-between. any help would be appreciated greatly. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
locking multiple rows in excel 03
Place your column totals formulas at the top of the sheet under the header
row, then freeze the header and totals rows. HTH Otto "pitt99" wrote in message ... I am trying to lock two seperate rows in excel 03 so that I can view both the column titles at the top of work sheet and the column totals at bottom of work sheet simultaneously. In other words, I'd like to be able to freeze rows 1-3 at the top of the sheet and row 101 at the bottom of the sheet and scroll the remaining 97 rows in-between. any help would be appreciated greatly. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
locking multiple rows in excel 03
Hi,
You could use the Windows Split feature. After you split the windows horizontally, scroll to row 101 in the lower window and in the upper window you could scroll between row 3 and 100 -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "pitt99" wrote in message ... I am trying to lock two seperate rows in excel 03 so that I can view both the column titles at the top of work sheet and the column totals at bottom of work sheet simultaneously. In other words, I'd like to be able to freeze rows 1-3 at the top of the sheet and row 101 at the bottom of the sheet and scroll the remaining 97 rows in-between. any help would be appreciated greatly. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Locking rows | Excel Discussion (Misc queries) | |||
Locking rows or Regions in Excel worksheets | Excel Worksheet Functions | |||
Locking rows in Excel 97 | Excel Discussion (Misc queries) | |||
locking rows | Excel Discussion (Misc queries) | |||
How to view tiled Excel worksheets by locking rows for scrolling . | Excel Worksheet Functions |