How to Insert Row in Excel


Home >> How to Use Excel Tutorial >> Excel Tips and Trick >> How to Insert Row in Excel



In this tutorial, you will learn how to insert row in excel. The knowledge of how to insert a new row in excel is important especially when we want to place something in between the data that we have in our spreadsheet.


Why do We Need to Learn How to Add Rows in Excel?


When doing data processing in a spreadsheet file, maybe there is a time when we need to put entries in the middle of our data table. This is needed when we need to add the entries in the middle of all the data that we have inputted or maybe when we need to add a process in the middle of the table. If we do not know how to do it, then it will be very troublesome for us considering the data entry process in a spreadsheet is usually dynamic and there are often sudden changes that we need to do in the middle of the process.

As an example of this need in our job, let’s say we do data inputs for the daily sales numbers of our company. Sometimes maybe we have already inputted until a certain date and realize there is a previous date that has not been inputted yet in the data table. One of the ways to slip in that data entry is by inserting the data entry in the middle of the table so the date will be kept in sequence. For this need, we must know how to insert row in excel.

To help you with the process application in this spreadsheet software, there are some methods that you can use to do it. By understanding one or more methods to do it, then you should not have trouble when you need to place some data in the middle of your table in the spreadsheet when there is a need to do so.


What is How to Insert Row in Excel?


How to insert row in excel is a function with the usage objective to add one or more entries in the middle of your data. Usually, this function is needed to be used when you are creating a table in your spreadsheet and you need to place one or more entries when you are in the middle of the formulation process.


How to Practice Excel How to Insert Row Methods?


The following will explain the way of using the 3 methods that you can use. You can use just one from the three because the results from them are all the same.


Method 1 - Insert Row Menu

  1. Highlight the places where you want to place your new entries above them by clicking their numbers on the left (Highlight as many as you need to place by doing a drag)

    How to Insert Row in Excel - Screenshot of Step 1-1

  2. Click Insert in the Home tab

    How to Insert Row in Excel - Screenshot of Step 1-2

  3. Done!

    How to Insert Row in Excel - Screenshot of Step 1-3




Method 2 - Right-Click

  1. Highlight the places where you want to place your new entries above them by clicking their numbers on the left (Highlight as many as you need to place by doing a drag)

    How to Insert Row in Excel - Screenshot of Step 2-1

  2. Right-click and choose Insert

    How to Insert Row in Excel - Screenshot of Step 2-2

  3. Done!

    How to Insert Row in Excel - Screenshot of Step 2-3




Method 3 - Shortcut Buttons

  1. Place your cursor on the cells where you want to add new entries above them (Highlight more than one cells in more than one rows with the amount that you highlight is as many as you need to add)

    How to Insert Row in Excel - Screenshot of Step 3-1

  2. Press Shift + Space Bar buttons simultaneously

    How to Insert Row in Excel - Screenshot of Step 3-2

  3. Press Ctrl + Shift + + (Command + Shift + + on Mac) buttons simultaneously
  4. Done!

    How to Insert Row in Excel - Screenshot of Step 3-4



Exercise


After understanding how to insert row in excel using the three methods, now is the time to practice them to deepen your understanding. Open one spreadsheet file and try to practice how to insert row in excel by using each of the three methods. How is the result? Can you do it?


Additional Note


The cell format in the new rows added will follow the cell format in the entries above where you put the new ones.



Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!


Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!



Follow our tutorial content also on


CONTACT US PRIVACY POLICY TERMS AND CONDITION AFFILIATE DISCLOSURE @Compute Expert