View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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