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.
    selecting a column to move
  2. Click the Cut command on the Home tab, or press Ctrl+X on your keyboard.
    selecting the Cut command
  3. 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 E and F, select column F.
    selecting an adjacent column to insert the cut cells
  4. Click the Insert command on the Home tab, then select Insert Cut Cells from the drop-down menu.
    inserting the cut cells
  5. The column will be moved to the selected location, and the columns around it will shift.
    the moved column in its new location

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

accessing commands from the right-click menu

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. To do this, Excel allows you to hide rows and columns as needed. In our example we'll hide a few columns, but you can hide rows in the same way.

  1. Select the columns you want to hide, right-click the mouse, then select Hide from the formatting menu. In our example, we'll hide columns C, D, and E.
    selecting the hide columns command
  2. The columns will be hidden. The green column line indicates the location of the hidden columns.
    the hidden columns
  3. To unhide the columns, select the columns on both sides of the hidden columns. In our example, we'll select columns B and F. Then right-click the mouse and select Unhide from the formatting menu.
    selecting the columns adjacent to the hidden columns
  4. The hidden columns will reappear.
    the unhidden columns