MrExcel Publishing
Your One Stop for Excel Tips & Solutions

inserting rows

Posted by Jim Price on February 08, 2002 1:17 PM

Here lately, I've been doctoring up spreadsheets to make it easier for the bosses here to read.

I sometimes need to insert several blank rows between rows of data. Is there a way to insert more than one row at a time?

Posted by Juan Pablo G. on February 08, 2002 1:37 PM

Select the number of rows you want to insert, and insert rows (Or hit Control +)

Juan Pablo G.

Posted by Chris D on February 09, 2002 3:46 AM

also, if you need to insert in different places (say some at row 4, some at row 15 and a few at row 20) keep CNTRL pressed as you select all three - it will insert all in one go rather than you having to do 3 seperate inserts