Disable Wrod Wrap in Excel - how?

[MikeBronner]

Is there a way to disable automatic word wrap in excel?

I am faced with the problem that everytime I enter more data than can be displayed in a single cell, the cell height is changed to accomodate for the additional text.

I want to diable this, and tried adjusting the cells using the Format... option when right-clicking on the respective cells. However, even after I uncheck word-wrap there and do a new entry, it does word-wrap again.

Thanks! Take Care,
Mike

 

[Dreamboat]

Set your row heights back to normal, Mike.
techsupportgirl@home.com

http://www.PiersonTech.com

Brainbench MVP for Microsoft Word

 

[marchristensen]

Highlight the appropriate cells. On the menu chose FORMAT CELLS and click on the ALIGNMENT tab. Look at the bottom where it says Text Control and uncheck the box marked WRAP TEXT.

 

[MikeBronner]

Did all that guys . The only problem with that is, that those modifications aren't permanent. The next time I make a change, it blows up the rowhight again.

Thanks. Take Care,
Mike

 

[Dreamboat]

Well, if you hit ctrl-a and set the row height and remove the wrap text, it should NOT happen. Ctrl-a will select all of the cells.
techsupportgirl@home.com

http://www.PiersonTech.com

Brainbench MVP for Microsoft Word

 

[MikeBronner]

Thats whay I thought too. Unfortunately it didn't work.
The only work-around I found was to write some code to reset the rowheight after new text was input. Take Care,
Mike

 

[dawnd3]

Michael, is the text you are entering copied and pasted from somewhere else, like an internet page? If so, it will word wrap again, even if you have selected all and unchecked word wrap. I think you could use paste special and paste only the text, if this is the case. I copy and paste a lot in word, so I have created a simple macro attached to a button that does paste special and makes formatting changes less of a headache. Dawn

 

[MikeBronner]

Actually, all the info is typed in, so no pasting or copying done here. *(mumbles something about stupid ms office97 functionality)* Take Care,
Mike