naming using F5 key

[Guest]

Hi, I used to name cells in lotus 123 and use F5 to go there, I used a number
(it's quicker to type in but when I try this in Excel it says not a valid
name when I try to use a number say, 101. is there any way around this.

Thank you in advance, Wildauk.

 

[Norman Jones]

Hi Wildauk,

Names must be alphanumeric and must start with an alpha character. Amongst
other restrictions, it is not possible to use a name which might be confused
with an Excel address, e.g. A100.

Perhaps you could name your ranges numerically and employ an initial
underscore character.