[mso] Re: Excel 2000 - question

Hi Pam,
suppose you're monitoring column PQ, for example.
a) insert a new column in the first position.
b) Input in cell A2 the formula:  =PR2  (because your monitoring column 
will now have shifted to PR)
This will repeat the results from the formula in your monitoring column in 
the new A column.
c) Select cell B2, split windows, freeze rows.
You will now have column A (which will "mirror" your monitoring column) 
fixed along with your column headings.

As for grouping sheets, if you select the first sheet tab then hold down 
the "shift" key and click on the tab of the last sheet, all the sheet tabs 
will be selected and whatever you do on any one of them will be done in all 
of them. So just select the range of sheets you want to alter *before* 
doing steps 1 to 3 and it will be done to every one of the selected sheets.
For safety's sake, you can make a copy of your workbook first and try this 
out on the copy.
Wilson

At 19:25 28/06/02 +0000, Pam wrote

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


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