Re: Updating grouped cells

Giganews Newsgroups
Subject: Re: Updating grouped cells
Posted by:  Joerg (…@email.address)
Date: Fri, 12 Jan 2007

Probably not. But if you have to do that frequently, why not select the cost
centres individually (I know, that's what you want to avoid, but you have to
do it only once) and give this selection a name in the 'name box' (the upper
left thing). Next time just select your cost centre(s) from that name box.


"Tripper" <tripper6…> wrote in message
> I am trying to select only the lowest level cells in a spreadsheet with
> grouped columns.
> The spreadsheet has cost centres grouped into departments.  The
> departments are grouped into divisions.  The cost centres get their
> values from other sheets and workbooks.
> I would like to be able to change the formulas in the cost centre
> columns only - without disturbing the sum formulas in the department
> and division columns.
> Is there a quick way to select only the cost centre cells in a row
> without selecting them individually?


In response to

Updating grouped cells posted by Tripper on 8 Jan 2007