can a mark be set that can be returned to?

S

steve2645

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
 
O

Otto Moehrbach

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
 
S

steve2645

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...
 
J

Jim Thomlinson

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)...
 
Top