Nov 24 2021 04:16 AM
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)
Nov 24 2021 04:38 AM
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.
Nov 25 2021 01:17 AM
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