How To Add Row And Column In Excel


Thinking about how to add row and column in excel? You can learn to do so in this article.

Once you have created a table in Excel, know that you can always add more rows and columns to it without any hassle. These newly added columns and rows would automatically get formatted as per your current usage and format. 

How To Add Row And Column In Excel

Here is how to add rows and columns in Excel swiftly.

Insert a Row or Column Adjacent to the Table

  • Click in a blank cell next to the table.
  • Type a cell value.
  • Click anywhere outside the cell or press the Enter key to add the value.
Click anywhere outside the cell or press the Enter key to add the value.

The new row or column is added to the table and the table formatting is applied.

Also Read
How to remove scroll lock in Excel
How to change date format in Excel
How to search in MS Excel in simple steps

Insert a Row or Column within a Table

Select a cell in the table row or column next to where you want to add the row or column.
Insert options aren’t available if you select a column header.

  • Click the Insert list arrow on the Home tab.
  • Select an insert table option.
  • Insert Table Rows Above: Inserts a new row above the select cell.
  • Insert Table Columns to the Left: Inserts a new column to the left of the selected cell.

Add Rows and Columns

Delete Rows and Columns

You can also remove unwanted table rows and columns by deleting them.

  • Select a cell in the row or column you want to delete.
  • Click the Delete list arrow.
  • Select Delete Table Rows or Delete Table Columns.
Add Rows and Columns

Shortcut: Right-click the row or column you want to delete, point to Delete in the menu, and select Table Columns or Table Rows.

The selected row(s) or column(s) and all the data in them are deleted.


Microsoft Excel is a software program designed by Microsoft that arranges data into rows and columns that can be changed using formulae, allowing the users to apply mathematical operations to the data.

We can utilize MS Excel for a variety of tasks in daily life, including organizing and filtering data, calculating averages, enabling macros, and more. Everywhere in the globe, Excel analysis is used by companies of all sizes to conduct financial analysis.

Easy sheet is a tech blog that features incredible Excel hacks, tips, and tricks. Our objective is to assist beginners learn Excel and get solutions using Easy Sheet.

We are the ideal resource for anyone in need of assistance with Microsoft Office products, including Excel, Word, PowerPoint, Publisher, and more!

About the author

Gaurav Singh Rawat

Add comment