>.
>
My co-workers and I HATE this feature.
We want to turn it OFF.
We mainly work with large spreadsheets that must be in a
certain format that forces our data to be in one large
contiguous block. One mis-click and you're at row 12947
instead of row 3450.
We all experience this annoyance multiple times a day.
>.
>
Go to Tools > Options > Edit (tab) and uncheck the box for "Allow cell drag
and drop".
--
HTH,
Laura Cook
Appleton, WI
"James" <nos...@nospam.com> wrote in message
news:02bb01c36747$fac04770$a301...@phx.gbl...
We're deciding between the lesser of two evils:
(1) turn off the annoyance
(2) lose cell drag n drop
>.
>
What reasoning do you have for going through the above motions (causing the
annoyance)? Usually, if I want to edit within a cell, I don't bother
selecting it first and then double clicking, just double click on the cell
straight away. Or, if the cell is already selected, I usually click in the
formula bar and start editing.
Just wondering :)
--
Laura Cook
Appleton, WI
"James" <nos...@nospam.com> wrote in message
news:049801c3674e$76203c80$a101...@phx.gbl...
so, when we double-click on a cell to edit the contents,
we get the annoyance about 1 out of 5 times.
But when it does happen (and it happens several times
a day) it's very aggravating because you lose your
spot in the worksheet. It's extremely aggravating when
we're onsite and have to make changes to our systems
and are trying update the worksheet, etc....
And, we cannot put breaks in our worksheet since the data
gets exported to another program which halts the import
process when it sees a CRLF
Yeah, I guess it could sound trivial.
>.
>
(Just another option for those who don't want to lose drag and drop.)
And Dana DeLouis gave a neat tip a few months ago:
http://groups.google.com/groups?threadm=e4louZ6CDHA.1304%40TK2MSFTNGP11.phx.gbl
Excel has a built in feature that remembers it's last 4 locations. It is
usually used in Macros, but you can access this feature manually.
With your cell selected, (say z100), select the name box....and just hit
enter.
This adds the current selection to Excel's memory.
Now move your selection back to A1.
Hit F5 to bring up the "GoTo" feature, and just hit enter to return to z100.
If you hit F5 at a later time, and z100 is not the "Previous" location, you
still might be able to select it from the list.
HTH. :>)
========
I don't think that something like this would be effective to do everytime you
change your selection, but it might be neat to show off to your coworkers!
--
Dave Peterson
ec3...@msn.com
Thanks Dave & Laura for your great advice!