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
Super User is a question and answer site for computer enthusiasts and power users. It only takes a minute to sign up.
Sign up to join this communityTo insert 10 rows:
Select 10 rows and press [CTRL][+]
also
To delete rows select them and press [CTRL][-]
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.