Expanding a cell

[Bfish]

Simple question for you today. I have a cell that information is going into, sometimes this information is a paragraph. I have wrap text activated on the cell but when there is a lot of information in the cell all I'm seeing is ############ across the cell. Is there a setting somewhere that will expand the cell so the information can be viewed? I don't want to use the shrink to fit option cause it will be way to small to read. I appreciate any help.

Thanks

 

[VoG]

With the cell selected press CTRL + 1, on the Alignment tab check Wrap Text then click OK.

 

[Bfish]

With the cell selected press CTRL + 1, on the Alignment tab check Wrap Text then click OK.

I already have wrap text activated for the cell. I want the cell to expand as information is entered.

 

[moonfish]

I don't think I've ever seen this happen before. If wrap text is enabled and your data is in fact text, Excel is not supposed to display ######## (value too long error), it's supposed to break the data over multiple lines.

Even if there's some sort of reason for the information not to fit, it will still not display the value too long error. It will simply display only a part of your data.

Could you give an example of the data that could go into a cell?

 

[Bfish]

I don't think I've ever seen this happen before. If wrap text is enabled and your data is in fact text, Excel is not supposed to display ######## (value too long error), it's supposed to break the data over multiple lines.

Even if there's some sort of reason for the information not to fit, it will still not display the value too long error. It will simply display only a part of your data.

Could you give an example of the data that could go into a cell?

Ok so say I have this text:
Garnier Fructis Style Hairspray Collection: Introducing Our First Ever Hairspray With Bamboo Extract And Anti-Humidity Protection For Long-Lasting Hold And Natural, Healthy-Looking Movement. Why Bamboo?: Selected For Its Strength, Suppleness And Resilience, Bamboo Bends But Never Breaks. This Formula Keeps You In Control Of Your Style With Frizz Control And Bounce-Back Hold That Lasts All Day. What Is Volumizing Hairspray?: This Volumizing Hairspray Lifts From Root To Tip To Boost Flat, Tired Hair With Body, Fullness And An Extra Strong Hold - Even With Moisture In The Air - All Day, Everyday. Volumize Your Style: Volumizing Hairspray Styles: Use Any Garnier Fructis Style Product With Volumizing Hairspray To Boost Any Style. For More Volume, Lift Hair Or Tilt Head Upside Down And Spray Toward The Roots. Blow Dry While Brushing Away From The Scalp. Spray All Over To Finish Any Style.

It is in a cell with row height of 15, column width of 18.29, formatted to Text, wrap text is activated, and alignment is Left (indent), Bottom.

 

[moonfish]

I don't think this exists within Excel. You generally have to adjust column width and row height manually, which is one of the major frustrations in using Excel (at least, for me). There is a simple trick facilitate this process though:

If you want to adjust the width of column B to 'auto'-fit the text, move your cursor to the separator between the headers for column B and column C. The cursor shape will change to indicate you can drag this line back and forth. Don't drag. Double-click the separator.

 

[Bfish]

I don't think this exists within Excel. You generally have to adjust column width and row height manually, which is one of the major frustrations in using Excel (at least, for me). There is a simple trick facilitate this process though:

If you want to adjust the width of column B to 'auto'-fit the text, move your cursor to the separator between the headers for column B and column C. The cursor shape will change to indicate you can drag this line back and forth. Don't drag. Double-click the separator.

Well I was afraid someone was going to say that. lol I guess I'll just have to expand the column width and row height a little and hope that that data being put in that column is not too large. I have figured out how to get rid of the ######## that displays. I just changed the formatting from text to general and it got rid of it.