EDUCBA Logo

EDUCBA

MENUMENU
  • Explore
    • EDUCBA Pro
    • PRO Bundles
    • Featured Skills
    • New & Trending
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign Up
Home Excel Excel Resources Excel Tips How to Add Cells in Excel
 

How to Add Cells in Excel

Madhuri Thakur
Article byMadhuri Thakur

Updated June 6, 2023

How to Add Cells in Excel

 

 

Adding Cells in Excel

Adding a cell is nothing but inserting a new cell or group of cells between the existing cells using the insert option in Excel. We can insert the cells row-wise or column-wise as per requirement, allowing us to input the additional data or new data between the existing data.

Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more.

Explanation: Sometimes, while working with Excel, we may forget to add some portion of data that should be inserted between the existing data. In that case, we can cut the data, paste it a bit down or right, and input the required data in the gap. However, we can achieve the same without using the cut and paste option but by using the insert option in Excel.

There are four different options available to insert new cells. We will see each option and the respective example.

We can insert new cells in two ways; one way is to select the insert option from the worksheet, and the other is the shortcut key. Click on the “Home” menu at the top left corner if you are in a different menu.

how to Add cells in Excel 1.1

After selecting “Home”, observe the right-hand side. We have a section called “cells”. Which covers the options like “Insert”, “Delete”, and “format”, which are highlighted with a red color box.

how to Add cells in Excel 1.2

Each option has a drop-down if we observe under each option name. Click on the Insert option drop; then the drop-down menu will appear as below.

Insert Cells

It has four options: insert cells, insert sheet rows, insert sheet columns, and insert sheet. Click on the option Insert cells to open a pop-up menu with four options as below.

how to Add cells in Excel 1.4

Examples of Add Cells in Excel

Here are some examples of How to Add Cells in Excel, which are given below

You can download this How to Add Cells Excel Template here – How to Add Cells Excel Template

Example #1 – Add a Cell using Shift Cells Right

Consider a table having data from two columns like the one below.

how to Add cells in Excel 1.5

Now it has three rows of data. But we can do that if we need to add a cell at cell B4 by moving the data to the right. Follow the steps.

Step 1: Select the cell where you want to add a new cell. Here we have selected B4, as shown below.

how to Add cells in Excel 1.6

Step 2: Select the Insert menu option for the drop-down as below.

Insert menu option

Step 3: Select the Insert Cells option, then a pop-up menu will appear below.

Shift Cell Right

Step 4: Select the “Shift cells right” option and click OK. Then the result will appear below.

how to Add cells in Excel 1.9

If we observe the above screen, number 3 is shifted to the right, creating a new empty cell. This is how “shift cell right” will work. Similarly, we can do the shift cells down also.

Example #2 – Insert a New Column and New Row

To add a new column, follow the below steps. It is similar to shifting cells.

Step 1: Consider the table we took in the above example. Now we need to insert a column in between the two columns.

how to Add cells in Excel 2.1

Step 2: A column will always add on the left-hand side; hence select any one cell in the number of units as below.

how to Add cells in Excel 2.2

Step 3: Select the “Entire column” option from the insert option, as shown in the image below.

Select Entire Column

Step 4: Select the OK button. A new column will be added between the existing two columns as below.

how to Add cells in Excel 2.4

Similarly, we can add the row by clicking the Entire row option as below.

Select Entire Row

The result will be as below. A new row is added between the data X and Y.

how to Add cells in Excel 2.6

Example #3 – Adding Rows After Each Row using the Sort Option

Up to now, we have covered how to add a single cell by shifting cells right and down, adding an entire row or column.

If we want to add an empty row under each existing row, we can perform it another way. But these actions will affect only one row or one column. Follow the below steps to add an empty row.

Step 1: Take the table we used in the previous example.

how to Add cells in Excel 3.1

Step 2: Take some reference for the time being column ‘C’ as below.

how-to-Add-cells-in-Excel-3.2

Step 3: Now copy the references and paste them under the last reference in the table below.

how to Add cells in Excel 3.3

Step 4: We are using a sorting option to add an empty line under each existing data line. Highlight the entire table and click on the sort option. It is available under “Home”, highlighted in the below picture for reference.

Sort and Filter

Step 5: Select the custom sort from the Sort option’s drop-down.

Custom sort

Step 6: A window will open as below.

how to Add cells in Excel 3.6

Step 7: From Sort by select the “Reference” option as shown in the below image.

Select the Reference Option

Step 8: Select OK, then see it will sort in such an empty line between each data existing line as below.

how to Add cells in Excel 3.8

Step 9: Now, we can remove the reference column. I hope you understand why we added the reference column.

how to Add cells in Excel 3.9

Example #4 – Adding Multiple Rows or Columns or Cells

If we want to add multiple lines or cells simultaneously, highlight the number of cells or lines you require and perform the insert option as per selection. If we select the multiple row lines as below.

Adding Multiple Rows

Now use the insert option, which we add for rows.

how to Add cells in Excel 4.2

When we select “insert cells,” it will directly add the rows without asking for another pop-up as it asked before. Here we highlighted 3 lines; hence when we click on “Insert Cells”, it will add another 3 empty lines under the selected lines.

Things to Remember

  • “Alt + I” is the shortcut key to add a cell or line in the Excel spreadsheet.
  • A new cell can be added only on the right-hand side and down only. We cannot add the cells to the left and up; hence whenever you want to add the cells, highlight the cell per this rule.
  • A row will always be added at the bottom of the highlighted cell.
  • A column will always be added on the left side of the highlighted cell.
  • If you want to add multiple cells or rows at a time, highlight multiple cells or rows.

Recommended Articles

This is a guide on How to Add Cells in Excel. Here we discuss How to Add Cells, along with examples and a downloadable Excel template. You may also look at the following articles to learn more –

  1. How to Sum Multiple Rows in Excel
  2. SUM Cells in Excel
  3. Count Cells with Text in Excel
  4. Excel Shortcut For Merge Cells

Primary Sidebar

Footer

Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Blog
  • Blog
  • Free Tutorials
  • About us
  • Contact us
  • Log in
Courses
  • Enterprise Solutions
  • Free Courses
  • Explore Programs
  • All Courses
  • All in One Bundles
  • Sign up
Email
  • [email protected]

ISO 10004:2018 & ISO 9001:2015 Certified

© 2025 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

Download How to Add Cells Excel Template

EDUCBA Login

Forgot Password?

EDUCBA

Download How to Add Cells Excel Template

EDUCBA

डाउनलोड How to Add Cells Excel Template

🚀 Limited Time Offer! - 🎁 ENROLL NOW