ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Inserting Rows in Excel that will save.. (https://www.excelbanter.com/excel-discussion-misc-queries/221355-inserting-rows-excel-will-save.html)

Jay

Inserting Rows in Excel that will save..
 
How to insert a row in an Excel Spreadsheet that will copy in all of the
following sheets after?

JBeaucaire[_90_]

Inserting Rows in Excel that will save..
 
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.
--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"Jay" wrote:

How to insert a row in an Excel Spreadsheet that will copy in all of the
following sheets after?



All times are GMT +1. The time now is 02:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com