I know how to autofill numbers going downward. But I'm curious if you can autofill numbers going upward? I'm using Excel 2011 on MacOS X (El Capitan).
It may sound counter-intuitive, but my boss wants to see the newest items in a list on top. But I also number these items, and don't want item the newest item to show up as item #1.
Here's a rough example:
* #5 1/14/16
* #4 1/13/16
* #3 1/12/16
* #2 1/11/16
* #1 1/10/16
Right now, I'm sorting the dates by newest-to-oldest. But how do you sort the item number by highest-to-lowest?
Make sense?
Answer
If you manually enter #2 above #1 and then select both cells, you can grab the fill handle and fill upward.
No comments:
Post a Comment