Solved: EXCEL Wrap Text

In my database I have select all cells to wrap text but when the text is longer that the column width, the text wraps ok but I have to manually increase each row’s height to be able to see the text.

Is there a setting to have Excel increase the row height as needed to be able to see the contents?

 

You didn't mention the version of Excel but in 2010/2013 there is a 'wrap text' Icon on the home tab.

Select the whole spreadsheet by clicking the top left corner of the spreadsheet.
Clicking the 'wrap' text icon on home page\allingment section will turn wrap text on and off. (easier than going into 'propertes\format')
You can then select by columns the fields you want to auto fit.
With the whole column vertically selected, Hover over the column label (like "A") when the cursur changes from the down arrow to a plus sign (cursor will be near the edge) double click and that column will auto fit(horizonally if wrap is off). You can select multiple columns to auto fit as as well.

 

Sorry for the omission, I use Excel 2013

Dan I already do selecting all the sheet and format with the wrap text but I didn’t know about the column select trick, that’s pretty neat

Wayne it’s a long time since I did macros, how / where I do make the macro? And then how do I applied? Perhaps by selecting all the sheet and apply the macro?

Thanks to both for the help

 

ok I got the developer / VB, do I insert a UserForm, Module or Class Module?

 

Thanks Wayne, I went to Macros, selected this workbook, paste the code as per above and saved the file as .XLSM. Now when I type in a cell a long text the row still does not expand. What is wrong?

 

Thanks anyway

Cheers

 

A note on my previous post. If you select multiple columns vertically it will 'auto fit' them all when you do the plus sign double click as well (instead of one at a time).

 

I only have Office2013 since last September and I must say that I hate the new ribbon menus (I had before Office2002). The guy who designed the ribbon should be banned for life from working in programming because to my opinion he made it worse than ever.

I used to do all my work in Excel / Word with keyboard shortcuts and now most of these are gone and have to go thru the ribbons to find what I need (very inconvenient and time consuming)

Anyway I found under the HOME ribbon, Format Tab, the “AutoFit Row Height” and this is what I was looking for. Regardless of my column width, when I type a long text and hit Enter the row adjust to fit my text.

Thank you all