LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Track Changes Not Working Properly Gina Excel Worksheet Functions 0 May 19th 09 11:43 PM
my sum function is not working properly rajnish Excel Discussion (Misc queries) 2 October 24th 07 02:29 PM
data-auto filter not working properly? Brad Excel Discussion (Misc queries) 10 January 26th 07 03:14 PM
But not working properly Rao Ratan Singh Excel Discussion (Misc queries) 2 September 14th 06 08:45 AM
Auto Filter not working properly Dale Fye Excel Discussion (Misc queries) 1 March 16th 05 01:29 PM


All times are GMT +1. The time now is 10:46 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"