auto numbering of columns

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

Using Excel, how can I auto number my columns on a page
(more than 1 column), example; 1 - 100.
This will be for a referance point only.
Thanks
Mark
 
Mark,

In A1, add the formula =COLUMN() and then just copy across.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Or just type "1" in the first Column and then do a Ctrl Drag across and it will do the auto increment feature and count up to wherever you stop.
 
Back
Top