Data for a buy is entered by row in the Worksheet Buy Columns section of the worksheet. See Worksheet Description. Rows may initially be loaded from the Quick Entry tab. 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.
Placing the mouse pointer anywhere in a row (except in the Comments column) will display a popup text box showing the vendor name, insertion date, space code, columns, quantity, unit and ad number for that row. Placing the pointer in the Comments cell of a row displays the full name for any targets for comments for that row.
Rows are initially sorted according to the Worksheet Table Sort setting on the Preferences tab. The Preferences sort is reapplied whenever you select another tab, save or reload the worksheet.
You may select and apply a different sort on the Preferences tab whenever a worksheet is open. This sort remains the default until you exit the worksheet but is not saved to the named Preference format keyed on the Start Up tab, if any.
Changes made to the column order for all three tables on the worksheet are saved as well as changes made to column widths. When you go back into an existing worksheet, both your set column order and column widths are preserved as long as you have saved the worksheet.
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 replaced by the current Preferences sort when you select another tab, save or reload the worksheet.