[mso] Re: Excel 2000 - question

My daughter laughs at me when she sees me talk to my computer when I get a 
message that has something something neat sounding in it.
No I don't know how to group sheets but it sounds like a fantastic thing.  I 
don't know how many times I've gone through one sheet at a time making a 
change or just not changed something at all because it was too much work to 
change all sheets.
As for the column I want to monitor, I don't immediately see a way to adapt 
it to just putting the results in A1 as you mentioned (although it would be 
great if I could).  I am entering data across a row and the column I am 
monitoring is what I call a 'verify' column that I set up to tell me if I'm 
off balance on any row.  The formula in in each cell is similar to 
=N125-(O125+P125+R125-T125+V125).  Since it is checking information going 
across the page and each sheet will vary in length do you see a way to do 
it? 

Pam 


Linda Johnson writes: 

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