how do make column numbers 1 throuh 500

S

Sandy Mann

Enter in A1:

=ROW() and drag down ro A500

or:

Enter 1 in A1, 2 in A2, highlight both cell and copy down on the fill handle

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
M

MartinW

And one more for good measure.
Enter 1 in A1
Grab the fill handle and drag down to A500
Hold down Ctrl then let go of the left button, then let go of Ctrl

HTH
Martin
 
Top