GCFLearnFree.org

As a website designer, I can say you have one of the best learning websites.”

Online Learner

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

Excel 2013

Single page view print copy

Modifying Columns, Rows, and Cells

Introduction

Video: Modifying Columns, Cells, and Rows

Launch "Modifying Columns, Cells, and Rows" video!Watch the video (4:32).

By default, every row and column of a new workbook is always set to the same height and width. Excel allows you to modify column width and row height in different ways, including wrapping text and merging cells.

Optional: Download our Lesson 8 Practice Workbook.

To modify column width:

In our example below, some of the content in column A cannot be displayed. We can make all of this content visible by changing the width of column A.

  1. Position the mouse over the column line in the column heading so the white cross Cursor becomes a double arrow Double-arrow.
    Screenshot of Excel 2013Hovering over the column line
  2. Click, hold, and drag the mouse to increase or decrease the column width.
    Screenshot of Excel 2013Increasing the column width
  3. Release the mouse. The column width will be changed.
    Screenshot of Excel 2013The new column width

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 AutoFit column width:

The AutoFit feature will allow you to set a column's width to fit its content automatically.

  1. Position the mouse over the column line in the column heading so the white cross Cursor becomes a double arrow Double-arrow.
    Screenshot of Excel 2013Hovering the mouse over the column line
  2. Double-click the mouse. The column width will be changed automatically to fit the content.
    Screenshot of Excel 2013The automatically sized column

You can also AutoFit the width for several columns at the same time. Simply select the columns you would like to AutoFit, then select the AutoFit Column Width command from the Format drop-down menu on the Home tab. This method can also be used for Row height.

Screenshot of Excel 2013AutoFitting columns width with the Format command
previous next
previous 1 2 3 4 5 6 7 next
Terms Of Use

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