text wrap

S

shank

I cut-n-paste a lot of text into Excel. Most everytime I have to uncheck the
text wrap option to get the text to layout correctly. Is there a way to
have this always default to unchecked no matter what I'm pasting?

thanks!
 
D

Dodo2u

I cut-n-paste a lot of text into Excel. Most everytime I have to
uncheck the text wrap option to get the text to layout correctly. Is
there a way to have this always default to unchecked no matter what
I'm pasting?

thanks!
Click to expand...

You could select the whole sheet and then set the wrap property before you
start pasting.
 
D

Dodo2u

You could select the whole sheet and then set the wrap property before
you start pasting.
Click to expand...

Or the other way around: paste and then set wrap for the whole sheet. That
way the height of the rows will be adapted automatically, I just found out.
 
S

shank

Dodo2u said:
Or the other way around: paste and then set wrap for the whole sheet. That
way the height of the rows will be adapted automatically, I just found
out.
Click to expand...

I appreciate your help, but I was hoping for a solution everytime I open a
new sheet. Can that option be defaulted to always be unchecked? Presently,
when I have this problem, I do select the whole sheet and set it. However,
it does not help for the next paste in the same sheet. Every time I paste, I
must uncheck the box.
thanks
 
A

arthursdomain

Not sure what your trying to say, but. If you go to
format>style>modify>alignment tab>click on text wrap or unclick text
wrap. That will format your whole sheet. As far as when your paste
and it then checks, the only way I can see that happening is if the
cell your copied had text wrap selected, which would then carry over
the preference. If your only carrying over 'text' then what you want
to do is instead of clicking on the cell and hitting the ctrl+c or v or
copy, you want to go to the fx bar and manually highlight the text use
ctrl+c there then select the 'new' cell and then paste it. It will not
carry over any alignment from the old cell and will only copy over the
text. That might help. If you want to copy the cell to cell, the
properties inside will carry over and I dont believe there is anyway to
lock them so that they dont, besides what I suggested above.

Z
 
S

shank

Not sure what your trying to say, but. If you go to
format>style>modify>alignment tab>click on text wrap or unclick text
wrap. That will format your whole sheet. As far as when your paste
and it then checks, the only way I can see that happening is if the
cell your copied had text wrap selected, which would then carry over
the preference. If your only carrying over 'text' then what you want
to do is instead of clicking on the cell and hitting the ctrl+c or v or
copy, you want to go to the fx bar and manually highlight the text use
ctrl+c there then select the 'new' cell and then paste it. It will not
carry over any alignment from the old cell and will only copy over the
text. That might help. If you want to copy the cell to cell, the
properties inside will carry over and I dont believe there is anyway to
lock them so that they dont, besides what I suggested above.

Z
Click to expand...

Try this....
1) Open a new sheet
2) Copy some lengthy text from Access or wherever
3) Paste into Excel
4) Select entire worksheet, format as no text wrap
5) Move cursor down to some clean rows and paste again
6) You will have to format the cells again to remove text wrap

It's just annoying having to do that everytime

thanks
 
D

Dave Peterson

I think excel looks for linefeeds within your pasted text. If it finds one (or
lots), it figures you want to use textwrap.

So, does your copied data have line feeds?

If it doesn't, then was the cell formatted to wrap text before you pasted?

Either way, maybe you could have a macro that will toggle the textwrap for each
cell in the selection--based on the activecell.

Option Explicit
Sub ToggleTextWrap()
Selection.WrapText = Not (ActiveCell.WrapText)
End Sub

You could put this in your personal.xls (and create a button or assign a
shortcut key) and have it available all the time.

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
 
Top