Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Mirror formating changes in seperate worksheet
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Duplicating/Mirror Data into another worksheet within same workboo | Excel Worksheet Functions | |||
How do I have seperate headers for seperate pages in 1 worksheet? | Excel Discussion (Misc queries) | |||
Mirror Columns accross worksheet | Excel Discussion (Misc queries) | |||
Wanted: Worksheet Tabs that "mirror" the first few columns of Pre | Excel Discussion (Misc queries) | |||
Chart in seperate worksheet | Charts and Charting in Excel |