How to Insert Cells in Excel - Compute Expert

How to Insert Cells in Excel


Home >> Excel Tutorials from Compute Expert >> Excel Tips and Trick >> How to Insert Cells in Excel





In this tutorial, you will learn how to insert cells in excel completely.

When we work in excel, we might sometimes need to slip some cells into the cell range where we place our data. If we know how to do this, we should be able to work in excel more optimally.

Want to know the way to insert cells in excel? Read this tutorial until its last part!

Disclaimer: This post may contain affiliate links from which we earn commission from qualifying purchases/actions at no additional cost for you. Learn more

Want to work faster and easier in Excel? Install and use Excel add-ins! Read this article to know the best Excel add-ins to use according to us!

Learn Excel Dashboard Course






How to Insert Cells in Excel One by One

First, let’s learn the way to insert cells by adding one cell at a time. Following these steps should help you to do just that.

  1. Place your cell cursor on the left or on the top of where you want to insert your cell

    How to Insert Cells in Excel - Screenshot of Inserting Cells One by One, Step 1

  2. Right-click and select Insert… or go to the Home tab, click the Insert dropdown button there, and choose Insert Cells…

    How to Insert Cells in Excel - Screenshot of Inserting Cells One by One, Step 2-1

    How to Insert Cells in Excel - Screenshot of Inserting Cells One by One, Step 2-2

  3. Choose Shift Cells Right (pushing cells to the right from where your cell cursor is currently) or Shift Cells Down (pushing cells down from where your cell cursor is currently) and click OK

    How to Insert Cells in Excel - Screenshot of Inserting Cells One by One, Step 3

  4. Done!

    How to Insert Cells in Excel - Screenshot of Inserting Cells One by One, Step 4




How to Insert Cells in Excel by Adding Columns

You can also insert cells by adding columns in your data range. Here are the steps to do that.

  1. Highlight the column on the right of where you want to add your column by clicking its letter note on the top.

    If you want to add multiple columns, highlight columns as many as you want to add (to highlight adjacent columns, click and drag along their letter notes. To highlight non-adjacent columns, click their letter notes while pressing and holding the Ctrl button (Command button on Mac))

    How to Insert Cells in Excel - Screenshot of Inserting Cells by Adding Columns, Step 1

  2. Right-click on the column and choose Insert or go to the Home tab and click the Insert button there

    How to Insert Cells in Excel - Screenshot of Inserting Cells by Adding Columns, Step 2

  3. Done!

    How to Insert Cells in Excel - Screenshot of Inserting Cells by Adding Columns, Step 3






How to Insert Cells in Excel by Adding Rows

Besides adding columns, you can also add cells in excel by adding rows. Here are the steps to do it.

  1. Highlight the row below where you want to insert your row by clicking on its number note on the left.

    If you want to add multiple rows, highlight rows as many as you want to add (to highlight adjacent rows, click and drag along their number notes. To highlight non-adjacent rows, click on their number notes while pressing and holding the Ctrl button (Command button on Mac))

    How to Insert Cells in Excel - Screenshot of Inserting Cells in Excel by Adding Rows, Step 1

  2. Right-click on the row and choose Insert or go to the Home tab and click the Insert button in it

    How to Insert Cells in Excel - Screenshot of Inserting Cells in Excel by Adding Rows, Step 2

  3. Done!

    How to Insert Cells in Excel - Screenshot of Inserting Cells in Excel by Adding Rows, Step 3




Exercise

After you have done learning how to insert cells in excel, let’s do this simple exercise. This is so you can understand the lessons from this tutorial more practically.

Open an excel file and try to insert cells in its data cell range by using all of the three methods above. Remember to not save the file after you do it!

What is the result? Can you do it? If you still can’t, go back to our tutorial above and try to learn again the part you still haven’t mastered yet!



Additional Note

If you want to use shortcuts, you can select a column by placing your cell cursor on one of its cells and pressing Ctrl + Space Bar (Control + Space Bar on Mac) buttons. To select a row, place your cell cursor on one of its cells and press the Shift + Space Bar buttons.

Then, to add the column/row, just press Ctrl + Shift + + (Command + Shift + + on Mac) buttons.



Related tutorials you might want to learn:



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!




Learn Excel Dashboard Course

Follow our tutorial content also on


Excel Calculation

Sum in Excel

Subtraction in Excel

Multiplication in Excel

Division in Excel

Average in Excel



Excel Formula

VLOOKUP Function in Excel

IF Function in Excel

SUM Function in Excel

COUNTIFS Function in Excel

SUMIFS Function in Excel



Excel Tips and Trick

How to Print in Excel

Convert Number to Text in Excel

Excel Worksheet Definition

Excel Range Definition

Excel Shortcuts



Excel Products & Services Recommendation

Best Laptops for Excel

Best Tablets for Excel

Best Keyboards for Excel

Best Mouse for Excel

Best Monitors for Excel



Excel Consultation

Recommended Things

About Us

Contact Us

Privacy Policy

Affiliate Disclosure

Terms & Condition



© 2024 Compute Expert