Excel - Column too wide to read - AdvantEdge Training & Consulting

Excel – Column too wide to read

Sometimes when pasting data into Excel, a column will widen to the point that it can’t really be used. A long URL, for example, might stretch off the page.
Excel column - too wide
Normally, you would grab the border between the column labels to resize the column, but if the column takes up the entire page, that isn’t possible. There are a few tricks for making this column easier to read.

Right click

Right click on the column label, and choose Column Width. Excel sets the maximum width at 255. Change that number to anything less than 100, and click OK.excel column - right click column width

Select two columns

Select the too-wide column and a column right next to it by drag clicking both column labels. Then resize the second column by adjusting the border between the column labels and the too-wide column will be resized as well.

Wrap Text

excel column - wrap textOnce you have resized the column, some date will likely be hidden by the shortened field. To see this data, select the cell and then choose Wrap Text under the Home Tab.

 

Expand the viewing Window

When viewing cells with a lot of data, click on the down arrow to the right of the viewing window to get a few more lines of space to see.
field_drop_down
 

For more ways to make Excel work for you, take a training course from AdvantEdge Training & Consulting!

If you have at least 5 people we can create a session just for you.  Or, you can contact us for a private session. Contact Us

Questions? Don't see what you need?

We can help!

Business Training Classes
AdvantEdge Training & Consulting, Inc.

Recent Posts

Subscribe to our Newsletter

Copyright AdvantEdge Training & Consulting

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Scroll to Top