ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   numbering a column automatically (https://www.excelbanter.com/excel-programming/294295-re-numbering-column-automatically.html)

Max

numbering a column automatically
 
Frank has given you some answers ..

Taking your Q and subject line literally <g:

Put in any cell in column A, say in A1: =COLUMN()

Copy A1 across

Adjust accordingly depending on the column
you want to start the numbering from

For example, if col C is to be numbered "1"

Put in say C1: =COLUMN()-2

Copy C1 across

--
Rgds
Max
xl 97
--
Please respond, in newsgroup
xdemechanik <atyahoo<dotcom
---
"boettcher" wrote in message
...
How do I number a column automatically (eg: 1. 2. 3. ...)?





All times are GMT +1. The time now is 02:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com