entering number down to cell

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

Guest

I wanted to enter numbers in a column in ascending order leaving one cell
blank for example if I entre 1 in cell A1 in A3, 2 comes automatically
leaving A2 cell blank.
 
Enter 1 in cell A1. Then select both cells A1 and A2. Drag these two cells
down. The number 2 will be in cell cell A3, 3 in cell A5, etc.
 
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

Give blank in cell 2
Enter number (data) into cells but want to show different data 3
Continuous Invoice Nos. 3
Blank Cell Reference, without if statement 4
Excel - in a row of numbers, put last entered number Cell B2 7
I need a formula for if cells a1 and a2 are the same then cell a3 3
Formula to find the last number of a column (lower cell) 1
Sorting a list of numbers 3

Back
Top