problems editing data range

W

wn

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?
 
E

Elkar

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

Cell data entering slow! 0
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Range headings 0
How do I resize the "Edit Series" box? 0
Publisher 2019 Format Picture window size too large to display OK button 0
Pasting a cell into bookmarked table from excel vba 1
Excel: Arrow keys scroll instead of moving to next cell??!! 1
how do I use the arrow keys to move the cell pointer? I have excel 0

Top