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 Delete Columns
Highlight Or Delete Any Type Of Columns Highlight or delete identical, empty, or hidden cell…
Excel Select Used Range
Select Used Range With One Click Most annoying thing is when you want to select…
Excel Navigation
Navigation to Excel Sheets If you have many opened workbooks and want to navigate to…
Excel Insert Title Rows
Insert Title Rows In Your Excel Range Sometime you may need to add a title…
Excel Extend Selection To The Last Used Column
Easily Extend Selection To The Last Used Column Normally if you want to select a…
Excel Random Generator
Generate Random Data (Numbers, Date, String, etc…) Sometimes you want to generate some random data…