Forum Discussion

s200152's avatar
s200152
Copper Contributor
Nov 24, 2021

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 allow me to start using arrow keys from the cell I was on last(Cell A5)

excel

2 Replies

  • ExcelExciting's avatar
    ExcelExciting
    MVP
    Nov 24, 2021

    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.

    • s200152's avatar
      s200152
      Copper Contributor
      Nov 25, 2021

      ExcelExciting 

       

      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

Resources