How do I get auto fill to do decending numbers in a column?

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

Guest

I am trying to get excel to do decending numbers from 50 to 1 in a column and
no matter what I try it still will not do it. What am I doing wrong?
 
Hi

one way, type 50 in the first cell, underneath it type 49, then select both
cells, now go to the fill handle on the 49 and drag down.

Cheers
JulieD
 
Put 50 in the first cell, put 49 in the second, select both cells and grab
the fillhandle and fill down or put 50 in the first cell, right click and
fill down and when you release the mouse select series and put -1 in step
value box

Regards,

Peo Sjoblom
 
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

Auto filter drop down box 1
Sorting Numbers 3
Sorting and Formulas 1
How do I create a league table in excel 2003 2
Data ascending and decending 3
how do I sort rows by the contents of one cell 1
how do I sort a column the 2nd time by non repeating #s? 12
I can't sort data when the key column cells contain formula 6

Back
Top