Insert Empty Rows Or Columns At Certain Interval In Excel
If you ever want to insert empty rows or columns, for example inserting 2 empty rows each 2 rows will take much time doing it manually. Dose for Excel‘s Insert Blank Rows and Columns utility can quickly do the task with one click.
Click DOSE » Insert » Insert Blank Rows and Columns



Insert blank rows at certain interval
- Select a range of rows.
- And then apply this function by clicking on DOSE » Insert » Insert Blank Rows and Columns.
- For example, if you want to insert 1 row every 2 rows in a range then check Blank rows radio button and enter 2 in Interval of box and 1 in Rows box.
- Then click on Insert. See screenshots.



Insert blank columns at certain interval
- Select a range of columns.
- And then apply this function by clicking on DOSE » Insert » Insert Blank Rows and Columns.
- For example, if you want to insert 1 column every 1 column in a range then check Blank columns radio button and enter 2 in Interval of box and 1 in Columns box.
- Then click on Insert. See screenshots.



More Features:
Compare Lists in Excel
Compare Lists in Excel If you ever want to compare lists by looking up for…
Excel Delete Illustrations And Objects
Delete Illustrations and Objects In Excel Sheets If you ever had many sheets including a…
Excel Cells Color Assistant
Advanced Cells Formatting And Coloring In Excel Build your format and color templates by yourself,…
Excel Random Generator
Generate Random Data (Numbers, Date, String, etc…) Sometimes you want to generate some random data…
Excel Insert Before After
Insert Text Before Or After In Excel Cells You can add text before first letter…
Excel Hyperlinks Sheet Names
Convert All Your Worksheets into Hyperlinks in One Worksheet Extract all sheets names as hyperlinks…