![]() |
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