[mso] Re: Excel 2000 - question
- From: "Pam" <ltf01@xxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Sat, 29 Jun 2002 16:12:47 -0500
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?
For Christine... I didn't reply directly to your question because I think I
had just answered you question in a reply to Linda a few minutes before I
saw your post.
Thank you all for being so patient with my questions. As I mentioned a
while back, all knowledge of formatting and formulas I have of Excel comes
from the spreadsheet packed in Works 3.0 of 10 or more years ago. Some of
this stuff I didn't even have a notion it was capable of doing until I see
someone talking about it.
Take care,
Pam
> -----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).
> > > //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).
> >//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).
> //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).
//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:
