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.
- Select the desired column heading for the column you want to move.
- Click the Cut command on the Home tab, or press Ctrl+X on your keyboard.
- 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.
- Click the Insert command on the Home tab, then select Insert Cut Cells from the drop-down menu.
- The column will be moved to the selected location, and the columns around it will shift.
You can also access the Cut and Insert commands by right-clicking the mouse and selecting the desired commands from the drop-down 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.
- 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.
- The columns will be hidden. The green column line indicates the location of the hidden columns.
- 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.
- The hidden columns will reappear.