Subform in excel or Frozen Panes (Top & Bottom)

[Santa-D]

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]

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.