Microsoft Excel logo on a green background

Managing a spreadsheet is about more than just the data in it. Yous may want to add a title or apply shading to alternate rows. Some other basic role of formatting an Excel spreadsheet is to add or remove columns and rows.

You might discover that y'all demand an additional column or row equally you begin adding information to your canvas. On the other paw, you may realize you have a column or row that you don't need. You have a few easy ways to insert or delete columns and rows in Excel.

RELATED: How to Add or Remove Rows and Columns in Google Sheets

Add Columns and Rows in Excel

Inserting a single column or row in Excel takes less than a minute and yous have a couple of means to exercise this.

Select either the column to the right of or the row below the column or row you want to add. Then do one of the post-obit:

  • Correct-click and choose "Insert" from the shortcut menu.
  • Go to the Home tab and click the driblet-downward arrow for Insert. Choose "Insert Canvass Columns" or "Insert Sheet Rows."

Insert a single column in Excel

You'll then encounter your blank column or row pop into your canvass.

Inserted a single column in Excel

Add Multiple Columns or Rows

If you want to insert more than one row or column, you can follow the to a higher place steps to add them one at a time. Merely, in that location is a faster way.

Select the same number of columns or rows that yous desire to add. For example, we want to add together three columns, so we select 3 columns.

Again, columns are inserted on the left, and rows are inserted above. Exercise one of the post-obit:

  • Right-click and choose "Insert" from the shortcut menu.
  • Get to the Dwelling tab and click the drib-down arrow for Insert. Choose "Insert Sheet Columns" or "Insert Canvas Rows."

Insert multiple columns in Excel

You'll then take your new columns or rows added and ready for information.

Inserted multiple columns in Excel

Remove Columns and Rows in Excel

While deleting a column or row in Excel is similar to adding one, you lot need to be careful if the cavalcade or row you remove contains data. This may fifty-fifty include hidden information or information that's just out of view.

Alarm: You will non be alerted earlier deleting a cavalcade or row, whether it contains data or not.

Select one or more columns or rows you want to remove and do 1 of the post-obit:

  • Right-click and choose "Delete" from the shortcut bill of fare.
  • Get to the Home tab and click the drop-down arrow for Delete. Choose "Delete Canvas Columns" or "Delete Sheet Rows."

Delete a single column in Excel

Working with columns and rows is an essential element when using an Excel spreadsheet. For more, take a expect at how to hide or unhide columns or how to set the column width or row summit.

RELATED: How to Fix Row Height and Column Width in Excel

The above commodity may incorporate affiliate links, which help back up How-To Geek.