How to insert blank row after every row in excel

Inserting rows in Excel is one of the most basic stuff that we do almost everyday. And there are many ways to do this.

Now there could be various situations where you need to insert rows in Excel.

For example, you may want to insert a single row, or multiple rows that are all together, or multiple rows that are not together.

How to Insert Multiple Rows in Excel

In this tutorial, you’ll learn four different ways to insert multiple rows in Excel.

• Using Keyboard Shortcuts.
• Using Insert Options.
• Using Mouse + Keyboard (super trick).
• Using Insert Copied Cells Option.

Method 1: Using Keyboard Shortcuts

You can insert multiple rows in Excel using more than one keyboard shortcut.

Here is the first one:

• Select the cell above which you want to insert multiple rows in Excel.
• Press Shift + Space-bar to select the entire row.
  • You can also select the entire row by simply clicking on the row number on the extreme left.
• Once the entire row is selected, press Control and hit the plus key (+) from the numeric keypad.
  • If you don
    how to insert row every alternatively in excel
    how to insert multiple alternate rows in excel