Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to number cells (1,2,3...) w/o having to manually type them al
am making a form for signing up items. Need to number column cells (1, 2,
3...) without having to do it manually. Is there a function that will do it for me? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to number cells (1,2,3...) w/o having to manually type them al
One way...
Assuming you want column A to number as you enter data in column B. Enter this formula in A2 and copy down far enough to account for future data addition in column B. =IF(B2="","",COUNTA(B$2:B2)) -- Biff Microsoft Excel MVP "Botkinmama" wrote in message ... am making a form for signing up items. Need to number column cells (1, 2, 3...) without having to do it manually. Is there a function that will do it for me? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to number cells (1,2,3...) w/o having to manually type them al
In your first cell, say A1, enter 1.
In your second, say A2, enter =a1+1 Now drag this formula down your column as far as you want to go. Regards, Fred "Botkinmama" wrote in message ... am making a form for signing up items. Need to number column cells (1, 2, 3...) without having to do it manually. Is there a function that will do it for me? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nested If statement to control format of number-type cells | Excel Worksheet Functions | |||
Excel Format Cells - Number Tab - Custom - Order of Type Window. | Excel Discussion (Misc queries) | |||
Manually number row without adding column | Setting up and Configuration of Excel | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) |