Jumping Between Cells

  • Thread starter Thread starter DebraAnn
  • Start date Start date
D

DebraAnn

I was wondering if someone could clarify the following:

When double clicking near the edge of a cell, the cursor
often jumps to another cell in a totally different area of
the worksheet. At first we though it was the file, but
this actually happens if we open up a new spreadsheet and
move around the page - double clicking on different cell
edges. Before you know it, it starts jumping to other
cells.

We have a spreadsheet whose cell heights are not very big
and the constant jumping is quite annoying. Is there
anything that can be done to stop it?

Thanks,
 
If you double-click on the left edge of the activecell then it will take you to
the leftmost cell in that row, and likewise if you double-click on the top edge
of the activecell it will take you to the topmost cell of that column - Is that
what you mean?
 
That's it Thank you.

-----Original Message-----
If you double-click on the left edge of the activecell then it will take you to
the leftmost cell in that row, and likewise if you double- click on the top edge
of the activecell it will take you to the topmost cell of that column - Is that
what you mean?

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

---------------------------------------------------------- ------------------
It's easier to beg forgiveness than ask permission :-)
---------------------------------------------------------- ------------------






---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.613 / Virus Database: 392 - Release Date: 04/03/2004


.
Click to expand...
 
You explained it correctly. But, getting back to her original question, is
there anything that can be done to stop it?

I realize it's a feature. But it's an annoying one, one I have never used
intentionally, yet have done lots of times accidentally. It would be very
nice if there were an option to turn this feature off.

Excel User
 
Gee learned something new! This looks like a cool feature!


: You explained it correctly. But, getting back to her original question, is
: there anything that can be done to stop it?
:
: I realize it's a feature. But it's an annoying one, one I have never used
: intentionally, yet have done lots of times accidentally. It would be very
: nice if there were an option to turn this feature off.
:
: Excel User
:
:
:
: :
: > LOL - My pleasure
: >
: >
: >Regards
: > Ken....................... Microsoft MVP - Excel
: > Sys Spec - Win XP Pro / XL 00/02/03
:
:
: : > That's it Thank you.
: >
: >
: > >-----Original Message-----
: > >If you double-click on the left edge of the activecell
: > then it will take you to
: > >the leftmost cell in that row, and likewise if you double-
: > click on the top edge
: > >of the activecell it will take you to the topmost cell of
: > that column - Is that
: > >what you mean?
: > >
: > >--
: > >Regards
: > > Ken....................... Microsoft MVP -
: > Excel
: > > Sys Spec - Win XP Pro / XL 00/02/03
: > >
: > >
: > message
: > >: > >> I was wondering if someone could clarify the following:
: > >>
: > >> When double clicking near the edge of a cell, the cursor
: > >> often jumps to another cell in a totally different area
: > of
: > >> the worksheet. At first we though it was the file, but
: > >> this actually happens if we open up a new spreadsheet
: > and
: > >> move around the page - double clicking on different cell
: > >> edges. Before you know it, it starts jumping to other
: > >> cells.
: > >>
: > >> We have a spreadsheet whose cell heights are not very
: > big
: > >> and the constant jumping is quite annoying. Is there
: > >> anything that can be done to stop it?
: > >>
: > >> Thanks,
: > >
: > >
 
One way to turn it off kills something else--so I don't turn it off.

Tools|Options|Edit tab|Allow cell drag and drop

But drag and drop (and autofill) is too useful to disable (for me at least).
 
Back
Top