Formula edit questipon

New Contributor

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


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

@Sergei Baklan 

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?


Let say we stay on the cell with formula


Now I press F2 and navigate within the formula by arrows


@Sergei Baklan 


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)


In this case

- press F2

- select or remove A7

- press F2 again

- use arrow key to select another cell instead of A7

got it! REALLY THANKS!!!!

@jiahao_zhang , you are welcome