problems editing data range

G

Guest

I am trying to edit the data range for a series (5 non-adjacient cols x 400+
rows so clicking on the select cell block is not really an option, I just
want to change the last cell from x400 to x407).

When I use the arrow keys to move to the end of the input field, it inserts
the address of a cell behind the graph.

How do I move the edit point without using the END, or arrow keys(which
insert the current, of new addres of the "cell pointer")? OR
How can I resize the "Edit Series" box so I can see the complete text and
then use the mouse to select the cell number I want to change?
 
G

Guest

Hit the F2 key. This toggles between using the arrow keys to navigate the
formula and naviagting the data range.

HTH,
Elkar
 

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: Arrow keys scroll instead of moving to next cell??!! 2
Editing Conditional formatting formula 3
Cannot navigate between cells using arrow keys 2
excel 2007- when selecting a range to edit, it has no highlight 1
how to keyboard navigate to other cells during editing formula, when arrow keys don't work 1
Up and Down Arrows do not work 2
how do I set the arrow keys to move only the highlight not the ta 1
Peculiar Excel problem with my keyboard arrows 2

Top