LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,510
Default Adjusting row height to accomidate text in a cell

Hi again George,

I just did some more testing and provided the rows are set to Autofit then
Wrapping text expands the cell. So you can set Autofit height either before
or after wrapping text.

--
Regards,

OssieMac


"OssieMac" wrote:

Hi George,

If the row height has been previously set to a fixed height with Format-Row
height then that row height appears to take precedence.

After wrapping the text, select Format-Auto fit row height (In editing
block far right of Home tab)

--
Regards,

OssieMac


"GeorgeJ" wrote:

In previous versions of Excel, when I did a format/cells/alignment and then
checked the "wrap text" box, the row height of the cell would change if that
was required to display all the text in the box. This doesn't seem to work
for me in Excel 2007. I click on a cell which has a long text string in it,
only a some of which is displayed. Doing a format cells/alignment and then
checking the box for "Wrap text" does *not* change the row height. The cell
remains showing only a porttion of the total text string in it. What am I
doing wrong?



--
-regards

 
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
where text wraps in a cell, how can the row height be auto set? Stephen Sandor Excel Worksheet Functions 25 May 10th 10 07:57 PM
Linked spreadsheet is not automatically adjusting row height? lyngwin Excel Discussion (Misc queries) 2 November 13th 07 02:00 PM
Automatically Adjusting Row Height in Merged Cells MGC Excel Discussion (Misc queries) 12 October 1st 07 08:19 PM
Resizing row height to dynamically fit height of text box Jon Excel Discussion (Misc queries) 1 August 8th 05 01:37 PM
Row height is not adjusting after activating Merge Cells & Wrap Te MHPDallas Excel Worksheet Functions 1 April 9th 05 12:32 AM


All times are GMT +1. The time now is 04:14 PM.

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

About Us

"It's about Microsoft Excel"