Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
#Value Being Returned for Blank or Non Zero Value | Excel Worksheet Functions | |||
same name being returned | Excel Discussion (Misc queries) | |||
#N/A value is returned | Excel Worksheet Functions | |||
need to know how to get the sum of right product returned | Excel Worksheet Functions | |||
#Value! Returned ? | Excel Worksheet Functions |