ASAP Utilities for Excel - Insert a Specified Number of Empty Rows at Once...

Insert a Specified Number of Empty Rows at Once...

ASAP Utilities › Columns & Rows  ›  9. Insert a Specified Number of Empty Rows at Once...

This tool lets you quickly insert a specified number of empty rows above your selection.

For example, to insert 15 rows between A1 and A2 in Excel, you would normally have to manually select rows 2:16 and then insert them.
With this tool, simply select cell A2 and enter 15 to insert 15 blank rows between A1 and A2.

Starting this tool

Specify a Keyboard Shortcut: ASAP Utilities  › My Tools & Shortcuts › Manage My Tools & Shortcuts...

Example screenshot: Insert multiple empty rows at once (Here's the English version.)
Insert multiple empty rows at once

Additional keywords to help you find this tool:
Insert multiple empty rows in Excel, Insert blank rows at once, Bulk insert rows, Quickly insert empty rows, Excel insert several rows, Insert multiple rows above active cell, Add blank rows, Insert blank rows in one go

Designed by Excel users for Excel users.
Practical tools many Excel users wish were built into Excel.

Save Time in Excel. The Easy Way.

ASAP Utilities helps you save time and do what Excel alone can't.

You can get started right away. No training needed.

Most users start with a few tools. Many end up using ASAP Utilities daily.

Used by teams in 28,500+ organizations.

Get Started with ASAP Utilities

Start saving time in Excel with practical tools you can use right away.

  • No sign-up required.

  • Free 90-day trial