Number autofill cell issue

Joined
Sep 23, 2023
Messages
43
Reaction score
1
I would like a quick filling of a sequence like 1 2 3 4....
Autofill Cell -Down: this will not do the job
I would like to use the key down arrow instead of drag with the mouse
 
Last edited:
Joined
May 7, 2023
Messages
747
Reaction score
115
The only way that I know how to do this is to put a the number one in the cell (for exaple in cell a1). Then in the cell below it (cell a2) put the formula =a1+1. Then use the autofill feature by dragging the yellow dot at the bottom of the second cell down, and this will fill down in sequence.
 

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

Top