Rearranging Tables

Learning Objectives

  • Add, delete, and move columns and rows.

At times, you may find it necessary to change the number of rows or columns within your table, move columns or rows, or even alter the standard width of rows and columns. All these tasks are easy to accomplish within Excel, often with only a few clicks of your mouse.

Add Columns and Rows

Note for this section, the word column will be used throughout but the same steps can be used to add a row.

Method 1

After you have entered several columns of data into a worksheet, you may realize you need to add another column in the middle of what you have already typed. The easiest way to add a column within an existing set of columns involves only two clicks of your mouse.

  1. Identify the area where you want to insert a new column.
  2. Right-click on the column to the immediate right of the area where you wish to add a column.
  3. From the menu select Insert.
  4. A new column will appear to the left of the column that you right-clicked.
A Microsoft Excel sheet is open with numbers from A1 to B4. A dropdown menu has been opened up and the option to insert is highlighted.

Method 2

The same result can be achieved using the Insert button in the Cells group of the ribbon. The new column will be inserted to the left of the column you clicked on. In this screenshot, a column has been inserted.

An Excel sheet is open with numbers in column A, C, and D through row 4. In column B there is a green arrow showing where a new cell column has been inserted. In the top right there is another green arrow pointing this time at a green box, specifically at the insert dropdown menu.

Note that when you insert a new row, it will appear above the row you click on.

Practice Question

 

Delete Columns and Rows

Note for this section, the word column will be used throughout, but the same steps can be used to delete a row.

Method 1

After you have entered several columns of data into a worksheet, you may realize you need to remove one column. The easiest way to delete a column uses two clicks of your mouse.

  1. Right-click on the column you wish to delete.
  2. From the menu select Delete.

Method 2

The same result can be achieved using the Delete button in the Cells group of the ribbon. The column currently selected will be the one deleted. In this screenshot the column has been deleted.

An excel sheet is open with numbers in columns A1 thorough B4. There is a green arrow pointing at a green box, specifically at the delete cells dropdown menu

Move Columns and Rows

Note for this section, the word column will be used throughout, but the same steps can be used to move a row.

Method 1

After you have entered several columns of data into a worksheet, you may realize you need to move a column to a different location within the set. Once again, Excel makes it quite easy to move data around a worksheet.

  1. Right-click on the column you wish to move.
  2. From the pop-up window select Cut. The column you have selected should become outlined in a dashed border.
An Excel sheet is open with numbers in columns A1 through C4. There is a green arrow pointing at column B which has been selected.
  1. Next, right-click on the column you wish to move your column to the LEFT of.
  2. A new dialog window will appear. Select Insert Cut Cells. The column you selected to move should then appear in this new location.

Method 2

An excel sheet is open with numbers in columns A1 through C4. A green arrow is pointing at cell C5.

The same result can be achieved using a combination of keyboard shortcuts and dialog windows.

  1. Right-click on the column you wish to move.
  2. Press Ctrl+X. The column you have selected should become outlined in a dashed border.
  3. Next, right-click on the column you wish to move your column to the LEFT of.
  4. A dialog window will appear. From it select Insert Cut Cells. The column you wish to move should then appear in the new location.

Practice Question