Excel 2007

Columns, rows, and cells

Watch the video! (6:19min)

Download the example to work along with the video.

To modify column width:

• Position the cursor over the column line in the column heading, and a double arrow will appear.

• Left-click the mouse, then drag the cursor to the right to increase the column width or to the left to decrease the column width.
• Release the mouse button.
  OR
• Left-click the column heading of a column you'd like to modify. The entire column will appear highlighted.

• Click the Format command in the Cells group on the Home tab. A menu will appear.

• Select Column Width to enter a specific column measurement.
• Select AutoFit Column Width to adjust the column so all of the text will fit.

If you see pound signs (#######) in a cell, it means that the column is not wide enough to display the cell content. Simply increase the column width to show the cell content.

To modify the row height:

• Position the cursor over the row line you want to modify, and a double arrow will appear.
  
  
• Left-click the mouse, then drag the cursor upward to decrease the row height or downward to increase the row height.
• Release the mouse button.
  OR
• Click the Format command in the Cells group on the Home tab. A menu will appear.
  
• Select Row Height to enter a specific row measurement.
• Select AutoFit Row Height to adjust the row so all of the text will fit.