#1   Report Post  
rexmann
 
Posts: n/a
Default Freeze Panes

Hi all

I am not sure this is possible but can you freeze more than one column in
Excel which are not next to each other. Example Freeze Column B and F (but
not the others)? so they stay on the screen at the same time but allow
scrolling?

Any help greatly appreciated

Rexmann

ps using Excel 2002
  #2   Report Post  
tkaplan
 
Posts: n/a
Default


if you freeze b and f, but not those in between, what do you want to
happen to the ones in between?


--
tkaplan
------------------------------------------------------------------------
tkaplan's Profile: http://www.excelforum.com/member.php...o&userid=22987
View this thread: http://www.excelforum.com/showthread...hreadid=376250

  #3   Report Post  
Ron Coderre
 
Posts: n/a
Default

Hide columns C,D,E
Select column G
WindowFreeze Panes

Does that help?

--
Regards,
Ron

  #4   Report Post  
rexmann
 
Posts: n/a
Default

Hi tkaplan

I wanted to freeze two panes and the rest scroll. I think the hiding option
is the nearest or maybe grouping

cheers Rexmann

"tkaplan" wrote:


if you freeze b and f, but not those in between, what do you want to
happen to the ones in between?


--
tkaplan
------------------------------------------------------------------------
tkaplan's Profile: http://www.excelforum.com/member.php...o&userid=22987
View this thread: http://www.excelforum.com/showthread...hreadid=376250


  #5   Report Post  
rexmann
 
Posts: n/a
Default

Thanks Ron

I think that's the best option, thanks for the input and also tkaplan

cheers Rexmann

"Ron Coderre" wrote:

Hide columns C,D,E
Select column G
WindowFreeze Panes

Does that help?

--
Regards,
Ron

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
Can't freeze panes bgarcia Excel Worksheet Functions 2 May 9th 05 05:15 PM
Not quite "Freeze Panes"..... chris Excel Discussion (Misc queries) 1 January 25th 05 06:09 PM
Shared File & Freeze panes issue JM Excel Discussion (Misc queries) 0 January 21st 05 07:01 PM
How do I change the colour of/remove the Freeze Panes line in Exce katya_1978 Excel Worksheet Functions 1 January 20th 05 06:17 PM
Why does freeze panes work on one sheet but not on another in sam. environengineer Excel Worksheet Functions 1 December 2nd 04 04:53 PM


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