Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Subform in excel or Frozen Panes (Top & Bottom)
Is there a way to have two types of frozen panes?
Let's say Rows 1 & 2 are the heading of the file and needs to be frozen and some other rows are the criteria which you want to be displayed on the bottom? Let's say row 1000 to 1005 and the rest of the table is displayed within the two frozen panes. Can this be done? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Subform in excel or Frozen Panes (Top & Bottom)
Nope.
You may be able to use: Data|Window|new window and arrange separate windows on the screen so that you can always see rows 1000-1005 on that bottom window. But it's not the same. Santa-D wrote: Is there a way to have two types of frozen panes? Let's say Rows 1 & 2 are the heading of the file and needs to be frozen and some other rows are the criteria which you want to be displayed on the bottom? Let's say row 1000 to 1005 and the rest of the table is displayed within the two frozen panes. Can this be done? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Scroll bar disappears when panes frozen | Excel Discussion (Misc queries) | |||
Print Frozen Panes? | Excel Discussion (Misc queries) | |||
frozen panes | Excel Discussion (Misc queries) | |||
Frozen panes in Excel should stay put when using autofilter. | Excel Discussion (Misc queries) | |||
How do I Hide frozen panes when printing? | Excel Worksheet Functions |