How to move from previously used cell instead of start cell(using arrow keys)

Copper Contributor

Hi, 

I am having trouble searching for a command

 

if I enter in cell E5:

=A5*

Then I click the arrow keys to move to another cell it starts me back at E5

 

Is there any shortcut that would allow me to start using arrow keys from the cell I was on last(Cell A5)

2 Replies

Hi @s200152,

 

If i understand your query well, you need to refer back to last cell you were working.. in that case the easy shortcut would we enter the cell ref in the calculation

 

Regards, Faraz Shaikh | Microsoft MVP, MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official/Best Answer & like it to help the other members find it more.

@Faraz Shaikh 

 

Hi Faraz, 

I understand how to type this in but I am dealing with large data sets that need to be multiplied individually. Was wondering if there was a way with the keyboard arrows and another key to hold reference to that last cell used and move from there