Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 29th 04, 05:54 PM
6-shooter
 
Posts: n/a
Default How do I "Wrap Text" & "Autofit" within Merged Cells in Excel?

Merged cells seem to be treated differently than single cells when it comes
to this functionality. Are there any tricks to working around this issue?


  #2   Report Post  
Old October 29th 04, 06:05 PM
Frank Kabel
 
Posts: n/a
Default

Hi
it just don't work in Excel. Best would be to not use merged cells at
all!

--
Regards
Frank Kabel
Frankfurt, Germany


6-shooter wrote:
Merged cells seem to be treated differently than single cells when it
comes to this functionality. Are there any tricks to working around
this issue?


  #3   Report Post  
Old October 29th 04, 11:41 PM
Gord Dibben
 
Posts: n/a
Default

Merged cells will allow "wrap text" from FormatCellsAlignment but..........

Excel has a problem auto-fitting merged cells.

You can resize manually or via Macro. Jim Rech has written
code for this.

http://groups.google.com/groups?thre...%40tkmsftngp05

Note also a recent adaptation of this code by Greg Wilson.

http://makeashorterlink.com/?P37D24B15

The best cure is DON"T USE MERGED CELLS. They cause no end of problems with
copying, pasting, sorting, filtering.

Gord Dibben Excel MVP

On Fri, 29 Oct 2004 09:54:15 -0700, 6-shooter
wrote:

Merged cells seem to be treated differently than single cells when it comes
to this functionality. Are there any tricks to working around this issue?


  #4   Report Post  
Old October 31st 04, 12:14 AM
ruralkansas
 
Posts: n/a
Default

Sometimes you have to merge cells as in the top row labels, etc. I've found
it helpful to wait until I'm finished with my spreadsheet to format any cells
requiring merging.

"6-shooter" wrote:

Merged cells seem to be treated differently than single cells when it comes
to this functionality. Are there any tricks to working around this issue?



Reply
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
How can I use word wrap in a merged cell in excel 2000? PartnersHC Excel Discussion (Misc queries) 4 October 18th 09 10:02 PM
How can I Excel to re-size when wrapping text in merged cells Samjoy Excel Discussion (Misc queries) 4 February 4th 05 12:47 AM
In Excel, using line wrap with text, some cells will appear as ##. RSCoyner Excel Discussion (Misc queries) 4 January 19th 05 11:21 PM
Excel merged cell - can it automatically expand as text is typed? Joanne (JAS) New Users to Excel 2 January 8th 05 12:11 AM
Rows with merged cells are not adjusting even w/ Wrap Text and au. mkern20 Excel Discussion (Misc queries) 1 January 4th 05 08:10 PM


All times are GMT +1. The time now is 01:13 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017