Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
hhh
 
Posts: n/a
Default i discover that i cannot scroll in each part if i simply freeze p.

i discover that i cannot scroll in each part if i simply freeze panes. is
there another way i can create panes in worksheet that would allow me to
scroll in each pane independently?
  #2   Report Post  
Arvi Laanemets
 
Posts: n/a
Default

Hi

For what do you want to use this feature? It's meant to keep some amount of
leftmost and/or topmost columns always visible. You scroll the remaining
part of sheet.

Arvi Laanemets


"hhh" wrote in message
...
i discover that i cannot scroll in each part if i simply freeze panes. is
there another way i can create panes in worksheet that would allow me to
scroll in each pane independently?



  #3   Report Post  
P Daulton
 
Posts: n/a
Default

Try using Windows|Split instead?

Pascal

"hhh" wrote in message
...
i discover that i cannot scroll in each part if i simply freeze panes. is
there another way i can create panes in worksheet that would allow me to
scroll in each pane independently?



  #4   Report Post  
Gord Dibben
 
Posts: n/a
Default

hhh

Try WindowNew Window then WindowArrange. I personally prefer "Vertical"
orientation.

Gord Dibben Excel MVP

On Mon, 6 Dec 2004 23:05:55 -0000, "P Daulton"
wrote:

Try using Windows|Split instead?

Pascal

"hhh" wrote in message
...
i discover that i cannot scroll in each part if i simply freeze panes. is
there another way i can create panes in worksheet that would allow me to
scroll in each pane independently?



  #5   Report Post  
Dave Peterson
 
Posts: n/a
Default

Jim Rech posted this:

http://groups.google.com/groups?selm...%40cppssbbsa03

It may do what you want (well, if you change it to Trues).

And I think that I've seen posts that this is built into xl2003. (but not sure)


If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

hhh wrote:

i discover that i cannot scroll in each part if i simply freeze panes. is
there another way i can create panes in worksheet that would allow me to
scroll in each pane independently?


--

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
Shared File & Freeze panes issue JM Excel Discussion (Misc queries) 0 January 21st 05 07:01 PM


All times are GMT +1. The time now is 05:18 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"