can a mark be set that can be returned to?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In a large worksheet (lots of rows and/or columns), can a mark be set in a
cell so you can return to that cell from another location in the worksheet?

Thanks
 
Steve
Select that cell. Click on Insert - Name - Define.
Type in a name for that cell, say, Steve.
When you want to go back to that cell, press the F5 key.
Find Steve in the list of names.
Click on it.
Click OK.
Done. HTH Otto
 
Thanks, Otto

that works

Steve

Otto Moehrbach said:
Steve
Select that cell. Click on Insert - Name - Define.
Type in a name for that cell, say, Steve.
When you want to go back to that cell, press the F5 key.
Find Steve in the list of names.
Click on it.
Click OK.
Done. HTH Otto
Click to expand...
 
In addition to the F5 route you can just select the named range from the Cell
Address drop down immediately above cell A1. Also you can add the named Range
by typing it in the same place and hit enter (I always forget to hit the
enter when I am done)...
 
Back
Top