[mso] Re: Excel 2000 - question

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: