Cell double clicked is not one selected for editing

P

phillman5

15" MBP, 2.6 GHz Intel core 2 duo. OS: Leopard 10.5.8. Excel 2008
(12.2.3)

If I leave Excel to use another application and then come back to it,
often double clicking a cell to start 'in cell editing', another cell
will be chosen, often many screens away from where I wanted (I've
double clicked G255, and cell G6 will be chosen). I then have to find
where I was. This is unusable!

Has anyone experienced this? Any solutions?

This doesn't happen with Excel 2004.
 
P

phillman5

See message from CyberTaz titled

Re: Excel on MacBookPro : double click on cell walls sends you to end
of spreadsheet

The navigation feature has always been there as well [PC Excel also]
but
most users have never known it. It serves as an efficient way to
return to
the top of the sheet or a column of content. It takes you to the last
filled
or last empty cell above the one you dbl-click in the column dependent
on
whether that cell has content or is empty.
However, with higher resolution screens resulting in smaller cell
display
it's quite easy to accidentally double-click the top edge of the cell
rather
than in its center. Note the difference in the pointer appearance: If
it's
*on* the cell it will look like a bold white cross, if it's on the
*top
edge* of the cell it will look like a Hand [Mac] or Select Objects
arrow
[PC].
BTW, dbl-clicking the left edge of the cell works in a similar fashion
to
move left.
 
B

Bob Greenblatt

15" MBP, 2.6 GHz Intel core 2 duo. OS: Leopard 10.5.8. Excel 2008
(12.2.3)

If I leave Excel to use another application and then come back to it,
often double clicking a cell to start 'in cell editing', another cell
will be chosen, often many screens away from where I wanted (I've
double clicked G255, and cell G6 will be chosen). I then have to find
where I was. This is unusable!

Has anyone experienced this? Any solutions?

This doesn't happen with Excel 2004.
Another possibility is that you have "Edit directly in cells" turned off. If
so, double clicking in a cell will select the cell's precedents.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top