AUTO FIT not WORKING properly. Does not shrink row to fit

B

BlueWolverine

Hello,
MS EXCEL 2003 on XP PRO.

Have a document with a lot of rows and I want to autofit the rows to take up
the least space possible. I know how to do this both in EXCEL and using vba
(rows(1:2).entirerow.autofit etc) But it's not working. I have some rows
of data that clearly fit on one line but the autofit is forcing the row to 2
lines tall.

Any idea on how to fix this? there are No alt-enters (chr(10)) there are no
hidden data in other cells. I can't figure it out.

Thanks.
 
T

Tom Hutchins

I had a worksheet with cells which autosized much wider or taller than
necessary. The problem turned out to be the font, which was Courier. When I
changed the font to Arial, autosizing worked as expected. Not sure if your
problem has a similar cause, but thought it was worth mentioning.

Hope this helps,

Hutch
 
B

BlueWolverine

The font in the document is in Times New Roman and changing it to Arial does
not fix my autofit problem.

Any other Ideas?
 

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-Fit 1
Auto fit row height for one column 3
Excel 2003 autofit ignored by some rows 3
Auto Fit Row and Columns 1
Print Fit To Not Working 1
Auto fit wrapped and merged cells in entire worksheet 8
Auto Row Height with Wrapped Text in Merged Cells Problem 3
Auto fit row height 2

Top