Online Price Guarantee: We will match any published price on any identical, in-stock item only from the following competitors: Edwin Watt's, Golf Galaxy, Dick's Sporting Goods, Golfsmith, Tennis Warehouse and TGW (The Golf Warehouse). Performance Guarantee Return:
Sort an Entire Table. Select the table that you want to sort by clicking the cell in the upper-left corner of the table and dragging your mouse to the lower-right corner. Click the Data tab. Click Sort in the Sort & Filter group to open the Sort window.Click the drop-down arrow under Sort By to view a list of the column headers. Clear the My Data Has Headers check box if your table doesn't have headings. Choose the column name or letter by which you want to sort the table.Choose A to Z or Z to A in the Order drop-down list and click OK to sort the table.ort an Entire Table. Select the table that you want to sort by clicking the cell in the upper-left corner of the table and dragging your mouse to the lower-right corner. Click the Data tab. Click Sort in the Sort & Filter group to open the Sort window.
Click the A â Z button. To sort the spreadsheet in alphabetical order, just click the A â Z symbol in the Sort and Filter section. This will rearrange the spreadsheet in alphabetical order of the selected column. On most versions of Excel, this button is in the top left corner of the Sort and Filter section.ere are a few ways to prevent this: 1  Format your header row differently. 2  Make sure there are no blank cells in your header row. 3  If Excel still screws up the sort, select the header row and use the top ribbon menu to click Home â Editing â Sort & Filter â Custom Sort â My data has headers.