Excel: insert 20 rows at once instead of one at a time?

Question

I keep right-clicking and hitting Insert over and over to add blank rows in the middle of a sheet. There must be a quicker way to add a whole block of them.

hemlatav87 · Answer

Click row 5's number, shift-click row 24's number so 20 rows are highlighted, right-click > Insert. You get 20 at once. F4 also repeats the last insert if you need more.

Excel: insert 20 rows at once instead of one at a time?

Leave A Reply

1 Answer