How to insert row in Excel – with shortcut key method

Insert Row in Excel

Rows are a horizontal group of cells, outlined in blue below

Insert Row

Insert row from Insert Cell option

Step-1: Select the entire row below where you want to add the new row, outlined in Green below:

Insert Row

Step-2: Click the insert row option from Insert dialogue box, outlined in Red below:

Insert Row

Result outlined in Green below:

Insert Row

Insert row through right click in cell

Step-1: Select the entire row below where you want to add the new row, outlined in Green below

Insert Row

Step-2: Right click and select Insert, outlined in Red below

Insert Row

Result outlined in Green below:

Insert Row

Insert row from a selected cell

Step-1: Select the cell below where you want to add the new row, outlined in red below

Insert Row

Step-2: Right click and select Insert, outlined in Red below

Insert Row

From the Insert pop up select ‘Entire Row’

Insert Row

Result outlined in Green below:

Insert Row

How to Insert row in Excel Shortcut:

In next part of tutorial, we will see shortcut to insert row in excel.

Step-1: Select the entire row below where you want to add the new row, outlined in Green below

Insert Row

Step-2: Press ‘CTRL+Shift+Plus’ sign (+) from keyboard, result outlined in Green below

Insert Row

Insert multiple rows through shortcut key

 To insert multiple rows at a time – select number of rows you want to insert, say in below we want to two rows

Insert Row

Then press ‘CTRL+Shift+Plus’ sign (+) from keyboard, result outlined in Green below

Insert Row

You may be interested:

  1. Financial Dashboards
  2. Sales Dashboards
  3. HR Dashboards

 

 

 

 

 

 

Leave a Comment

Your email address will not be published. Required fields are marked *

Categories