Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I know how to freeze a single point (for rows) and a single point (for
columns) and how to do it at the same time. What I want to be able to do is: Freeze Rows 1-3 Freeze Rows 381-382 In other words, I want the top of the worksheet to show rows 1-3 at all times and the bottom of the worksheet to show Rows 381-382 at all times. Is there a way to do this? Example: R1: Title 1 || Title 2 || Title 3 R2: SubT1 || SubT2 || SubT3 R3: SubT4 || SubT5 || SubT6 ------------------------------------ R4: R5: R6: ------------------------------------ R381: Col1 | Col 2 | Col 3 R382: Total1|Total2|Total3 -- Dawg House Inc. "We live in it, therefore, we know it!" |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Display multiple lines of text within a cell from multiple column. | Excel Worksheet Functions | |||
work with multiple workbooks on separate monitor for 2003 edition | Excel Worksheet Functions | |||
macro copy/paste data from multiple cells to multiple cells | Excel Discussion (Misc queries) | |||
Adding multiple worksheets | Excel Worksheet Functions | |||
Can I freeze multiple rows? | Excel Discussion (Misc queries) |