Modifying Columns, Rows, and Cells

In Excel column width can be modified, as can row height and width in Excel. Learn to modify Excel cells in this free Excel 2016 lesson.

To move a row or column:

Sometimes you may want to move a column or row to rearrange the content of your worksheet. In our example we'll move a column, but you can move a row in the same way.

  1. Select the desired column heading for the column you want to move, then click the Cut command on the Home tab or press Ctrl+X on your keyboard.
    Screenshot of Excel 2013Cutting an entire column
  2. Select the column heading to the right of where you want to move the column. For example, if you want to move a column between columns B and C, select column C.

    Screenshot of Excel 2013Choosing a destination for the column
  3. Click the Insert command on the Home tab, then select Insert Cut Cells from the drop-down menu.

    Screenshot of Excel 2013Inserting the column
  4. The column will be moved to the selected location, and the columns to the right will shift right.

    Screenshot of Excel 2013The moved column

You can also access the Cut and Insert commands by right-clicking the mouse and then selecting the desired commands from the drop-down menu.

Screenshot of Excel 2013Right-clicking to Insert Cut Cells

To hide and unhide a row or column:

At times, you may want to compare certain rows or columns without changing the organization of your worksheet. Excel allows you to hide rows and columns as needed. In our example, we'll hide columns C and D to make it easier to compare columns A, B, and E.

  1. Select the column(s) you want to hide, right-click the mouse, then select Hide from the formatting menu.
    Screenshot of Excel 2013Hiding the selected columns
  2. The columns will be hidden. The green column line indicates the location of the hidden columns.
    Screenshot of Excel 2013The hidden columns
  3. To unhide the columns, select the columns to the left and right of the hidden columns (in other words, the columns on both sides of the hidden columns). In our example, we'll select columns B and E.
  4. Right-click the mouse, then select Unhide from the formatting menu. The hidden columns will reappear.
    Screenshot of Excel 2013Unhiding the hidden columns