SOLVED

Formula edit questipon

%3CLINGO-SUB%20id%3D%22lingo-sub-2290546%22%20slang%3D%22zh-CN%22%3EFormula%20edit%20questipon%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2290546%22%20slang%3D%22zh-CN%22%3E%3CP%3Ehi%2Cevery%20experts.%20A%20simple%20question%20has%20bothered%20me%20several%20weeks.%3C%2FP%3E%3CP%3EWhen%20we%20first%20input%26nbsp%3B%20formula%20in%20a%20cell%2Cwe%20can%20use%20arrow%20keys%20to%20change%20the%20cells%20which%20we%20want%20calculate.%3C%2FP%3E%3CP%3EBut%20if%20I%20want%20to%20change%20some%20part%20of%20the%20formula%20%2Ci%20must%20use%20my%20mouse%20to%20click%20that%20cell.%3C%2FP%3E%3CP%3EHow%20can%20I%20use%20arrow%20keys%20to%20edit%20the%20formula%3F%3F%3F%3C%2FP%3E%3CP%3EMy%20English%20is%20not%20very%20well%2C%20my%20friends%20and%20teachers%20also%20don't%20know%20what%20to%20do.%3C%2FP%3E%3CP%3EReaally%20wanna%20get%20some%20help%20from%20you%20guys!!%20Thanks!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2290546%22%20slang%3D%22zh-CN%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2290879%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20edit%20questipon%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2290879%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1036650%22%20target%3D%22_blank%22%3E%40jiahao_zhang%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20press%20F2%20to%20enter%20into%20cell%20edit%20mode%20and%20navigate%20by%20arrows.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2291114%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20edit%20questipon%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2291114%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1036650%22%20target%3D%22_blank%22%3E%40jiahao_zhang%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ELet%20say%20we%20stay%20on%20the%20cell%20with%20formula%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20187px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F275548iE3F4DE76CF840B82%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3ENow%20I%20press%20F2%20and%20navigate%20within%20the%20formula%20by%20arrows%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20209px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F275549i8DFE2A02AEBA01BA%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
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

@jiahao_zhang 

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?

@jiahao_zhang 

Let say we stay on the cell with formula

image.png

Now I press F2 and navigate within the formula by arrows

image.png

@Sergei Baklan 

jiahao_zhang_0-1619431166008.png

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

jiahao_zhang_1-1619431429772.png

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

@jiahao_zhang 

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