View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shane Devenshire Shane Devenshire is offline
external usenet poster
 
Posts: 857
Default Mirror formating changes in seperate worksheet

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

"Biff" wrote in message
...
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?