View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
BlueWolverine BlueWolverine is offline
external usenet poster
 
Posts: 36
Default AUTO FIT not WORKING properly. Does not shrink row to fit

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.
--
BlueWolverine
MSE - Mech. Eng.
Go BLUE!