making changes "down" though sheets in a workbook

  • Thread starter Thread starter David Mansfield
  • Start date Start date
D

David Mansfield

I have several sheets in a workbook and I want to make
changes to several formulas in the first sheet and push
them "down through" all the sheets. The cells are in the
same place on each sheet.
Is this possible?
Thank you.
 
Hi David,
Would grouping the worksheets be what you are looking for.
You might want to make a copy of your workbook before trying this.

Group the sheets by selecting a sheet and adding other to the group
with the Ctrl key. There is also rightclick Group all sheets.
Any change you make to a cell will be as if also typed into each
of the other grouped worksheets as well. You can test by
also adding a color to a cell.

Obviously once you've done what you wanted to don't want to keep
groupe sheets in effect because you could destroy your workbook
very quickly. So to ungroup sheets you can select one sheet,
or much safter rightclick on sheettab and then "ungroup sheets".
 
You could make the changes on the first sheet. Next select
and copy all cells that you changed. You should be able
to paste/special formulas into the other worksheets.
 
If you mean you want the same changes made on all sheets that you ar
making to one sheet then do this:

With the first sheet active hold down the shift key and select the las
sheet tab. You now have all sheets grouped. Whatever you do on th
first sheet will happen on all sheets. Remember to ungroup the sheet
when you're done.

This will do what you want if all your formulae pertain to their ow
sheets
 
Back
Top