Disable wrap text?

I'm dealing with some data where I copy/paste stuff from a website onto an excel spreadsheet, and I'm doing it a ton (thousands of times by the end of this).

The problem is the cells wrap the text without me telling them to. Then I have to go in and disable wrap text for that individual cell.

Copy new piece of data, enter in new cell, excel auto wraps the text again. I have to unwrap text for that cell.

All the cells are have wrap text off, but when I copy/paste the data it activates wrap text. Is there any way to just turn wrap text off indefinately?

Thanks guys,

Zach

Originally Posted by DonkeyOte

If you're copying from the Web as implied then I suspect if you opt to Import as Text (rather than HTML) which should avoid the wrap, however, you may get empty rows which you don't want (and lose some other formatting).

An alternative might be to use some VBA which should preserve the formatting whilst removing the Wrap, eg:

Please Login or Register  to view this content.

to insert the above right click on the tab against which the code shoudl be applied select View Code and paste above into resulting window
(file must be Macro enabled when re-opened etc...)

I interpreted the VBA thing as to click the column I am pasting these codes into, and find the view code part of the column. I couldn't do find the view code part.

Originally Posted by martindwilson

why not just select the whole sheet and turn of wrap text?
what is the url to the data you are copying?

It's coordinates off of google maps. But they are really complicated computer talk and not filtered yet so they are long. Wrap text is already off for the whole document, its just when I paste the data something tells the cell to turn wrap text on for that specific cell because there is so much data. So I just want to turn off that automatic triggering of wrap text Excel is executing.

Originally Posted by DonkeyOte

Right click on the Tab name (ie the sheet name at the bottom of the screen) and select View Code - proceed from there as outlined.

I don't know about the macro-enabled stuff. But this works so far!

Originally Posted by DonkeyOte

If you're copying from the Web as implied then I suspect if you opt to Import as Text (rather than HTML) which should avoid the wrap, however, you may get empty rows which you don't want (and lose some other formatting).

An alternative might be to use some VBA which should preserve the formatting whilst removing the Wrap, eg:

Please Login or Register  to view this content.

to insert the above right click on the tab against which the code shoudl be applied select View Code and paste above into resulting window
(file must be Macro enabled when re-opened etc...)

This worked great until I saved the file (macro-enabled) and opened it again. Now that I open the file again it still has the same stuff on the view code section, but now the text wraps all the time when I don't want it to. I also moved some columns around in the excel file, but I doubt that should matter. Do you know what the problem is?

Originally Posted by DonkeyOte

I suspect Macros are not Enabled when re-opening the file

XL2003:
see: http://office.microsoft.com/en-us/of...001140307.aspx

XL2007+
see: http://office.microsoft.com/en-us/ex...010096919.aspx

No dice...I doodled around with some excel documents, and came to find that both before and after using macro, closing, and opening it up again my security settings are on "diasable all macros with notification". And "trust access to the VBA project object model" is unchecked. So I don't think the problem is in the security department because I don't think anything changed.

I also sampled all the other security options and none of them produced results for me.

Originally Posted by DonkeyOte

If you're running on a Network it's possible that there is a Group Policy in place controlling the Security Settings.

If you modify your Security settings, close Excel completely, reopen Excel have those settings you set been "reset" ?

No they remained

Originally Posted by DonkeyOte

When you open the file you should get a Dialog appear on screen (top of sheet) with an Enable Macros button.

I found this button! And stuff is working again. I assume I just have to click this everytime I open the file?

Thanks for the help man

Originally Posted by DonkeyOte

If you're copying from the Web as implied then I suspect if you opt to Import as Text (rather than HTML) which should avoid the wrap, however, you may get empty rows which you don't want (and lose some other formatting).

An alternative might be to use some VBA which should preserve the formatting whilst removing the Wrap, eg:

Please Login or Register  to view this content.

to insert the above right click on the tab against which the code shoudl be applied select View Code and paste above into resulting window
(file must be Macro enabled when re-opened etc...)

Hi! So I used this macro and voila! NO MORE AUTO WRAP! NIce. HOWEVER, IT ALSO DISABLED CTRL+Z and CTRL+Y (Undo and Redo) - can you please help? Thanks!