Re: Automatically number rows preceded by text


Ardus Petus wrote:
Enter PSC1 in A1
Activate A1
Click on the little black square at bottom right corner of cell A1
Drag down

Et voilà!

--
AP
(Excel 2000)

<jazdwit07@xxxxxxx> a écrit dans le message de news:
1149522163.064434.118760@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi.
I apologize if this question has been asked in the past.
I am trying to automatically number rows in a column that are preceded
by text. ex. column, A1, PSC1; A2, PSC2, A3, PSC3, etc. I tried
hightlighting a number of rows with the data entered and tried dragging
the fill handle down, but that did not work.
Your help is appreciaed!
Thanks.

Hi.
I tried that, but all it did was copy same info to next row.

.

Relevant Pages

  • Re: the drag feature in combining cells wont work
    ... bottom right corner of the cursor, and double-clicking it will copy the ... Pete, thanks for the answer, but I still can't get the drag feature to ... like D2 I get nothing but a blank cell all the way down the column. ... highlight and drag and it will do it for you. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Adding and Multiplying Question
    ... on the bottom right of the cell with the above formula ... and drag down to row 260. ... Prev by Date: ...
    (microsoft.public.excel)
  • Re: Automatically number rows preceded by text
    ... Click on the little black square at bottom right corner of cell A1 ... Drag down ... I apologize if this question has been asked in the past. ...
    (microsoft.public.excel)
  • new to excel
    ... Now Click the little black box in the bottom right of the ... cell and drag the formula down as many lines as you like. ... >find an answer in references that I am using and I am ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Merging 2 sheets
    ... I apologize to mention this, ... You do not need to drag the formula- you can write it in one cell, ... Good luck ...
    (microsoft.public.excel)
Loading