ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I add many rows in between existing rows in spreadsheet? (https://www.excelbanter.com/excel-worksheet-functions/181405-how-do-i-add-many-rows-between-existing-rows-spreadsheet.html)

MarshaMarsha

How do I add many rows in between existing rows in spreadsheet?
 


Ivyleaf

How do I add many rows in between existing rows in spreadsheet?
 
Hi Marsha,

Assuming you wanted to add say 10 rows in between rows 20 & 21, click
on the row 21 row header and drag down 10 rows (they should all
highlight) then just right click somewhere in the highlighted area or
on one of the highlighted row headers and select 'Insert' from the pop
up menu.

This is just one method anyway.

Cheers,
Ivan.

On Mar 27, 4:28*am, MarshaMarsha
wrote:




All times are GMT +1. The time now is 11:50 PM.

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