naming using F5 key
 

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.

naming using F5 key
 

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.


---
Regards,
Norman



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