Excel 2010

Modifying Columns, Rows, and Cells

2 of 7

Working with Columns, Rows, and Cells

Launch video!Watch the video (3:22). Need help?

Watch the video to learn about modifying columns, rows, and cells in Excel 2010, including wrapping text and merging cells.

To Modify Column Width:

  1. Position your mouse over the column line in the column heading so that the white cross Cursor becomes a double arrow Double-arrow.
    Positioning mouse over the column line Positioning mouse over the column line
  2. Click and drag the column to the right to increase the column width or to the left to decrease the column width.
    Increasing the column width Increasing the column width
  3. Release the mouse. The column width will be changed in your spreadsheet.
    Increasing the column width Increased column width

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.
    Increasing the column width Increasing the column width
  4. The Column Width dialog box appears. Enter a specific measurement.
    Increasing column width to 258 pixels Increasing column width to 258 pixels
  5. 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.