auto fit of column in EXCEL

  • Thread starter Thread starter msp
  • Start date Start date
M

msp

when we type along the column width should get changed automatically, for eg.
first in field A1 type "abcd" and in A2 type "abcdefghijklmn" the width
should get automatically adjusted. How to do this. please help.
 
Hi MSP,

Two silly ways:-

1:- Format that column, with option "Wrap Text"
2:- After typing in all the days, go to Format -> Column -> Autofit Selection

Thanks
--
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)
(e-mail address removed)
(e-mail address removed)
New Delhi, India
 

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

Row Height-Auto Adjust to Content? 5
Column/Cell Question 2
Dif size text with Formulas 4
Best-fit column based on a cell range 2
Locking column widths 2
Column width format 2
autofit Column width- Ajit 2
Excel 2002: How to insert an Auto Fit Width button at the tool bar 2

Back
Top