|
Lets hope for a better solution, but in case:
enter 1, in A1 and hold the CTRLK key and formula drag to 600, this will number the range for you.
enter Car in B1 and drag to 50, Truck in 51 and drag to 100 etc.
The range can then be used as a range, or named and used as a Named Range.
(note, to Formula drag, click the small square in the bottom right corner of the highlight)
|