Mirror formating changes in seperate worksheet

  • Thread starter Thread starter Biff
  • Start date Start date
B

Biff

I'm not sure if there is a function for this, but I have two worksheets that
will having the same core structure (same column headings and rowing
headings, but different data). I want to know if there is a way that if I
add a row in the second worksheet. Any help?
 
Hi,

You question is not complete? You can always add a row in a second
worksheet, just right click the row number and choose Insert.

If you want the have changes you make to one sheet duplicated in another
then hold down the Ctrl key and select all the sheets you want to change.
You will be in group mode and anything you do to one of the selected sheets
gets done to all. Be careful, when you are finished remember to ungroup the
sheets - right click a sheet tab and choose Ungroup.

If this helps, please click the Yes button

Cheers,
Shane Devenshire
 
Back
Top