Forum Discussion
How to move from previously used cell instead of start cell(using arrow keys)
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 al...
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.
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