Automatically Adjusting Column Widths???

  • Thread starter Thread starter Fred
  • Start date Start date
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!
 
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.
 
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.
 
Back
Top