The ASAP Utilities menu in Excel (English)
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.
Screenshots
Example screenshot: Insert multiple empty rows at once
Starting this tool
- Click ASAP Utilities › Columns & Rows › 9. Insert a Specified Number of Empty Rows at Once...
- Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...
Additional keywords for 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
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
Choose your language preference below
English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語
| Insert Blank Rows or Columns Between Every Row or Column... |
©1999-2025 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands
🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 25 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.
🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 25 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.