Excel 2007 Chart Data Selection- Arrow Keys Frustration

K

Kerry

I'm pasting a question I found posted on google but where the answer
required a subscription so I couldn't see it. Can anyone help me with
this same issue?

Pasted (link provided below):

I sure hope somebody can help with this. I have an issue with Excel
2007 that is driving me nuts. If I try to manually edit the chart
source data and try to use the arrow keys to move the cursor left or
right, the press of the key will highlight a cell on the sheet and add
the cell location to the data I'm trying to edit. Example:

Edit series, Series values=XPadDaily!$G$2:$G$22

If I click in the box and press the left arrow key, I get this
=XPadDaily!$G$2:$G$22+XPadDaily!$F$2"

If I press the up arrow key, I get "=XPadDaily!$G$2:$G$22+XPadDaily!$G
$1"

If I press the right arrow key, I get "=XPadDaily!$G$2:$G$22+XPadDaily!
$H$2"

If I press the down arrow key, I get "=XPadDaily!$G$2:$G$22+XPadDaily!
$G$3"

All I want to do is move the cursor to a point in the original formula
to make an edit. I'm sure this is a setting in configuration, but I
can't find it. I appreciate any help...it's driving me crazy.


Orig Link: http://www.experts-exchange.com/Sof...Office_Suites/MS_Office/Excel/Q_26478826.html
 

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

Similar Threads

Excel 2007 using arrow keys 1
Cursor Movement with Arrow Keys 1
Microsoft Excel - Looking up values from a range by selection by scroll of arrow keys. 1
How do I get my curser to move by using my arrow keys in Excel? 3
Clipboard Lost after using Arrow Keys 3
Automatically moving from one cell to another 3
Arrow keys on keyboard 5
Excel: Arrow keys scroll instead of moving to next cell??!! 2

Top