can a mark be set that can be returned to?
 

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

can a mark be set that can be returned to?
 

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
"steve2645" wrote in message
...
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

can a mark be set that can be returned to?
 

Thanks, Otto

that works

Steve

"Otto Moehrbach" wrote:

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
"steve2645" wrote in message
...
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

can a mark be set that can be returned to?
 

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

Jim Thomlinson


"steve2645" wrote:

Thanks, Otto

that works

Steve

"Otto Moehrbach" wrote:

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
"steve2645" wrote in message
...
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