You have a beautiful spreadsheet that you use to track customer purchases. Every time you get a purchase order, you enter it into the spreadsheet so you can track orders. But your boss wants to have the spreadsheet sorted by customer name. What do you do? You could laboriously go through and insert a row in the appropriate place each time you get an invoice….NOT! What you need to do is learn to use the Sort function in Excel. It’s really quite easy.
And that is how to use the sort function in Excel. The great thing about this is you can resort as many times as you want. If one person wants a sort by name and another a sort by zip code, sort it once, do your print out, and then sort it again for then second print. And remember, you don’t have to save the sort. You can always close the spreadsheet without saving so it saves your original order. Later I’ll talk about using the Subtotal function on your sorted spreadsheet.
Anyone else have any tips to add for sorting in Excel?