I don't want my text to wrap

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

I have a cell where WrapText (format, cells, alignment, wrap text) is
set to Off. When I add text to the cell that contains line breaks,
Excel changes the formatting of the cell, and WrapText is set to On.
I have to manually turn WrapText Off for that cell. I have written a
macro to turn WrapText Off for a cell. But I would rather Excel not
change the formatting in the first place. Any ideas?
 

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

Similar Threads

Wraping Text 2
toggeling Macro 3
2007 AutoFit, WrapText, fails 1
for each loop 6
Word wrap macro deletes formula 3
Autofit/wraptext on vbLf problem 2
Modify Recorded Macro 1
Row height not auto adjusting on wrapped cells (Excel '07) 2

Back
Top