Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 34
Default 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   Report Post  
Posted to microsoft.public.excel.programming
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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Scroll bar disappears when panes frozen AIS Jay Excel Discussion (Misc queries) 0 March 30th 10 04:55 PM
Print Frozen Panes? CyberSockeye Excel Discussion (Misc queries) 2 April 23rd 08 10:23 PM
frozen panes jmack Excel Discussion (Misc queries) 2 May 11th 07 09:00 AM
Frozen panes in Excel should stay put when using autofilter. stuckfly Excel Discussion (Misc queries) 8 March 10th 06 06:18 PM
How do I Hide frozen panes when printing? Stargiddy Excel Worksheet Functions 0 December 20th 05 06:10 PM


All times are GMT +1. The time now is 03:50 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"