What iteration of Excel are you using (2003, 2007 etc)? You need to use the “sort” tool, which in 2007 is accessed by selecting the DATA tab. There is then a window called “Sort & Filter”. Click at the top of the column you are interested in and press either A-Z to sort lowest to highest or Z-A Highest to Lowest. You can only sort columns like this.
Do you know about fill? If you enter your smallest or largest number (say 10 as you want to insert 10 down to 1), Click and hold on the cell with the number in and drag and highlight a number of cells. Then on the Home tab of Excel 2007 you will see a Fill button in the Editting field. Click on that and select Series, select your step value and your end value (so for 10 down to one you would enter step = 1, end value = 1). Click Ok.
OR
enter the first 2 values of your series in to two cells (so to do the same count cell 1 would = 10, cell 2 would = 9), click and highlight the two filled cells. You will see at the bottom right hand corner of the lowest/right most cell, a small square. Click on this and drag across the column/row that you want to fill and Excel will auto fill. It will even show you the value of each cell as you proceed.
