fjm210
asked on
Excel 2007 arrow keys inserting data
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$2 2
If I click in the box and press the left arrow key, I get this =XPadDaily!$G$2:$G$22+XPad Daily!$F$2 "
If I press the up arrow key, I get "=XPadDaily!$G$2:$G$22+XPa dDaily!$G$ 1"
If I press the right arrow key, I get "=XPadDaily!$G$2:$G$22+XPa dDaily!$H$ 2"
If I press the down arrow key, I get "=XPadDaily!$G$2:$G$22+XPa dDaily!$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.
Thanks!
Jerry
Edit series, Series values=XPadDaily!$G$2:$G$2
If I click in the box and press the left arrow key, I get this =XPadDaily!$G$2:$G$22+XPad
If I press the up arrow key, I get "=XPadDaily!$G$2:$G$22+XPa
If I press the right arrow key, I get "=XPadDaily!$G$2:$G$22+XPa
If I press the down arrow key, I get "=XPadDaily!$G$2:$G$22+XPa
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.
Thanks!
Jerry
This is how Excel anticipate of how you press the arrow keys in a keyboard:
Once you select a cell with a formula on it and use the arrow keys, Excel anticipates that you are looking for a cell name to be added into the formula. To tell Excel that you need only to edit a word, a text in the formula, you need to click the formula bar and in that way your arrows will work as the same way it is with Word.
Sincerely,
Ed
Once you select a cell with a formula on it and use the arrow keys, Excel anticipates that you are looking for a cell name to be added into the formula. To tell Excel that you need only to edit a word, a text in the formula, you need to click the formula bar and in that way your arrows will work as the same way it is with Word.
Sincerely,
Ed
ASKER
Thanks for the comments Ed, but that's not quite the issue. I've attached a couple of screenshots in a Word document to show the issue. What I'm doing is trying to edit the data source entry for a chart. When I click in the box and want to scroll left to manually edit the entry $A$22, the moment I click the arrow, it inserts more cell reference and won't scroll the cursor. I never had this happen when using Excel 2003 or before, only with 2007.
Before.doc
Before.doc
This drives me nuts as well. I just make sure to only use the mouse in places like that, never the keyboard arrows. The arrow keys work fine on the spreadsheet itself and in the main formula bar, just not in chart range bars and such.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks rorya! This worked perfectly.
You must select the cell that has the formula, then click the mouse in the formula bar. From there, you can use the arrow keys.
Ed