Data for a buy is entered by row in the Worksheet Table and Schedule sections of the worksheet. See Worksheet Description. Key or select data for each column of a row, and/or use Worksheet Functions to enter or change data on one or more selected rows. Use the Filter tab to hide rows.
Rows are initially sorted according to the Worksheet Table Sort setting on the Preferences tab.
You may select and apply a different sort on the Preferences tab or Filter tab whenever a worksheet is open. The Preferences sort that is in effect when you close the worksheet will be the initial sort the next time you open a worksheet. The Filter sort is only in effect until you close the worksheet or clear the sort on the Filter tab.
You may also sort worksheet rows by the values in any column. Click the column heading to sort the data in ascending order. To reverse the sort (descending order), shift-click the column heading. This sort is not saved when you exit the worksheet. To return to the default sort, exit the worksheet or select the Preferences tab and apply the default sort.
The worksheet also allows multiple columns (demographics) to be sorted. To sort a column, simply click on the column header. By default, the first sort is in ascending order. Clicking the column once more sorts the column in a descending order. Clicking on the same column heading a third time removes the sort. A number is displayed at the bottom left hand corner displaying the numeric order of the sort.