[mso] Re: Excel 2000 - question

If you freeze the last column, it will freeze everything to the LEFT of
it, like I said....so you want the columns that are frozen to be on the
left end of your spreadsheet, not the right

This is why I suggested putting a formula to give the column total in
column A...you don't need to put the whole column there, just the total
so you can see it right?

And if you want to do this on all your sheets at once, just group the
sheets first, then whatever you do on one will be done on all (do you
know how to group sheets?)

Actually, here's what I would do

Add a new column to the left of column A....since you already have your
top row frozen, why don't you just put your formula in A1, then you
don't even need to freeze that column.....lets say the column you are
trying to monitor is column R and the data in that column is from R2 to
R695....all you need to do is put a formula in A1 that says
=SUM(R2:R695).....then you will always see that cell at the top left
corner of your spreadsheet..and you can also add conditional formatting
to it if you want

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:50 PM
To: mso@xxxxxxxxxxxxx
Subject: [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 

*************************************************************
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: