NOBLE SOFTWARE SOLUTIONS - WE MAKE IT CLICK!

Resizing Columns to Fit Largest Entry in Excel

By Laura Noble

In a spreadsheet with many rows of data, it is difficult to "eye-ball" a column and widen it to fit the largest entry.

There is a quick and easy method of automatically adjusting a column to fit the largest entry:

  1. In sample below Column A needs to be widened to view all the entries completely.

  1. Place the mouse pointer in between the column A and B headings until the pointer changes to a double-headed arrow. See sample below.

  1. Double-click the mouse and the column will adjust automatically to fit the largest entry.

In sample below (cell A11) Peanut Butter & Chocolate  is the largest entry.

©Noble Software Solutions - www.NobleSoftwareSolutions.com - 519-680-2689

Home    Why NSS?    Tips & Tricks   Overview    Course Topics    Contact NSS   Training Rates  Media Room  Privacy

Copyright 2000-2008. Noble Software Solutions, London, Ontario, Canada. All Rights Reserved.

Logo Designed by Elly Fox Graphic Designer