Resize Excel column's width automatically

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can an Excel column's width automatically increase/decrease depending on
the maximium number of digits in any one cell of the column. I am wanting to
use this for a template so the column must be able to increase or decrease. I
am using a version that came with Microsoft Office XP Professional.
 
Dog,

Double click the border in the column header. This is a one-time adjustment
of the column width. It doesn't dynamically adjust the width to the widest
cell as does the Row Height Autofit.
 

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

Similar Threads

Changing Row Height/Column Width 4
Row Height-Auto Adjust to Content? 5
Column Header 1
Column width of Pivot Table data goes back to default when data refreshed 2
How to tell number of spaces between values in saved text file fromthe original xls file 1
Cell/column auto adjusts width to longest text string 4
Want to link a cell of numbers with a cell of text & can sort 1
How do I decrease the gap width of the Up/down bar? 4

Back
Top