how do make column numbers 1 throuh 500

  • Thread starter Thread starter Guest
  • Start date Start date
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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 
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
 
Back
Top