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:
Excel Batch Delete Option Buttons
Batch Delete Option Buttons In Excel Sheets Batch deleting option buttons in selected cells without…
Excel Batch Insert Option Buttons
Batch Insert Option Buttons In Excel Insert a batch of option buttons into selected cells…
Excel Compare Sheets
Compare Sheets In Excel Comparing Excel sheets will take long time if doing it manually,…
Excel Extend Selection To The Last Used Column
Easily Extend Selection To The Last Used Column Normally if you want to select a…
Excel Remove All Macros
Remove All Macros From Excel Workbooks Delete Macros, User Forms, VBA modules, etc. from Excel…
Excel Color Duplicates
Color the duplicated cells values, each group of same values will be colored with same…