Now, if you’re using Excel 97, click on the grey rectangle where row and column headers meet to select the entire spreadsheet. Now click Data > Sort. A dialogue box pops up. Make sure the radio button next to “Header row” near the bottom of the dialogue box is selected, and sort by (Order Number) in ascending order. Your spreadsheet should now have the orders arranged by Order Number, with the lowest number at top and the largest number at bottom. This is a convenient sequence for the first few steps.
