R
rhythmrealty
Using Excel 2007 and the damned program is now taking my paste and
automatically doing a text to columns. How do I stop it?
automatically doing a text to columns. How do I stop it?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
S
Shane Devenshire
If you copy data that looks like it is a delimited set of data Excel
sometimes does what I think you're describing. If you are copying a single
enter the solution is to select the target cell and then put you cursor on
the Formula Bar and paste.
sometimes does what I think you're describing. If you are copying a single
enter the solution is to select the target cell and then put you cursor on
the Formula Bar and paste.
D
Dave Peterson
Excel is trying to help.
Earlier you ran a text to columns (manually or in code) and it remembers the
settings you used.
To make excel forget your settings:
#1. You can close excel and reopen it (yechhh!)
#2. You can do a dummy text to columns.
pick an empty cell
type something into it
do the text to columns
Use delimited, but uncheck all the options
finish up that wizard
and clean up this cell's contents.
Earlier you ran a text to columns (manually or in code) and it remembers the
settings you used.
To make excel forget your settings:
#1. You can close excel and reopen it (yechhh!)
#2. You can do a dummy text to columns.
pick an empty cell
type something into it
do the text to columns
Use delimited, but uncheck all the options
finish up that wizard
and clean up this cell's contents.
T
T. Valko
Depending on how much this bugs you (it bugs me a lot!), JWalk has a macro
you could assign to a toolbar button:
http://spreadsheetpage.com/index.php/tip/clearing_the_text_to_columns_parameters
You'd just have to remember to click the button after you've done a TTC
operation.
you could assign to a toolbar button:
http://spreadsheetpage.com/index.php/tip/clearing_the_text_to_columns_parameters
You'd just have to remember to click the button after you've done a TTC
operation.
D
Dave Peterson
And if you have a macro that does this text to columns and you share it with
others, it's a good idea to include that kind of clean-up routine.
It may stop emails and phone calls!
others, it's a good idea to include that kind of clean-up routine.
It may stop emails and phone calls!