Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with naming | Excel Discussion (Misc queries) | |||
Tab Naming | Excel Worksheet Functions | |||
Tab Naming | Excel Worksheet Functions | |||
Tab Naming | Excel Discussion (Misc queries) | |||
Tab naming | Excel Discussion (Misc queries) |