LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,268
Default 2003: Autofit merged cells

Actually in most cases you can make the sheet look like it has merged cells,
Assume you want a 5 column header, type the header in the leftmost
cell of those 5, then select all 5 cells and then do formatcellsalignment
and from the
horizontal text alignment dropdown select "Center across selection"

I agree with Bob, I even wish they would remove the option
of having merged cells. If you have to audit and redesign spreadsheets
with lots of merged cells then you tend to look upon them
as the Devil's spawn


--


Regards,


Peo Sjoblom


"David M. Marcovitz" wrote in message
48.16...
Thanks, Bob. That's too bad.
--David

Bob I wrote in
:

Yes, merged cells cause plenty of grief, it's typically recommended
here to not use them.



 
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
Autofit Merged cell Code is changing the format of my merged cells JB Excel Discussion (Misc queries) 0 August 20th 07 02:12 PM
Is there a way to Autofit Merged Cells in a row? JLSmith Excel Discussion (Misc queries) 2 August 1st 06 04:49 PM
Row Autofit on Merged Cells Jluo Excel Discussion (Misc queries) 1 April 18th 05 02:37 PM
Autofit row height in merged cells BobT Excel Discussion (Misc queries) 1 February 25th 05 04:44 PM
Autofit in Merged Cells? Mick Excel Discussion (Misc queries) 4 February 14th 05 05:15 PM


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