[mso] Re: (to Pam) Excel 2000 - question

Hi Pam,

At 16:12 29/06/02 -0500, Pam wrote

>Hi Wilson,
>Sorry to take so long to get back to everyone.  I am not on the same machine
>now that I was on when I was trying to accomplish this.  I won't be back on
>it until next Tuesday and I will give your suggestion a whirl.
>On the grouping... you and Linda mentioned that whatever you do to one sheet
>changes on the other sheets too.  Does this include data entered in cells or
>just formatting and formulas?  And what if they aren't exactly the same now
>when I go to group them?

When you group the sheets, everything (well, almost everything - the window 
splitting and pane freezing part doesn't seem to work on grouped sheets - I 
just tried it out in Excel 2000 and it worked only while the sheets were 
grouped, after ungrouping them the windows stayed frozen only in the first 
sheet I selected to group) you do on one of them is done on the others *as 
long as they are grouped*  (as soon as you deselect them by clicking on any 
of the sheet tabs except the first one they get ungrouped, though of course 
the modifications you made remain on the sheets). But cells you don't touch 
aren't modified. It's like you were doing the exact same thing to every 
grouped sheet one after the other.
Well, the sheets don't have to be exactly the same *except* on the regions 
you're going to modify them. In the example I gave, the only thing that has 
to be the same on all your sheets is the position of the column you already 
use on the sheets to monitor the values. If this column is on different 
positions on each sheet then you'll have to do it sheet by sheet.
Wilson

 > -----Original Message-----
 > From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx]On
 > Behalf Of Wilson Baptista Junior
 > Sent: Friday, June 28, 2002 4:30 PM
 > To: mso@xxxxxxxxxxxxx
 > Subject: [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
*************************************************************

Other related posts: