 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Excel Errors / April 2008Auto Fit Not Working
In Excel 2007 I am having a problem with auto-fit. It is making the row size one line of text two large under certain conditions. To reproduce the problem do the following: 1. Format a cell as Calibri 11pt. with word wrap turned and the cell bottom aligned. 2. Set the column width to 94.71. 3. Enter the phrase "Here is some text to eat up some space. " eight times in a cell. 4. Auto-fit the row. You should see that the cell expands to make room for four lines of text, but only last three lines are used. Does anyone else have this same problem and does anyone know a way to make auto-fit not do this? I have had the same problem in the past. What I will typically do is select the first row, then hold CTRL + SHIFT + DOWN ARROW, then double click between any 2 row numbers to autofit the height of all of the rows and you eliminate that extra space quickly. If you have any cells that you want to have extra space in above, this solution will not work. > In Excel 2007 I am having a problem with auto-fit. It is making the row size > one line of text two large under certain conditions. To reproduce the [quoted text clipped - 10 lines] > but only last three lines are used. Does anyone else have this same problem > and does anyone know a way to make auto-fit not do this? Thank you for your reply, however, your method simply re-does the auto-fit function and does not effect the problem. The problem is that the spacing is incorrect after auto-fit not before. I don't want any of the cells to have extra space, I want them to size themselves to the smallest size allowing all the text to be seen as most cells that are auto-fit do. I know that I didn't have the answer to your problem...just a quick fix after the autofit horizontally messes up the autofit vertically. Sorry I couldn't help more.... > Thank you for your reply, however, your method simply re-does the auto-fit > function and does not effect the problem. The problem is that the spacing is > incorrect after auto-fit not before. I don't want any of the cells to have > extra space, I want them to size themselves to the smallest size allowing all > the text to be seen as most cells that are auto-fit do. Autofit the column....that is what I do first. Then autofit the row. All of the extra white space should be gone then. > Thank you for your reply, however, your method simply re-does the auto-fit > function and does not effect the problem. The problem is that the spacing is > incorrect after auto-fit not before. I don't want any of the cells to have > extra space, I want them to size themselves to the smallest size allowing all > the text to be seen as most cells that are auto-fit do. Sidenote.....Try zooming in and zooming out after you have done the resizing like you are talking about to recreate your problem. When you Zoom in and out, the date may take up more or less rows if you do not autofit both ways. Just something to help you better understand your problem. > Autofit the column....that is what I do first. Then autofit the row. All of > the extra white space should be gone then. [quoted text clipped - 4 lines] > > extra space, I want them to size themselves to the smallest size allowing all > > the text to be seen as most cells that are auto-fit do. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.