[mso] Re: Excel 2000 - question

The freeze pane suggestion sound great but moving that column would be a lot 
of problems because it's on several dozen or more sheets.  It's actual 
placement is next to last column of the spreadsheet. Is there an easy way to 
change that many sheets, and do you think the last column (right most 
column) would work as well as the first?

Pam 

Linda Johnson writes: 

> 
> Well...you can freeze a column AND a row...but I think it would work
> best if you put the column you want frozen in A 
> 
> To freeze a column and a row, just click in the cell where you want the
> freeze to be above and to the left of (first go to Window menu and undo
> the freeze you have)...for example, to freeze column A and row 1, click
> in B2....it will freeze everything to the left of column B and
> everything above row 2 
> 
>  
> 
> Linda
> Publisher ~ ABC ~ All 'Bout Computers
> Owner ~ Linda's Computer Stop
> http://personal-computer-tutor.com
> FREE MS Office eBook Tutorial
> http://personal-computer-tutor.com/library.htm
>   
> 
> 
> -----Original Message-----
> From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
> Behalf Of Pam
> Sent: Friday, June 28, 2002 2:31 PM
> To: mso@xxxxxxxxxxxxx
> Subject: [mso] Re: Excel 2000 - question 
> 
>  
> 
> It might work if you can have more than 1 set of freeze panes.  Right
> now I 
> have column heading rows frozen across the top.  If I could freeze pane
> that 
> column too the I wouldn't need the color change deal becaue I could
> visually 
> monitor it.  It's because it's umpteen columns past the usual work area
> that 
> I was looking for a way to alert me. But I understood you could only
> have 
> one freeze pane.  Tis not true? 
> 
> Pam  
> 
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx?Subject=unsubscribe

Or, visit the group's homepage and use the dropdown menu.  This will also allow 
you to change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

Other related posts: