ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel trouble (https://www.excelbanter.com/excel-discussion-misc-queries/95418-excel-trouble.html)

Bob Leach

Excel trouble
 
I've been trying to merge a group of cells, wrap the text and then use auto
fit function without any success in excel 2003. Can this be done and how?

Thanks,

Bob

Dave Peterson

Excel trouble
 
You have to adjust that manually (or via a macro).

Jim Rech wrote a macro called AutoFitMergedCellRowHeight that you may like:
http://groups.google.com/groups?thre...%40tkmsftngp05

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Bob Leach wrote:

I've been trying to merge a group of cells, wrap the text and then use auto
fit function without any success in excel 2003. Can this be done and how?

Thanks,

Bob


--

Dave Peterson

Bob Leach

Excel trouble
 
Thanks Dave, I'll check David McRitchie out.

"Dave Peterson" wrote:

You have to adjust that manually (or via a macro).

Jim Rech wrote a macro called AutoFitMergedCellRowHeight that you may like:
http://groups.google.com/groups?thre...%40tkmsftngp05

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Bob Leach wrote:

I've been trying to merge a group of cells, wrap the text and then use auto
fit function without any success in excel 2003. Can this be done and how?

Thanks,

Bob


--

Dave Peterson



All times are GMT +1. The time now is 03:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com