Automatically Adjusting Column Widths???

F

Fred

I constantly use the functions/commands:
Format/Column/AutoFit Selection. Is there any way to make
a column automatically widen to fit contents as the
contents are entered? Thanks!
 
D

Dave R.

I dont know about that, but you can double click on far right side of the
area where the A B colmn lettering is (usually grey with an A in the middle
of it for example, not sure what its called.. header maybe), and it will
automatically expand them. If you mouse over that area, you will see that
when your mouse cursor is over the right side, it changes to something with
arrows on each side, showing you will be re-sizing. Double click and that
does the trick and is at least quicker than going to ormat>column>autofit.
 
D

Dan Wantman

Double click on the top of the column, the curser will
look like a thin "t" with two arrows and the column will
automatically widen to fit contents. If it is for the
entire worksheet, highlight the entire sheet and double
click for one column.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top