I wish I would have found you ages ago.”

Online Learner

Creating Opportunities For A Better Life.®

Excel XP

Multiple page view print copy

Changing Column Width and Row Height

Page 1

Introduction

By the end of this lesson, learners should be able to:

  • Change column width
  • Change row height
Page 2

Adjusting column widths

By default, Excel's columns are 8.43 characters wide, but each individual column can be enlarged to 240 characters wide.

If the data being entered in a cell is wider or narrower than the default column width, you can adjust the column width so it is wide enough to contain the data.

Column Too Small for Data

You can adjust column width manually or use AutoFit.

To Manually Adjust a Column Width:

  • Place your mouse pointer to the right side of the gray column header.
  • The mouse pointer changes to the adjustment tool (double-headed arrow).

    Selecting a Column's Border

  • Drag the Adjustment tool left or right to the desired width and release the mouse button.

    Drag Column To Enlarge It

To AutoFit the Column Width:

  • Place your mouse pointer to the right side of the column header.
  • The mouse pointer changes to the adjustment tool (double-headed arrow).
  • Double-click the column header border.
  • Excel "AutoFits" the column, making the entire column slightly larger than the largest entry contained in it.

To access AutoFit from the menu bar, choose Format Column AutoFit Selection.

Page 3

Adjusting row height

Changing the row height is very much like adjusting a column width. There will be times when you want to enlarge a row to visually provide some space between it and another row above or below it.

To Adjust Row Height of a Single Row:

  • Place your mouse pointer to the lower edge of the row heading you want to adjust.
  • The mouse pointer changes to the adjustment tool (double-headed arrow).

    Selecting a Row's Broder

  • Drag the Adjustment tool up or down to the desired height and release the mouse button.

    Expanded Row Height

To AutoFit the Row Height:

  • Place your mouse pointer to the lower edge of the row heading you want to adjust.
  • The mouse pointer changes to the adjustment tool (double-headed arrow).
  • Double-click to adjust the row height to "AutoFit" the font size.
  • Excel XP "AutoFits" the row, making the entire row slightly larger than the largest entry contained in the row.
Page 4

Challenge

  • Type the sentence, "Mary had a little lamb," in cell B2.
  • Define the row height of row 2 as 25.
  • AutoFit the column width of column B.