You can do this too
Download "The one essential add-in for all Excel users."
“Working in Excel will be fun again with all these extra supersmart tools”
ASAP Utilities, description of our Excel tools
English (us) / Nederlands / Deutsch / Español / Français / Português do Brasil / Italiano / Русский / 中文(简体) / 日本語Columns & Rows » Insert multiple empty rows at once...
This utility inserts multiple rows at once.The utility inserts the specified number of rows above the active cell.
Normally if you want to insert multiple rows at once the standard procedure is to first select multiple rows and then use the "Insert" command.
For example if you want to insert 10 rows between A1 and A2, you first have to select rows 2:11 and then insert the rows.
With this utility you can now quickly insert multiple rows at once.
Screenshots
Example screenshot: Insert multiple empty rows at once
Starting this utility
In the Excel menu choose: ASAP Utilities » Columns & Rows » Insert multiple empty rows at once...« Return to the list of “Columns & Rows” tools.
| « Previous Insert empty rows or columns in between... | Next » View and manage hidden rows and columns... |
You can do this too
Download "The one essential add-in for all Excel users."
Additional keywords for this tool:
several, insert more than one row at a time, blank, entire
several, insert more than one row at a time, blank, entire
© 1999-2021 - Bastien Mensink - ASAP Utilities - A Must in Every Office BV - The Netherlands
Connect with us and receive our tips that show you how to benefit from the tools in ASAP Utilities at:
