1. Computing & Technology

Discuss in my forum

Change Column Widths in Excel

By , About.com Guide

AutoFit Column Widths Using the Mouse
Change Column Widths in Excel

Change Column Widths in Excel

� Ted French

To AutoFit the width of column A to accommodate the longest data entry:

  1. Enter data into column A that is wider or narrower than the standard column width.

  2. Place the mouse pointer on the line between columns A and B in the column header.

  3. The pointer will change to a double - headed arrow.

  4. Double click with the left mouse button. The column will automatically widen to match the longest entry in that column.

  5. Follow these same steps to change the width of other columns.

©2012 About.com. All rights reserved.

A part of The New York Times Company.