Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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/Soft..._26478826.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 chart frustration | Charts and Charting in Excel | |||
How move a chart with arrow keys | Charts and Charting in Excel | |||
Excel 2007 using arrow keys | Excel Worksheet Functions | |||
How to navigate with arrow keys in Excel 2007? Tried Scroll Lock! | Excel Discussion (Misc queries) | |||
Excel 2007 - Arrow keys backwards in one text box | Excel Discussion (Misc queries) |