Add a cell, Row or a column in Microsoft Excel 2010

In this article, we will learn how we can add a cell, row or a column in Microsoft Excel 2010.

Let’s take an example to understand to add a cell, row or a column in Microsoft Excel.

We have data in range A1: C15. Column A contains agent name, column B contains city, column C contains sales amount.

 
img1
 

Add Cell in data

Follow below given steps:-

  • To add the cell in data, select a cell in data.
  • Select the cell A2.
  • Press the key Ctrl++ on your keyboard.
  • Insert dialog box will appear.

 

img2

 

  • If you want to insert the cell in right or down, you can choose the option accordingly and then click on OK.

Right Click
 

img3

 
Down click
 

img4

 
Add Row in data

Follow below given steps:-

  • We want to add the row in between 3rd and 4th row.
  • Select the 4th row and press the key Ctrl+ on your keyboard.

 

img5

 

  • Row will get added in between 3rd and 4th row.

 
img6
 

Add Column in data

Follow below given steps:-

  • We want to add a Column between B and C column.
  • Select the column C and press the key Ctrl+ on your keyboard.

 
img7
 

  • Column will get added in between B and C column.

 
img8
 
These are the ways to add the cells, rows, and columns in Microsoft Excel.
 
 

Users are saying about us...

  1. How do I insert a specific number of rows in excel? for instance, I want to insert 50 rows but I do not want to count and select 50 rows first to hit insert. Can someone help?

  2. “Hi Suresh,

    You don’t really need to count the rows one at a time.

    Try this:

    Enter A into A1, and B into A2.

    Now, we will insert 50 rows between A1 and A2:

    Select A2

    Press and hold the shift key

    Press the Page Down key once. Don’t let go of the shift key!

    Depending on your screen size (probably) you will jump to about row 36 (maybe more or less).

    However, if you still have your finger on the shift key, note the little yellow box that appears saying ’34R x 1C’ (or similar)?

    That tells you that you have selected a range that is 34 rows deep and 1 column wide.

    Just keep expanding the range using Page Down or just the Down Arrow key until you get exactly the right number of rows to insert.

    Alan.”

  3. How do I insert a specific number of rows in excel? for instance, I want to insert 50 rows but I do not want to count and select 50 rows first to hit insert. Can someone help?

  4. “You don’t really need to count the rows one at a time.

    Try this:

    Enter A into A1, and B into A2.

    Now, we will insert 50 rows between A1 and A2:

    Select A2

    Press and hold the shift key

    Press the Page Down key once. Don’t let go of the shift key!

    Depending on your screen size (probably) you will jump to about row 36 (maybe more or less).

    However, if you still have your finger on the shift key, note the little yellow box that appears saying ’34R x 1C’ (or similar)?

    That tells you that you have selected a range that is 34 rows deep and 1 column wide.

    Just keep expanding the range using Page Down or just the Down Arrow key until you get exactly the right number of rows to insert. “

  5. Can you explain how I can add a drop down menu to add values in cell that populate in the main cell. For example, if I want to make a running list of grocery expenses from walmart and have it update automatically each time I add a $ dollar from a receipt. This is needed to keep a budget that will update automatically in one cell from sub-cell entries. Please help.

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube