how do I make changes in several worksheets at once?
 

My boss has an existing workbook with several worksheets in it. He wants me
to add several rows. Is there any way I can make the changes in one sheet,
then have the rest of the sheets automatically updated? The rows need to
contain formulas. I would appreciate any help you could give me.
Thanks.

Becky

If what you want to change is all in the same place on each sheet then you
can group them.

Click on one sheet tab, hold shift key down and select another you will
notice all in between are now selected. Everything you now do to a sheet
will reflect in them all.

Ctrl and select a tab will select non-contiguous sheets. Right click on one
and select ungroup when you are done or click on one not selected will also
do it

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS

"becky" wrote in message
...
My boss has an existing workbook with several worksheets in it. He wants
me
to add several rows. Is there any way I can make the changes in one sheet,
then have the rest of the sheets automatically updated? The rows need to
contain formulas. I would appreciate any help you could give me.
Thanks.

Thank you, Mr. Hodge. I hope I'm not being presumptuous in asking 2
additional questions: I need to add rows (with formulas) in all of these
worksheets. If I insert rows after a row with the correct formulas in it,
will the inserted rows contain those formulas automatically? If not, is there
a way I can insert rows with the formulas or will I have to copy and paste
from the row above?
Thanks again,
Becky

"Nick Hodge" wrote:

Becky

If what you want to change is all in the same place on each sheet then you
can group them.

Click on one sheet tab, hold shift key down and select another you will
notice all in between are now selected. Everything you now do to a sheet
will reflect in them all.

Ctrl and select a tab will select non-contiguous sheets. Right click on one
and select ungroup when you are done or click on one not selected will also
do it

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS

"becky" wrote in message
...
My boss has an existing workbook with several worksheets in it. He wants
me
to add several rows. Is there any way I can make the changes in one sheet,
then have the rest of the sheets automatically updated? The rows need to
contain formulas. I would appreciate any help you could give me.
Thanks.

Becky

once you group the sheets, insert the row on one of them and copy any paste
from the row above, This too will copy on all sheets

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS

"Becky" wrote in message
...
Thank you, Mr. Hodge. I hope I'm not being presumptuous in asking 2
additional questions: I need to add rows (with formulas) in all of these
worksheets. If I insert rows after a row with the correct formulas in it,
will the inserted rows contain those formulas automatically? If not, is
there
a way I can insert rows with the formulas or will I have to copy and paste
from the row above?
Thanks again,
Becky

"Nick Hodge" wrote:

Becky

If what you want to change is all in the same place on each sheet then
you
can group them.

Click on one sheet tab, hold shift key down and select another you will
notice all in between are now selected. Everything you now do to a sheet
will reflect in them all.

Ctrl and select a tab will select non-contiguous sheets. Right click on
one
and select ungroup when you are done or click on one not selected will
also
do it

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS

"becky" wrote in message
...
My boss has an existing workbook with several worksheets in it. He
wants
me
to add several rows. Is there any way I can make the changes in one
sheet,
then have the rest of the sheets automatically updated? The rows need
to
contain formulas. I would appreciate any help you could give me.
Thanks.

Please don't post the same message separately on more than one group. It may
lead to someone answering a question which has already been answered on
another group.



"becky" wrote in message
...
My boss has an existing workbook with several worksheets in it. He wants
me
to add several rows. Is there any way I can make the changes in one sheet,
then have the rest of the sheets automatically updated? The rows need to
contain formulas. I would appreciate any help you could give me.
Thanks.