7

Anybody know how to insert multiple blank rows in Excel all at once? Right now I right-click->Insert but that does just one row.

Thanks

2 Answers 2

7

To insert 10 rows:

Select 10 rows and press [CTRL][+]

also

To delete rows select them and press [CTRL][-]

3

Figured it out: highlight multiple rows and then when you do right-click->Insert, it will insert as many new blank rows as you've highlighted.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .