1st line needs to be just the name no # in beginning, how?

  • Thread starter Thread starter PeterM
  • Start date Start date
P

PeterM

I just typed a list of names and other information from line 1 to line
30. I also have the heading on top of each column. That line also has a
number 1 in the front, how can I start the 2nd line as number 1, which
is actually the first person in the list, and then 1 to 30 down the list
etc etc. I know it is probably very easy to do, but I have a block, a
mental block right now. How do I change things, please have mercy and
let me know.......Peter
 
If you already have a blank column ready for the numbers then great, but if not then just select
Col A and do Insert / Columns. Now in cell A2 put a 1, then in cell A3 put a 2. Select A2:A3 and
then hover the mouse over the bottom right hand corner of cell A3, left click on the little black
cross and drag down to your 30th line. This should increment the numbers and automatically fill
them in sequence.
 
I guess I wasn't too alert this morning. You can't change the first
number and subsequent numbers on the sheet. The line started with the
right number as I entered the names. I wished I never send out the
message now........Peter
 
Hi Peter, assuming your numbers are in column A, just delete the number
one that is next to your title, type the number 1 in the correct cell
then select the cell. You should see a black box around the cell with a
very small solid black box in the lower right hand corner after you
select the cell, left click and hold the small solid black box and drag
it as far down as you need to go. You might get a little box at the
bottom that you can click that gives you choices...one of them is "fill
series", choose that, and you should have numbers from 1 to whatever
your last cell was, in your example, 30. To do this with code, you
would paste the following code into a module in your workbook:


Code:
--------------------

Sub fillNumbers()
Range("A2").AutoFill Destination:=Range("A2:A" & Range("B65536").End(xlUp).Row), Type:=xlFillSeries
End Sub
--------------------


This code assumes the number 1 is in cell A2, and your names are in
column B. It will fill down the series of numbers all the way to the
last name you have in column B. It doesn't care whether there are blank
cells in column B or not, it will still put a number next to it.

I hope this helps a bit, or at least points you in the right
direction..

Have a good night,

Dave M.


edit: Oops, I'm way too slow to read, and too fast to post... :-)
 
If I understand you, you just want 1-30 in a column. so, put 1 in a1 and 2
in a2. find the grab handle in the lower right of the cell with 2 and drag
down.
 
Back
Top