Inserting Rows in Excel that will save..

  • Thread starter Thread starter Jay
  • Start date Start date
J

Jay

How to insert a row in an Excel Spreadsheet that will copy in all of the
following sheets after?
 
Click on the first sheet you want to insert a row into. Hold the SHIFT key
down and click on the last sheet. All the sheets in between plus the two you
clicked are now "grouped" and all should be highlighted. Any change made on
one is mirrored in them all.

So, on the sheet still visible, insert the row you want and do any
formatting necessary. Then right-click on a sheet tab and UNGROUP them.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel-Adding rows to master sheet that will be inserted on following worksheets 1
How can I insert rows BELOW, in Excel 1
Alt codes 4
Excel Question on Formatting Cell and Adding a Row in Excel 2013 1
Excel Unable to insert cut rows into Excel online anymore? 0
how do I insert row keeping formulas from previous row? 1
Inserting Rows at Excel 2007 1
make excel copy a row and automatically insert new rows 2

Back
Top