Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto number for a parts list.
I want to auto number a parts list . How do you do that with part text and
part number. Example ( MJCF1/2-001,MJCF1/2-002,MJCF1/2-003) How could I auto number this way? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto number for a parts list.
If I understand your question correctly, you can increment these
numbers by dragging the fill handle - enter MJCF1/2-001 in a cell, then put the mouse pointer over the little box in the lower right corner of the cell until the cursor changes, left-click and drag down. Cliff Edwards |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you auto-number a large list of rows in Excel? | Excel Discussion (Misc queries) | |||
Formula needed for my parts list | Excel Discussion (Misc queries) | |||
Printing selected parts of a list.... | Excel Worksheet Functions | |||
Dependant parts list -lookup | Excel Discussion (Misc queries) | |||
Auto repeate parts of functions | Excel Worksheet Functions |