SOLVED

New Contributor

# Formula edit questipon

hi,every experts.A simple question has bothered me several weeks.

When we first input  formula in a cell,we can use arrow keys to change the cells which we want calculate.

But if I want to change some part of the formula ,i must use my mouse to click that cell.

How can I use arrow keys to edit the formula???

My English is not very well, my friends and teachers also don't know what to do.

Reaally wanna get some help from you guys!!Thanks!!

7 Replies

# Re: Formula edit questipon

You may press F2 to enter into cell edit mode and navigate by arrows.

# Re: Formula edit questipon

Really appreciate your help! I pressed F2 and  can only change the cell by input their name,but not use arrow select it directly.

how can I solve it?

# Re: Formula edit questipon

Let say we stay on the cell with formula

Now I press F2 and navigate within the formula by arrows

# Re: Formula edit questipon

I want sum A7 and B7,when I first write this formula in D7 I can use dashed square to select cell easily;

If I want change A7 to another cell and press F2,I can only input a new cell name like "B5" or someting else. Their is no dased square for me to use arrow keys to select the other cell.

Do you know how to show that dashed square again?

best response confirmed by jiahao_zhang (New Contributor)
Solution

# Re: Formula edit questipon

In this case

- press F2

- select or remove A7

- press F2 again

- use arrow key to select another cell instead of A7

# Re: Formula edit questipon

got it! REALLY THANKS!!!!

# Re: Formula edit questipon

@jiahao_zhang , you are welcome