Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. ...)? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Numbering rows 1-60, how do I do it automatically? | Excel Discussion (Misc queries) | |||
How do i doconsecutive numbering on invoices automatically? | Excel Worksheet Functions | |||
change column numbering to column letters in my spreadsheet view | Excel Discussion (Misc queries) | |||
automatically numbering rows | Excel Worksheet Functions | |||
automatically numbering rows | Excel Discussion (Misc queries) |