LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default autofit row text (wrapped) without changing column width?

Select rows and FormatRowAutofit doesn't work?

Also make sure the cells are formatted to wrap text.


Gord Dibben MS Excel MVP

On Thu, 16 Aug 2007 18:11:19 -0700, jessi
wrote:

Kim - did you ever get the answer to this problem, because I'm having the
same one. Jessi.

"kimdnw" wrote:

Allllen, this only works if I don't need to READ what is in the cell. Really
need a solution that will expand the row width without altering the column
width or text size.

Kim

"Allllen" wrote:

format cells alignment shrink to fit
--
Allllen


"kimdnw" wrote:

Working in spreadsheets with established columns. However, as data is added
and subtracted, text repeatedly becomes hidden when rows shift. Can I cause
the cells to "auto fit" text to the row without changing column width?




 
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
Excel - Automate row width for merged cells with wrapped text Sweetiedaw Setting up and Configuration of Excel 0 September 7th 06 10:23 PM
Resize individual cells w/o changing the entire column width Mary Ann Excel Discussion (Misc queries) 3 April 28th 06 04:39 PM
Conditional Format as a MACRO Gunjani Excel Worksheet Functions 3 March 29th 06 05:22 PM
creating a bar graph Johnfli Excel Discussion (Misc queries) 0 October 26th 05 08:16 PM
Text Wrapping JMB Excel Discussion (Misc queries) 0 July 29th 05 02:41 AM


All times are GMT +1. The time now is 03:07 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"