how do I make changes in several worksheets at once?

[Becky]

My boss has an existing workbook that contains several worksheets. He wants
me to go in and add rows to all of the worksheets. The additional rows need
to have formulas in them. I guess I've got 2 questions - when I insert the
additional rows, will the formulas in the row above be automatically copied?
and - Is there any way I can copy the changes from one worksheet within a
workbook to the rest of the sheets in the workbook? I'd appreciate any help.
Thanks.

 

[Dave R.]

You can select sheets by holding CTRL and clicking on the sheet tabs. Now if
you make a change to one (say entering "apple" in A1), you've made the
change to all. This will be helpful when you insert rows and insert formulas
in those rows. When you insert rows, nothing will automatically copy, but
any formulas referring to, or referring to cell or a range below, those
rows, will change to accomodate them (unless you've used INDIRECT in the
formula that references the cells/rows).

You can unselect all sheet tabs at once by clicking on any individual tab
with your left mouse button.