Forum Discussion

Saiyooka's avatar
Saiyooka
Copper Contributor
Feb 05, 2020

when type a formula, i would like to move from the active cell not the formula cell

Hi all,   when I type formula in A1, see I would like it to be A1=C4+C5. I select C4 but if I want to move down to C5, it actually goes back to A1 and I need to go through all the cells again to ch...
excel
Formulas and Functions
mathetes's avatar
mathetes
Silver Contributor
Feb 05, 2020

Saiyooka 

 

Your description is a bit unclear, I'm afraid, so I'm going to be guessing at what you actually mean.

 

First of all, I'm going to assume that the formula you want in A1 is

=C4+C5

From there, the ambiguity continues, as I'm not quite sure what you mean by What can I do to set the active cell as C4 and the next one just move from C4?

What, for example, do you mean by "active cell as C4"? And what do you mean by "and the next one just move from C4?

 

So I'm going to assume that what you are wanting to do is make C4 an "anchor" or constant reference, and the others vary, cell by cell.

So IF that's what you mean, you do the anchoring by using an absolute cell reference. In which case, your formula in cell A1 would be

=$C$4+C5

and then, as you go down from A1, copying the formula down, it would become

=$C$4+C6

=$C$4+C7

=$C$4+C8

=$C$4+C9

and so forth.

But IS that what you mean? If not, please come back and ask. Here's a very good reference source on the subject of absolute references: https://exceljet.net/glossary/absolute-reference

 

 

Resources