Inserting Rows and Columns in Excel

How to Insert a Row or Column in an Excel Table

Creating additional rows and columns in a table in Excel is needed when you update and add data into a spreadsheet. Don’t worry, the process is simple.

Using the Excel Ribbon Tool

Select a cell where you want to modify a row or column.

In the ribbon, find the “Insert”, “Delete”, and “Format” buttons. Click “Insert” and a menu will appear when you have chosen a cell in your table.

Excel-Row-1

Choose what you desire from the options and a brand new column or row will then be added.

Adding and Removing Columns in Excel

This process is simple. Start by right clicking the cell you want to make a change in and this menu will appear:

Excel-Row-2

Select “Insert”, then one of the options. You can even choose delete and remove the column.

Related Templates:

Leave a Reply

Your email address will not be published.

Time limit is exhausted. Please reload CAPTCHA.