adding rows to ALL worksheet (all in one)

  • Thread starter exhausted everything
  • Start date
E

exhausted everything

Can when I add a row to one worksheet (the main one), is there a
functionality that will add that row to all the worksheets within the same
workbook?
 
C

Chip Pearson

You can group the worksheets, so that a change made to one will
also be made to the other. To group the sheets, hold down the
CTRL key while clicking the sheet tab. You'll notice that
"[Group]" is displayed in the application title bar. To ungroup
the sheets, right click one of the sheets and choose "Ungroup
Sheets".


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"exhausted everything"
 
Top