[mso] Re: Excel 2000 - question

Pam, is the total you want to monitor, only in one cell?  Once, when I
need to do this, I used cell A1 to monitor the total.  For instance,
if the total I wanted was in cell z100, I put the formula =z100 in
cell A1, so I got a duplicate of the total where I could always see
it, because I had the rows and columns frozen.


Christine
>
> 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
> >
> >
>
> > Behalf Of Pam
> >
> > 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: