MS Excel as a Database
Full text
Figure
Related documents
121 Rule #25: Before click the “A ➔ Z” icon button in the Sort & Filter Group on the Data Ribbon, make sure your block of data is in the Proper Excel List/Table Format
Select a variable in the Sort by list and click on the Ascend/Descend button to sort the rows in the data table in ascending or descending alphabetical order of column values.. The
Click the field heading or any cell in the list that contains the data you want to sort. On the PivotTable Options Ribbon, use Descending or
Select the column you want to sort by, the value to sort by and the sort order for the first level of sorting6. Click
Press <Ctrl z> (or click on the [Undo] button) twice to return the data to its original order - or, with this data, you could use [Sort & Filter] on Column A.. Note how
Open the Data menu and select Sort… then click on [Options...] and check that Sort left to right and Sort by Row 1 are still
Click on the Home Tab and then click the down arrow to right of the Sort & Filter command button located to the right of the screen within the Editing group.. Note: for
In the Page View, open the Page Header section, right-click the object that you want to bind the sort control to (such as the customer field), and then select Bind Sort