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 Check Boxes
Excel Batch Delete Check Boxes In Excel Batch deleting check boxes in selected cells without…
Excel Random Generator
Generate Random Data (Numbers, Date, String, etc…) Sometimes you want to generate some random data…
Excel Select Merged Cells
Quickly Select Merged Cells It seems a little difficult to select only merged cells in…
Excel Convert Hyperlinks
Extract URL’s From Hyperlinks Or Convert Plain Text Cells Into Hyperlinks In Excel Easily convert…
How To Insert Checkbox In Excel
Batch Insert Check Boxes In Excel Insert a batch of checkboxes into selected cells without…
How to Clean Data in Excel: Trim, Fix Case and Convert in One Pass
Excel Data Cleaning: Spaces, Line Breaks, Capitals and Text Numbers, All in One Pane A…