auto numbering 1,2,3,...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I tried ctrl drag and got nothing. I could have typed them in by now but I would learn nothing THX!
 
Hi Richard
not sure what you're trying to achieve or what your issue is. Could you
explain with some more detail?
 
Drag the "fill handle" (the little square in the lower right of the cell
selector). If you don't see it, make sure Tools, Options, Edit, Allow Cell
Drag and Drop is selected.
 
Richard

Method 1. Enter 1 in A1, 2 in A2 then select both cells drag/copy down using
the fill handle(right-bottom corner of cell).

Method 2. Enter a 1 in A1 then right-click and drag down. Release button and
"Fill Series".

In both cases, be sure you have Tools>Options>Edit "allow cell drag and drop"
checkmarked.

Gord Dibben Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to subtract a number from a Mergefield? 0
Autofill alphanumeric prefix in Excel 2
The next Grand Theft Auto title has been officially announced 0
Column references changed from letters to numbers 2
3 option boxes to linked cell-linked cell to be 1,2,3. 1
Panasonic cf-29 boot from CD 0
AutoFill A to Z 4
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3

Back
Top