Working With Columns, Rows, and Cells

To Modify Column Width:

  1. Position your mouse over the column line in the column heading so that the white cross  becomes a double arrow 

Click and drag the column to the right to increase the column width or to the left to decrease the column width.

Release the mouse. The column width will be changed in your spreadsheet.

To Set Column Width With A Specific Measurement:

  1. Select the columns you want to modify.
  2. Click the Format command on the Home tab. The format drop-down menu appears.
  3. Select Column Width.

The Column Width dialog box appears. Enter a specific measurement.

Click OK. The width of each selected column will be changed in your worksheet.

Select AutoFit Column Width from the format drop-down menu and Excel will automatically adjust each selected column so that all the text will fit.

To Modify The Row Height:

Position the cursor over the row line so that the white cross becomes a double arrow.

Click and drag the row downward to increase the row height or upward decrease the row height.

Release the mouse. The height of each selected row will be changed in your worksheet.

To Set Row Height With A Specific Measurement:

  1. Select the rows you want to modify.
  2. Click the Format command on the Home tab. The format drop-down menu appears.
  3. Select Row Height.

The Row Height dialog box appears. Enter a specific measurement.

Click OK. The selected rows heights will be changed in your spreadsheet.

Select AutoFit Row Height from the format drop-down menu and Excel will automatically adjust each selected row so that all the text will fit.

To Insert Rows:

Select the row below where you want the new row to appear.

Click the Insert command on the Home tab.

The new row appears in your worksheet.

When inserting new rows, columns, or cells, you will see the Insert Options button  by the inserted cells. This button allows you to choose how Excel formats them. By default, Excel formats inserted rows with the same formatting as the cells in the row above them. To access more options, hover your mouse over the Insert Options button and click on the drop-down arrow that appears.

To Insert Columns:

Select the column to the right of where you want the new column to appear. For example, if you want to insert a column between A and B, select column B.

Click the Insert command on the Home tab.

The new column appears in your worksheet.

By default, Excel formats inserted columns with the same formatting as the column to the left of them. To access more options, hover your mouse over the Insert Options button and click on the drop-down arrow that appears.

When inserting rows and columns, make sure you select the row or column by clicking on its heading so that all the cells in that row or column are selected. If you select just a cell in the row or column then only a new cell will be inserted.

To Delete Rows:

Select the rows you want to delete.

Click the Delete command on the Home tab.

The rows are deleted from your worksheet.

To Delete Columns:

Select the columns you want to delete.

Click the Delete command on the Home tab.

The columns are deleted from your worksheet.