How do I stop Excel from Automatically WRAPPING?

B

blitzen

I use Excel to manage my database files. When a cell contents get long
Excel automatically wraps the cell!

There has got to be a macro script I can apply when the worksheet i
opened.

The cell wrap was unchecked, however, the wrapping happen
automatically.

When this happens, I get a very long cell that is annoying. I have t
manually uncheck the wrap each time to have a managable spreadshee
whose cells are not longer than the displayed page.

This is not only slowing down my work but making my hands tired an
frustrated.

It is appreciated if anyone knows how to stop Excel from automaticall
wrapping the cells.

Thank you
 
D

Dave Peterson

The only time I've seen excel turn wrap text on automatically is when I typed
the alt-enter key.

Are you typing that (maybe for some kind of separator)???

You could record a macro that toggles that setting and run that macro whenever
you wanted to fix it.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top