GCFLearnFree.org

Every day I fall a little more in love with your site.”

Online Learner

GCFGlobal.org
Creating Opportunities For A Better Life.®
  • All Topics
  • Excel 2007
  • Modifying Columns, Rows, and Cells

Excel 2007

Single page view print copy

Modifying Columns, Rows, and Cells

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.
Modify Column Width
  • 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.
Select Column
  • Click the Format command in the Cells group on the Home tab. A menu will appear.
Format Command
  • 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.
    Modify Row Height
  • 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.
    Format Command
  • Select Row Height to enter a specific row measurement.
  • Select AutoFit Row Height to adjust the row so all of the text will fit.
previous next
previous 1 2 3 4 next
Terms Of Use

©1998-2014 Goodwill Community Foundation, Inc. All rights reserved.