how do i make values increase by 1 while going down a cell

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

Guest

I enter in numbers in a column and i want to drag the box down and have the
number increase by one from the previous number in each cell. HELP!
 
Enter the first in A1 (23 for example) and the second (24) in A2
Select A1 and A2 and pull the fill-handle (solid square in lower right of
selected cell) down the column

Or enter the first number; select the range to fill; use Edit | Fill ->
Series
best wishes
 
Enter a number in A1.

Right-click and drag down.

Release button and "Fill Series"


Gord Dibben MS Excel MVP
 

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

Copying a formula with an increase of more than 1 6
how do i have a cell number increase by 1 each time file opened 1
increase an entire spreadsheet by a percentage 2
Copying formulas by scrolling 1
Increasing all values in spreadsheet by same percentage. 1
Increase cell value by 1 month 1
copy formula - keep cell same but increment sheet numbers 5
Increase numbers by 15% in multiple cells 4

Back
Top