Click this to see how the report will look when printed.


Click this to change the report specifications.


This is where you type a name for the report, or you can accept the name Works suggests. You can use up to 15 characters, including blank spaces and punctuation, for the name.


This is where you type the report title, or you can accept the title Works suggests. Works automatically displays and prints the report title on the report. The report title can be different from the report name: it can be longer and more descriptive because you can use up to 255 characters.


Lists the available fonts you can apply to all the information in your report. Click the arrow to display a list of fonts, and then click the one you want.


Lists the available font sizes you can apply to all the information in your report. Click the arrow to display a list of font sizes, and then click the one you want.


Shows how the font and font size will look in the report.


Click this to specify that the report be printed in portrait orientation. With portrait orientation, the height is greater than the width. Click this to accept or clear this option.


Click this to specify that the report be printed in landscape orientation. With landscape orientation, the width is greater than the height. Click this to accept or clear this option.


Lists the fields included in the database you have open. Works lists the fields in the same order as they appear in List view. Click the field you want to add, and then click the Add button.


Click this to add the highlighted field in the Fields Available box to the list of fields in your report. When you add a field, Works copies the field name to the list of report fields.


Click this to remove a field from the Field Order box. Useful if you change your mind after you have added a field.


Click this to add all the fields listed in the Fields Available box to your report.


Click this to remove all the fields from the Field Order box. Useful if you want to start over, or when you want to list the fields in a different order.


Lists all the fields you have included in the order they will appear in your report.


Specifies that the field names are displayed and printed (in bold face type) as titles across the top of each page of your report. Can help make long reports easier to read and follow.


Specifies that your database information is summarized and displayed instead of printed in detail. Useful when you want to count and display the number of records for a category (customers in a specific region), without showing all of the records (every customer name).


Lists all the fields you have included in your database or report. Click the arrow to display a list of all the fields, and then click the field you want Works to use first as it sorts. For example, you could sort a report alphabetically based on your customers’ last names by choosing the field that contains the last names.


Lists all the fields you have included in your database or report. Click the arrow to display a list of all the fields, and then click the field you want Works to use second as it sorts. Then, if Works finds duplicates in the first sort field (two customers with the same last name, for example), it will look next in the field you specify here.


Lists all the fields you have included in your database or report. Click the arrow to display a list of all the fields, and then click the field you want Works to use third as it sorts. Then, if Works finds duplicates in the first two sort fields (two customers with the same last name and city, for example), it will look next in the field you specify here.


Click this to list sorted field entries in ascending order (from A to Z or 1 to 99, for example).


Click this to list sorted field entries in descending order (from Z to A or 99 to 1, for example).


Specifies that a blank line is inserted between entries in the field wherever the content in that field changes. For example, Works could group together all entries with the same country and separate them from other entries in other countries on the report. Click this to accept or clear this option.


Specifies that a blank line is inserted between entries in the field whenever the first letter in that field changes. For example, Works would group together all last names starting with A, and separate them from all last names starting with B on the report, and so on.


Specifies that each group is printed on a separate page. Click this to accept or clear this option.


Specifies that the content of the field is used as the group heading (for example, the name of a city). Click this to accept or clear this option.


Lists any filters that are associated with the database you have open. The All Records filter includes all records in your database in your report, whether they are hidden or not. The Current Records filter excludes the hidden records in your database from your report. Any filters you have created will also appear in the list. Click the filter you want to apply.


Click this to display the Filter dialog box, where you can define a new filter to apply to your report.


Click this to display the Filter dialog box, where you can change the filter currently highlighted in the Select A Filter box. The All Records and Current Records filters are always included and cannot be changed.


Describes what the filter highlighted in the Select A Filter box looks for as it looks at the information in your fields.


Lists all the fields included in this report. Click the field for which you want Works to calculate a statistical value. For example, click the field that includes a list of customer names, and then click the Count option to count the number of customers.


Specifies that a heading is included next to or above the calculation result. For example, when you pick the Sum option, Works displays the name “Total” next to the result.


Click this to total all the values in the field highlighted in the Select A Field box. Use this summary calculation with a field that contains numbers; for example, to total your company’s sales for the month of July.


Click this to average all the values in the field highlighted in the Select A Field box. Use this summary calculation with a field that contains numbers; for example, to average your students’ scores on a math test.


Click this to count the number of entries in the field highlighted in the Select A Field box. For example, you could count the number of items in your inventory.


Click this to find the smallest numeric value in the field highlighted in the Select A Field box. Use this summary calculation with a field that contains numbers; for example, to find the lowest temperature for the year from a list of daily temperatures.


Click this to find the largest numeric value in the field highlighted in the Select A Field box. Use this summary calculation with a field that contains numbers; for example, to find the highest score in a series of test results.


Click this to calculate the standard deviation for the numeric values contained in the field highlighted in the Select A Field box; for example, to calculate the standard deviation for the useful life of a product.


Click this to calculate the variance for the numeric values contained in the field highlighted in the Select A Field box; for example, to calculate the variance for a set of population data.


Click this to display summary information at the end of each group. You can print summary information at the end of each group, at the end of the report, or in both places.


Click this to display summary information at the end of the report. You can print summary information at the end of the report, at the end of each group, or in both places.


Click this to print summary information under the appropriate field’s column.


Click this to print summary information in rows at the end of the report or at the end of each group (depending on what you specified).


Lists the filters you have created. Click the arrow to display the list of filters, and then click the one you want.


This is where you type a name, up to 15 characters, for a new filter or an existing filter selected in the Filter Name box.


Click this to rename the current filter.


Click this to create a simple filter. If you need to create a complex filter that does not fit easily into the format provided in this dialog box, click Filter Using Formula instead.


Click this to create a complex filter that requires a formula. For example, use this option to select records when the total of field 1 and field 2 exceeds 100.


This is where you type the formula for a filter. For example, =SUM(Field1, Field2)>100.


Lists the fields in the database. Click the arrow to display a list of fields, and then click the one you want.


Lists the comparison phrases and other choices by which you can compare the Field Name item with the Compare To criteria.


This is where you type the value or criteria to be compared. You can type text, numbers, or formulas.


Specifies how to add another new line of criteria to the preceding criteria. Click the arrow, and then click either “and” or “or.” Use “and” to find the records that meet every criteria. Use “or” to find records that meet one of the criteria.


Specifies that the filter will display only those records that do not match the filter criteria. Click this to clear or accept this option.


Click this to create a new filter. If you already have eight filters in the database, you must delete one before creating a new filter, or you can modify an existing filter.


Click this to delete the currently displayed filter from the list.


Click this to close the Filter dialog box and apply the filter to the records in the database.


Click this to close the Filter dialog box. If you have made changes to the current filter, Works displays a message asking if you want to keep or discard the changes.


Click this to move to the next tab, which contains additional attributes for database reports.


Click this to return to the previous tab.


Click this when you are finished defining attributes for your report. You can click Done at any time. Works will create a report based on whatever attributes you have defined up to that point.


Lists all the fields you have included in your database. Click the arrow to display a list of all the fields, and then click the field you want Works to use first as it sorts. For example, to sort alphabetically based on your customers’ last names, choose the field that contains the last names.


Lists all the fields you have included in your database. Click the arrow to display a list of all the fields, and then click the field you want Works to use second as it sorts. If Works finds duplicates in the first sort field (two customers with the same last name, for example), it will look next in the field you specify here.


Lists all the fields you have included in your database. Click the arrow to display a list of all the fields, and then click the field you want Works to use third as it sorts. If Works finds duplicates in the first two sort fields (two customers with the same first and last name, for example), it will look next in the field you specify here.


Click this to list sorted field entries in ascending order (from A to Z or 1 to 99, for example).


Click this to list sorted field entries in descending order (from Z to A or 99 to 1, for example).


Click this to insert or delete records in your database. When inserting, Works inserts a new record above the highlighted record (or records).

If you want to empty the contents of the record without removing the record, use the Clear command on the Edit menu instead.


Click this to insert or delete fields in your database. When inserting, Works inserts a new field to the left of the highlighted field (or fields).

If you want to empty the contents of the field without removing the field, use the Clear command on the Edit menu instead.


This is where you type the characters you want to search for. You can include any letter, number, punctuation mark or wildcard character. A question mark represents any single character in the same position as the question mark. For example, type anders?n to find Anderson and Andersen. An asterisk (*) represents any number of characters. For example, type pro* to find all words that begin with the letters pro.


Click this to find the next occurrence of the information you specified in the Find What box.


Click this to search through all the records in the database, including hidden ones. Works will display all the records that contain the search text and hide the records that do not.


This is where you type the field name you want. You can use up to 15 characters, including blank spaces and punctuation.


Click this to display all entries in this field in general format. Numbers are displayed as precisely as possible and aligned to the right; text is aligned to the left.


Click this to display all entries in this field in a number format that you select from the Appearance list box.


Lists the different ways you can display numbers, dates, times, and fractions in a cell or field. Click the format you want.


This is where you type the number of decimal places or the total number of digits, including leading zeros, you want to display for entries in a field. Or, you can click the scroll arrows to select the number of decimals or digits you want.


Specifies that negative numbers are displayed in red and enclosed in parentheses. You must have a color printer to print red negative numbers.


Click this to display all entries in this field in a date format that you select from the Appearance list box.


Click this to display all entries in this field in a time format that you select from the Appearance list box.


Click this to format all entries in this field as text (left-aligned), whether they are numbers or text, or a mix of both. Useful when you are entering numbers that contain special characters (for example, the hyphen in a telephone number).


Click this to display all entries in this field as fractions in a format that you select from the Appearance box.


Click this to assign a unique number to each record. The number you assign to a record will stay with that record whether you move it, cut it, paste it or sort the database. Useful as a consistent unique identifier for each record.


Shows what value will be assigned to the next record that contains this field. Accept this number, or click the box and type a new number.


Shows the value used to increment the numbers assigned to each record. Accept the default to have the numbers increase by one, or click the box and type the increment you want. Or, click the scroll arrows to raise or lower the increment.


Specifies that Works automatically enters the same default information into all records. Useful when all the customers in your database have addresses in the same state, for example.


This is where you type the information you want in this field for every record. You can always type over the information for a record that requires something different in this field.


Lists all the fields in the current database. When you press the tab key in a database form, Works will move the highlight to each field in the order listed here. Click a field, and then click the Up or Down button to change its order in the sequence.


Click this to move the highlighted field up by one in the sequence of fields.


Click this to move the highlighted field down by one in the sequence of fields.


Click this to arrange the fields in this database with the default tab order. With the default tab order, Works moves from the top left field to the bottom right field.


Click this to cancel any changes you have made to the tab order while this dialog box was open. Your database will retain whatever tab order was in effect before you chose the Tab Order command.


Lists the available fonts. Click the scroll arrows to display a list of fonts, and then click the name of the font you want to apply to the highlighted cells or fields.


Lists the available font sizes. Type the font size you want, or click the scroll arrows to display a list of available sizes, and then click the font size you want to apply to the highlighted cells or fields.


Lists the available colors you can apply to text. Click the scroll arrows to move up or down in the list of colors, and then click the color you want. Although you can display colors on your screen, you must have a color printer to print the information in color.


Specifies that text is displayed as bold or plain. Click this to accept or clear this option. You can combine this style with any of the others in the Style box.


Specifies that text is displayed as italic or plain. Click this to accept or clear this option. You can combine this style with any of the others in the Style box.


Specifies that text is displayed as underlined or plain. Click this to accept or clear this option. You can combine this style with any of the others in the Style box.


Specifies that text is displayed as strikethrough or plain. Click this to accept or clear this option. You can combine this style with any of the others in the Style box.


Shows how text will look with the fonts, font styles, and colors you have chosen.


Click this to use the current font choices for all new databases.


Specifies that Works prevents changes to information contained in the highlighted fields. Useful for preventing instances where data or results from calculations might be typed over accidentally. Click this to clear or accept this option.


This is where you type the measurement you want for the width of the picture, chart, or object. When you change the measurement, Works automatically recalculates the scaling measurements to reflect the scaled size of the picture or object.


This is where you type the measurement for the height of the picture, chart, or object. When you change the measurement, Works automatically recalculates the scaling measurements.


This is where you change the width of the picture, chart, or object by typing a percentage of the picture’s or object’s original width. For example, type 50 to reduce the object’s width by half.


This is where you change the height of the picture, chart, or object by typing a percentage of the picture’s or object’s original height. For example, type 200 to double the height of the picture or object.


Shows the original width and height measurements of the picture, chart, or object.


Specifies that Works will activate the object when you double-click it in Form view. Click this to clear or accept this option.


This is where you can type a label for your database form. The label can be a title or other descriptive text to identify the form or a field on the form. Use this instead of a field name when you want to position a label for a field anywhere on the form.


Click this to insert the label for your database form and close the dialog box. You can drag the label to position it anywhere on the form.


Click this to fill the blank cells in a selection with a series based on the information at the beginning of the selection. For example, Quarter 1, Quarter 2, Quarter 3, Quarter 4. You can use AutoFill with seasons, days of the week, and months of the year.


Click this to increase or decrease the number in a series you are creating based on the number in the Increase by box.


Click this to fill the blank cells in a selection with a series of dates that increases by days, including Saturday and Sunday. For example, July 21, 2003, July 22, 2003, July 23, 2003, July 24, 2003, July 25, 2003, July 26, 2003.


Click this to fill the blank cells in a selection with a series of dates that increases by weekdays only; this excludes Saturday and Sunday from the series. For example, July 21, 2003, July 24, 2003, July 25, 2003, July 26, 2003.


Click this to fill the blank cells in a selection with a series of dates that increases by months. For example, November 27, 2003, December 27, 2003, January 27, 2004, February 27, 2004.


Click this to fill the blank cells in a selection with a series of dates that increases by years. For example, April 15, 2002, April 15, 2003, April 15, 2004, April 15, 2005.


Type the amount by which you want a series to increase or decrease. Type a positive number to make the series increase (1, 2, 3, 4); type a negative number to make the series decrease (4, 3, 2, 1).


Click this to paste the resulting value of a formula, but not the formula itself, into a new location. Useful when you are consolidating information from several spreadsheets into one.


Click this to add the pasted value to a value already contained in the cell or range you are copying or moving to.


Click this to subtract the pasted value from a value already contained in the cell or range you are copying or moving to.


Type the characters you want to search for. You can include any letter, number, cell reference, punctuation mark, or wildcard character. A question mark represents any single character in the same position as the question mark. For example, type Anders?n to find Anderson and Andersen. An asterisk (*) represents any number of characters. For example, type pro* to find all words that begin with the letters pro.


Type the characters you want to insert in place of the characters in the Find what box. If you used the Copy command to copy the characters from another location, you can use the CTRL+V keyboard shortcut to paste the information here.


Click this to have Works search from left to right by rows for the characters you have specified.


Click this to have Works search from top to bottom by columns for the characters you have specified.


Click this to have Works search through the formulas or values in your spreadsheet for the characters you have specified.


Click this to have Works search through the values that result from formulas, rather than the formulas themselves, as it looks for the characters you have specified.


Click this to replace the found text with the text in the Replace with box.


Click this to replace all text in the spreadsheet that matches the text in the Find what box with the text in the Replace with box.


Click this to find the next group of characters that matches the characters in the Find what box.


Click this to stop your search and close this dialog box.


Type a cell reference (for example, A1) that you want to view in the spreadsheet.


Select the range name that represents the cells you want to view in the spreadsheet.


Click this to go to the range name or cells you specified.


Click this to cancel the task and close the dialog box.


Click this to apply the column width necessary to accommodate the largest entry in the selected column(s). When more than one column is selected, Works applies an appropriate width to each column.


Click this option and then type the exact column width measurement you want (in number of characters) for the selected column(s).


Click this to apply the standard column width to the selected column(s).


Type the exact column width measurement you want (in number of characters) for the selected column(s).


Click this to apply the row height necessary to accommodate the tallest entry in the row(s). When more than one row is selected, Works applies an appropriate row height to each row.


Click this and then type the exact row height measurement (in number of points) that you want for the selected row(s). You can type a number from 4 to 1008, depending on the current font size.


Type the exact row height measurement (in number of points) that you want for the selected row(s). You can type a number from 4 to 1008, depending on the current font size.


Click this to apply the standard row height to the selected row(s).


Click this to display the values in the selected cell(s) in the format you want. Numbers are displayed as precisely as possible and aligned to the right; text is aligned to the left.


Type or select the number of decimal points you want to display. Works displays numbers rounded to the number of decimal places you specify. For example, if you specify two decimal places, then 1234.567 displays as 1234.57.


Click this to display the numbers in the selected cell(s) with a separator (such as a comma or period) every three places. Clear this to hide the separators.


Click this to show negative numbers in red for the selected format type. Works prints the numbers in red if you have a color printer. Clear this to show negative numbers using the standard color.


Click the format type you want to use for the date.


Click this to use the euro as the currency indicator for the selected cells. If this checkbox is not selected, Works uses the currency symbol set in the Currency tab in Regional Settings on the Control Panel.


Type or select the total number of digits, including zeros, you want to display in selected cells. For example, 521 displays as 000521 if you specify 6 as the total number of digits.


Select the fractional denominator you want to display for the selected cells. Select All Fractions to convert numbers to their precise fractional values.


Select the way you want the time to display in your spreadsheet.


Select the color you want to use for the background of the cell. The Automatic option applies the same color used for the background on your screen (usually white).


Select the color you want to apply to the dots and lines of a pattern. Click Automatic to have Works choose a color (usually black).


Select the pattern of dots and lines to use in a cell. The None option applies no pattern in a cell.


Click this to align text to the left and numbers to the right within a cell. Until you specify another alignment, all cells are formatted this way.


Click this to align text and numbers to the left within a cell.


Click this to align text and numbers to the right within a cell.


Click this to center text and numbers horizontally within a cell.


Click this to repeat the contents of a cell until the cell is full. Useful for repeating single characters, for example, an asterisk (*).


Click this to center text and numbers vertically within a cell. Useful when you have assigned a cell a height that is taller than a single line.


Click this so that the cell height automatically changes so text wraps within the cell. Clear this if you want the cell height to remain constant regardless of whether all text is visible.


Click this to align text and numbers with the top of a cell. Useful when you have assigned a cell a height that is taller than a single line.


Click this to align text and numbers with the bottom of a cell. Useful when you have assigned a cell a height that is taller than a single line.


Click this to center text and numbers across a group of selected cells. Useful when you want to display a title across the top of a spreadsheet.


Click this to add a box around the selected cells. You can easily see the borders if you turn off the gridlines; choose Gridlines from the View menu.


Click this to add a border along the top of the selected cells. You can easily see the borders if you turn off the gridlines; choose Gridlines from the View menu.


Click this to add a border along the bottom of the selected cells. You can easily see the borders if you turn off the gridlines; choose Gridlines from the View menu.


Click this to add a border along the left side of the selected cells. You can easily see the borders if you turn off the gridlines; choose Gridlines from the View menu.


Click this to add a border along the right side of the selected cells. You can easily see the borders if you turn off the gridlines; choose Gridlines from the View menu.


Click this to remove all borders from the selected cells. You can easily see that the borders are turned off if you also turn off the gridlines; choose Gridlines from the View menu.


Click this to add borders to all horizontal and vertical lines within the outer border. This is available only when you select more than one cell.


Click this to add a border along the interior vertical lines. This is available only when you select more than one cell.


Click this to add a border along the interior horizontal lines. This is available only when you select more than one cell.


Select the color you want to apply to the borders. Although you can display colors on your screen, you must have a color printer to print the information in color.


Select the type of line to use for the borders.


Select the format you want to use for the cells you selected. A preview of how the format looks appears below.


Click this to format the last row of the selection as a Totals row for easy identification. Clear this to show the last row with the same formatting as the rest of the selection. The AutoFormat style does not compute the totals for you.


Click this to format the last column of the selection as a Totals column for easy identification. Clear this to show the last column with the same formatting as the rest of the selection. The AutoFormat style does not compute the totals for you.


Click this to format the first row of the selection as a Header row for easy identification. Clear this to show the first row with the same formatting as the rest of the selection.


Click this to format the first column of the selection as a Header row for easy identification. Clear this to show the first column with the same formatting as the rest of the selection.


Select the category that contains the type of function you want to use.


Select the function you want to use. The functions shown are based on the category you selected.


Click this to insert the function into the spreadsheet.


Click to insert a page break marker above the currently selected row or cell.


Click to insert a page break marker to the left of the currently selected column or cell.


Click to delete a page break marker above the currently selected row or cell.


Click to delete a page break marker to the left of the currently selected column or cell.


Click this to sort only the cells that you selected in the spreadsheet. All other columns and rows will not be sorted.


Click this to sort the selected cells along with the corresponding data in other columns in the same row. For example, if the first column has first names and the second has surnames, and you selected only first names, use this option so the surnames appear next to the corresponding first names after you sort.


Click this so that Works does not include the first row while sorting. Use this option when your first row contains headings. Clear the box when the first row does not contain headings.


Select the column you want to use as the basis for sorting.


Select the next column you want to sort by. Works sorts using the first column you selected, then by the next column you select, and so on.


Click this to list sorted cell entries in ascending order (from A to Z or 1 to 99, for example).


Click this to list sorted cell entries in descending order (from Z to A or 99 to 1, for example).


Click this to close the dialog box and perform the sort.


Click the calculation you want to use. Works will display a dialog box asking you to select the cells that contain the values you want to use.


Click this to see a complete list of functions available in Works.


Click this to return to the previous dialog box.


When this button is Next or Insert, Works performs the next step in the calculation. When the button is Finish, Works closes the dialog box and completes the calculation.


Type (or select from the spreadsheet using the button) the cell reference for the value(s) you want to use in the calculation. If cell references are already displayed, you can accept the displayed references.


Type (or select from the spreadsheet using the button) the cell reference where you want the result of the calculation to appear.


Click this to minimize the dialog box so you can select the cell or range of cells you want to use in the spreadsheet. When you click the cell in the spreadsheet, the cell reference appears automatically in the dialog box.


Select this to display the status bar along the bottom of the Works window. The status bar provides information about the active spreadsheet or the selected command. Clear this to hide the status bar.


Select this to show the fonts on the toolbar in the way they will look in your spreadsheet. Useful when you want to see how a font looks before you apply it. Clear this to show all font names in a standard font.


Select this to display the name for the current task under the pointer as you work. Clear this to hide the task name under the pointer.


Select the dictionary you want to use when spell checking a Works document.


Click this to measure page size and margins in inches.


Click this to measure page size and margins in centimeters.


Click this to measure page size and margins in picas.


Click this to measure page size and margins in points.


Click this to measure page size and margins in millimeters.


Click this to send a spreadsheet as the body of an e-mail message when you click the Send command on the File menu. Use this for small spreadsheets that contain only a few rows or columns of data, or when you’re not sure if the recipients have Works 6.0 installed on their computers.


Click this to send a spreadsheet as an attachment in an e-mail message when you click the Send command on the File menu. When you send the e-mail message, Works sends the spreadsheet too. Use this for spreadsheets that contain a large amount of data.


Select this so that the spell checker ignores words in all uppercase letters. Use this when you have a spreadsheet that contains many words in all capital letters and you want to speed up the spell checking process.


Select this so that the spell checker ignores words that contain numbers. Use this when you have a spreadsheet that contains many words with numbers and you want to speed up the spell checking process.


Select this so that the spell checker ignores all Internet addresses and paths on your hard drive, for example, http://www.microsoft.com or C:\My documents\Spreadsheets\finances.xlr. Use this when you have a spreadsheet that contains many addresses and paths and you want to speed up the spell checking process.


Click this so you can edit your data and formulas in either the cell that contains the data or the formula bar at the top of the spreadsheet.


Click this so you can edit your data only in the formula bar at the top of the spreadsheet.


Click this so you can edit your data only in the cell that contains the data.


Type the number of decimals you want to display by default. You can override the number in your spreadsheet if necessary.


Click this to display cells that contain a value of zero as blank cells. This setting applies to the active spreadsheet only. Use this to make your spreadsheet look cleaner. Clear this to show zeros in cells.


Select this so that Works calculates formula results only when you specifically request it, not automatically as usual. This setting applies to the active spreadsheet only. Use this if you have a large spreadsheet with many formulas that take a long time to calculate. Clear this to calculate formula results automatically.


Click this to move the insertion point to the cell below the current cell when you press the ENTER key. For example, if you are typing in cell A1 and press ENTER, the insertion point will move to cell A2. Clear this to keep the insertion point in the same cell when you press ENTER.


Type the new name for the active document you want to save as a custom template. The file name can have spaces and capitalized letters.


Click this to expand the dialog box so you can view or edit the name of the current default template.


Click this to specify that the active spreadsheet will be the default template for future spreadsheets. Clear this to use the default spreadsheet provided with Works. You must close all spreadsheets and then restart the Spreadsheet program for the changes to take effect.


Click this to clear, or stop using, the default template for the spreadsheet. You must clear the current template before you can set a new default template.


Type or select the number you want to assign to the first page of your document.


Select this to print the horizontal and vertical cell gridlines in the spreadsheet. Clear this to print without the gridlines.


Select this to print the row numbers (the numbers down the side of the spreadsheet) and the column letters (the letters across the top of the spreadsheet).


Select the Microsoft Excel spreadsheet you want to import into Works.


Click this to close this dialog box and import the selected spreadsheet.


Click this to close this dialog box without importing a spreadsheet.


Click this to insert a row above the cell or row that is currently selected. To insert several rows at one time, select the same number of rows as you want to insert, and then choose the Insert Row command on the Insert menu.


Click this to insert a column to the left of the cell or column that is currently selected. To insert several columns at one time, select the same number of columns as you want to insert, and then choose the Insert Column command on the Insert menu.


Click this to delete the selected column or column containing the selected cell.


Click this to delete the selected row or the row containing the selected cell.


Select the font you want to use for the selected text.


Select a font style to use for the selected text. Click Regular to remove bold or italic formatting.


Select the font size you want. The sizes in the Size list depend on the selected font.


Select the color you want for the selected text. Although you can display colors on your screen, you must have a color printer to print the information in color. Unless you change the text color in the Windows Control Panel, clicking Automatic sets the text color to black.


Click the text effect you want to apply to the selected text. Select the first option to draw a line under the selected text.


Select this to draw a line through the selected text.


Click this to use the current font choices for all new spreadsheets.


Type or select the text that you want to appear in the upper-left corner of the spreadsheet.


Type or select the text that you want to appear in the top, center of the spreadsheet.


Type or select the text that you want to appear in the upper-right corner of the spreadsheet.


Select this so that no header prints on the first page of your spreadsheet. Useful for documents with a cover page. Clear this to print a header on the first page.


Type or select the text that you want to appear in the lower-left corner of the spreadsheet.


Type or select the text that you want to appear in the bottom, center of the spreadsheet.


Type or select the text that you want to appear in the lower-right corner of the spreadsheet.


Select this so that no footer prints on the first page of your spreadsheet. Useful for documents with a cover page. Clear this to print a footer on the first page.


Type the distance you want between the top of the page and the top of the first line of the page.


Type the distance you want between the top of the last line of the page and the bottom of the page.


Type the distance you want between the left edge of the page and the left edge of a line.


Type the distance you want between the right edge of the page and the right end of a line.


Type the distance you want from the top edge of the paper to the top edge of the header.


Type the distance you want from the bottom edge of the footer to the bottom edge of the paper.


Click this to reset the settings on all tabs (Margins; Source, Size & Orientation; Other Options) to the original setting.


Shows how your document looks with the selected options.


Select this to print the document so that the short edge of the paper is the top of the page.


Select this to print the document so that the long edge of the paper is the top of the page.


Select the printer tray you want. Works lists the options available on your current printer.


Select a paper size supported by your printer. Click Custom to enter the paper’s dimensions in the Width and Height boxes.


Displays the width of the paper type you clicked in the Size box. If you clicked Custom in the Size box, type the width of your paper here.


Displays the height of the paper type you clicked in the Size box. If you clicked Custom in the Size box, type the height of your paper here.


Type a name of up to 15 characters for the range of cells you want to name or select a name from the Select a name box.


Click the name you want to change, or click the name and then click Delete to remove the range name.


Click this to insert a list that shows all of the range names you created for this spreadsheet. The list appears starting in the active cell in the spreadsheet. Useful when you are creating new formulas or need a reminder of the exact range names you have assigned. When you insert a list of range names, you overwrite any data in the cells where the new list appears.


Click this to delete the name currently highlighted in the Select a name box


Click this to  return to the Easy Calc dialog.


Lists categories of toolbar button types. To display the buttons in a category, click the category you want.


Displays the available toolbar buttons for the category chosen in the Categories box. To add a button to the Works toolbar, click it and drag it out of the dialog box and directly onto the toolbar.


Displays a brief description of the toolbar button that is highlighted in the Toolbar Buttons box.


Specifies that Works will display the toolbar button name as the mouse pointer moves over a toolbar button. Click this to accept or clear this option.


Specifies that Works removes the Font and Font Size boxes from the toolbar. Useful when you need extra room on the toolbar for more buttons. Click this to accept or clear this option.


Click this to restore the toolbar buttons that were on the toolbar the first time you used Works.


Lists the units of measure Works can use for page size and margins, and, in the Word Processor, ruler measurements, label size, tab stops, and paragraph indents. Click the unit of measure you want to use.


Specifies that you can use the mouse to drag a selection to a new location within the same document or between documents. If you are moving the selection a short distance, this is often more convenient than the Cut, Copy, or Paste commands. Click this to accept or clear this option.


Specifies that Works will use the printer’s envelope feeder when you print envelopes. Click this to accept or clear this option. (This option is not available unless the active printer has an envelope feeder.)


Specifies how Works documents are sent when using electronic mail. Click Text to send a Works document as text within a mail message; click Document to send a Works document as a file attached to a mail message.


Specifies that Works automatically replaces existing characters one at a time as you type new text in the Word Processor. Otherwise, Works makes room for new characters you type by moving existing characters to the right. Click this to accept or clear this option.


Specifies that when you type in the Word Processor, Works uses “smart” curled opening and closing quotation marks instead of straight quotation marks. Click this to accept or clear this option.


Specifies that Works will automatically delete highlighted text when you begin typing new text in the Word Processor. Click this to accept or clear this option.


Specifies that as you drag the mouse pointer in the Word Processor, Works automatically highlights entire words at a time. Clear this if you want to highlight words letter by letter in the Word Processor.


Specifies that Works will wrap text to fit in the available window space in the Word Processor, regardless of the right-margin setting. With this option turned on, your document may look different on-screen than it does when you print it. Choose the Print Preview command (File menu) to see how your document will look when you print.


This is where you type the number of decimals you want to display by default in the Database. You can override the number in your documents if necessary.


Click this to edit database entries both directly in the field and in the entry bar at the top of the document window.


Click this to edit database entries in the entry bar at the top of the document window, but not directly in the field.


Click this to edit database entries directly in the field. When you click this option, Works does not display the entry bar at the top of the document window.


Specifies that Works will display cells that have zero values as blank cells. Click this to accept or clear this option. This setting applies to the active spreadsheet only.


Specifies that Works will calculate formulas only when you specifically request it, not automatically as usual. This setting applies to the active spreadsheet only.


Specifies that the first time the length of the characters in a cell is wider than the cell, Works will display a dialog box that explains how to remedy the situation. Click this box to clear or accept this option.


Specifies that the insertion point will move to the cell below the current cell when you press the enter key. For example, if you are typing in cell A1 and press enter, the insertion point will move to cell A2. Click this to clear or accept this option.


Displays the database selected to be the default address book. To change the default address book, click a database in the list box below.


Lists existing databases you may want to use as an address book. Click the scroll arrows to move up or down in the list, and then click the database you want.


Click this to open a database that does not appear in the list box above.


Click this to run the Address Book TaskWizard, which will help you create a customized address book.


Specifies that Works will display the status bar along the bottom of the Works window. The status bar provides information about the active document or the selected command. Click this to accept or clear this option.


Specifies that Works displays names under the pointer as you work. Click this to accept or clear this option.


Click this to display the TaskWizards tab each time you start Works. The TaskWizards tab lists a wide range of documents designed to help you perform common tasks.

This option only applies to when you first start Works. If you click New on the File menu during the Works session, Works will display the tab you were on last.


Click this to display the Existing Documents tab each time you start Works. The Existing Documents tab lists recently used documents that you can open in Works.

This option only applies to when you first start Works. If you click New on the File menu during the Works session, Works will display the tab you were on last.


Click this to display the Works Tools tab each time you start Works. The Works Tools tab lets you open any of the Works tools [image] the word processor, spreadsheet, database, or communications tool [image] immediately.

This option only applies to when you first start Works. If you click New on the File menu during the Works session, Works will display the tab you were on last.


Click this to display the Task Launcher tab that was last displayed in the previous session each time you start Works.

This option only applies to when you first start Works. If you click New on the File menu during the Works session, Works will display the tab you were on last.


Specifies that fonts on the toolbar will appear the way they will look in your document. Useful when you want to see how a font looks before you apply it. Click this to accept or clear this option.


Specifies that Works will display Help automatically when you start Works. Click this to accept or clear this option. You can also click the question mark button at the bottom right of your screen to display or hide Help while you work.


Specifies that Works will open specific documents every time you start Works. Click this to accept or clear this option.


Click this to save the current open documents in a workspace. When you start Works again, all of these documents will be automatically opened so you can work on them right away.


Specifies that Works will always display the Works Tasks Launcher confirmation dialog box when you start a TaskWizard. Click this to accept or clear this option.


Specifies that Works will display information to help you complete a task the first time you choose a new command in the Works session. Click this to accept or clear this option.


Lists the available dictionaries you can use when you check spelling in Works documents. Click the arrow to display the list of available dictionaries, and then click the one you want.


Lists the available thesaurus files you can use when you check for synonyms and antonyms in Works documents. Click the arrow to display the list of available thesaurus files, and then click the one you want.


This is where you type the information that you want at the top of every page of your document. Works centers the header text unless you type a code for a different alignment. You can also type codes to insert information like the time, date, or filename of your document in the header. Check online Help for the complete list of formatting and field codes you can use.


This is where you type the information that you want at the bottom of every page of your document. Works centers the footer text unless you type a code for a different alignment. You can also type codes to insert information like the time, date, or filename of your document in the footer. Check online Help for the complete list of formatting and field codes you can use.


Specifies that no header will print on the first page of your document. Useful for documents with a cover page. Click this to accept or clear this option.


Specifies that no footer will print on the first page of your document. Useful for documents with a cover page. Click this to accept or clear this option.


Click this to close this dialog box without saving any changes you have made.


Click this to close this dialog box and save any changes you have made.


No Help topic is associated with this area. Click [image] at the top of the dialog box, and then click directly on a setting or button.


Click this to display a new tab in the dialog box. Each tab contains options that affect different aspects of a document, graphic, or chart.


Click this to display a new tab in the dialog box.


Click this to find the characters you want to search for. To find the next occurrence, press SHIFT+F4.


This is where you type a page number, cell reference (for example, A1), record number, or field name.


Lists the bookmarks or other items in your document. Click the scroll arrows to move up or down in the list, and then click the item name you want.


Click this to go to the page number, cell, record number, or field name you specified in the Go To text box.


Click this to cancel the task and close the dialog box.


This is where you type the characters you want to replace. You can include any letter, number, punctuation mark, or wildcard character. A wildcard character is a character (? or *) that stands for one or more characters in a search criteria. An asterisk (*) represents any number of characters. A question mark represents any single character in the same position as the question mark. For example, type anders?n to find Anderson and Andersen.


Determines the direction of the search. Click this to specify that Works searches from left to right across rows or records.


Determines the direction of the search. Click this to specify that Works searches from top to bottom down columns or fields.


This is where you type or insert the information you want to use as replacement text. If you used the Copy command to copy the characters from another location, you can use the CTRL+V keyboard shortcut to paste the information here. To delete the text in the Find What box from your database, leave this box empty.


Click this to find and highlight the next occurrence of the information you have specified in the Find What box.


Click this to change the information highlighted in your document to the information you have specified in the Replace With box, and then find the next occurrence.


Click this to find and replace all occurrences of the information in the Replace With box.


This is where you type a name of up to 15 characters, including blank spaces and punctuation, for the bookmark or the range of cells. A bookmark is an invisible marker you can use to mark and return to any location in your document. A range is a group of adjacent spreadsheet cells. To return to this bookmark or range later, choose Go To from the Edit menu.


Lists the bookmarks or ranges you have already named. If necessary, click the scroll arrows to see all the names.


Deletes the name currently highlighted in the Select A Name box. For bookmarks, clicking Delete removes the selected bookmark from the document. For range names, clicking Delete removes the name from the list.


Inserts a list that shows all of the range names and references you have created for this spreadsheet at the location of the active cell. Useful for when you are creating new formulas or need a reminder of the exact range names you have assigned. When you insert a list of range names, you will overwrite any data in the active cell.


Click this to insert or delete rows in your spreadsheet or report. To insert several rows at one time, highlight the same number of rows as you want to insert, and then choose the Insert Row command on the Insert menu.

If you want to empty the contents of the row without removing the row, use the Clear command on the Edit menu instead.


Click this to insert or delete columns in your spreadsheet or report. To insert several columns at one time, highlight the same number of columns as you want to insert, and then choose the Insert Column command on the Insert menu.

If you want to empty the contents of the column without removing the column, use the Clear command on the Edit menu instead.


Click this to align text to the left and numbers to the right within a database field. Until you specify another alignment, all fields are formatted this way.


Click this to align text and numbers to the left within a database field.


Click this to align text and numbers to the right within a database field. Useful when you want to line up decimals in list view.


Click this to center text and numbers horizontally within a database field.


Specifies that the height of a cell or field automatically changes so text wraps within the field. Click this to accept or clear this option.


Click this to align text and numbers with the top of a database field in List view. Useful when you have assigned a field height taller than a single line.


Click this to center text and numbers vertically within a database field in List view. Useful when you have assigned a field height taller than a single line.


Click this to align text and numbers with the bottom of a database field in List view. Useful when you have assigned a cell or field height taller than a single line.


Click this to center text and numbers across a group of highlighted cells. Useful when you want to display a title across the top of a spreadsheet.


Click this to add a box around the highlighted cells or fields. You can easily see the borders if you turn off the gridlines; choose Gridlines from the View menu.


Click this to add a border along the top of the highlighted cells or fields. You can easily see the borders if you turn off the gridlines; choose Gridlines from the View menu.


Click this to add a border along the bottom of the highlighted cells or fields. You can easily see the borders if you turn off the gridlines; choose Gridlines from the View menu.


Click this to add a border along the left side of the highlighted cells or fields. You can easily see the borders if you turn off the gridlines; choose Gridlines from the View menu.


Click this to add a border along the right side of the highlighted cells or fields. You can easily see the borders if you turn off the gridlines; choose Gridlines from the View menu.


Click this to remove all borders from the highlighted cells or fields. You can easily see that the borders are turned off if you also turn off the gridlines; choose Gridlines from the View menu.


Click this to choose this border style.


Lists the available colors you can apply to borders. Click the scroll arrows to move up or down in the list, and then click the color you want. Although you can display colors on your screen, you must have a color printer to print the information in color.


Lists the available shading patterns you can apply to the highlighted area of your Database form, or to selected objects. Click None to remove any existing shading for the selected fields. Click the scroll arrows to move up or down in the list, and then click the shading pattern you want.


Lists the available colors you can apply to the dots and lines of the shading pattern. The Auto option applies the same color used for text on your screen (usually black). Click the scroll arrows to move up or down in the list, and then click the foreground color you want.


Lists the available colors you can apply for the background of the shading pattern. The Auto option applies the same color used for the background of windows on your screen (usually white). Click the scroll arrows to move up or down in the list, and then click the background color you want.


Shows how the shading pattern will look with the colors and patterns you have chosen.


Lists the available fonts, based on the printer your computer is connected to. Click the scroll arrows to move up or down in the list, and then click the name of the font you want.


Lists the available font sizes, based on the printer your computer is connected to. Type the font size you want, or click the scroll arrows to move up or down in the list, and then click the font size you want.


Specifies that text is displayed as bold or plain. Click this to accept or clear this option. You can combine this style with any of the others in the Style box.


Specifies that text is displayed as italic or plain. Click this to accept or clear this option. You can combine this style with any of the others in the Style box.


Specifies that text is displayed as underlined or plain. Click this to accept or clear this option. You can combine this style with any of the others in the Style box.


Specifies that text is displayed as strikethrough or plain. Click this to accept or clear this option. You can combine this style with any of the others in the Style box.


Lists the available colors you can apply to text and numbers. Click the arrow to the right of the Color box, and then click the color you want. Click the scroll arrows to display a list of available colors. Although you can display colors on your screen, you must have a color printer to print the information in color.


Shows how text and numbers will look with the fonts, font styles, and colors you have chosen.


Click this to set the current font selections you have made as the ones Works uses by default for all word processor documents and charts.


Click this to position the highlighted characters normally on the line with other text.


Click this to position the highlighted characters above the line and other text. Footnote markers, for example, are displayed in superscript position.


Click this to position the highlighted characters below the line of other text.


Click this to display the text and numbers for labels or titles in the Y-axis horizontally, from top to bottom. The Y-axis is the vertical axis at the left side of your chart.


Click this to display the text and numbers for labels or titles in the Y-axis rotated sideways, starting from the top and moving down. The Y-axis is the vertical axis at the left side of your chart.


Click this to display the text and numbers for labels or titles in the Y-axis (the vertical axis at the left side of your chart) rotated sideways, starting from the bottom and moving up.


Lists the reports associated with the current database. Click the report you want to delete, and then click the Delete button.


Click this to restore any charts or reports you have deleted while the dialog box was open. Works will close the dialog box and restore any charts or reports you deleted.


Lists the reports associated with the current database. Click the report you want to make a copy of, type a name for the copy in the Type A Name Below box, and then click the Duplicate button.


This is where you type a name of up to 15 characters for the copy of the chart or report.


Click this to delete any copies of charts or reports you have made while this dialog box was open. Works will close the dialog box, and delete any copies of charts or reports you have specified.


Lists the reports associated with the current database. Click the scroll arrows to move up or down in the list, and then click the report you want to rename. Type a new name in the Type A Name Below box, and then click the Rename button.


This is where you type a new name of up to 15 characters for the selected chart or report. Works automatically gives charts and reports a name (such as Chart 1 or Report 1). Renaming a chart or report can make it easier to identify on the View menu.


This is where you type the number of copies of the current document you want to print.


Click this to print the entire document.


Click this to specify that you only want to print specific sequential pages of the document. You must type the starting page in the From box and the ending page in the To box.


This is where you type the page number of the first page you want to print.


This is where you type the page number of the last page you want to print.


Lists the available printers you can use. Click the arrow to display a list of printers, and then click the one you want.


Specifies that when you are printing more than one copy, Works will print all the pages of the first copy, then it will print all the pages of the second copy, and so on.


Shows how pages will print when copies are collated (Works prints a copy of the entire document, and then another copy of the entire document, and so on) or when pages are grouped together (Works prints all copies of page 1, then all copies of page 2, and so on).


Click this to print only the Word Processor document itself, and not any associated mailing labels or envelopes.


Click this to print only the envelopes or labels associated with the Word Processor document, and not the document itself.


Specifies that Works will print multiple copies of the same Word Processor document, inserting different information from an associated database, such as a name and address, in each copy. This option is automatically checked if your document contains placeholders; clear this option to print one copy of the document with the placeholder included.


Specifies that Works does not print font styles (bold, italic, or underline), or color, or charts, drawings, or other objects, and uses the printer’s default font. Most documents with numerous fonts and graphics will print faster in draft quality. Click this to accept or clear this option.


Click this to print a form for each record in the current database, not just the record currently displayed on the screen.


Click this to print only the form for the record currently displayed on your screen.


Click this to display a preview of how your document will look when it prints.


Click this to print one envelope or twoa rows of mailing labels as a test. Useful to see if you need to adjust the label-dimension settings in Works, or make adjustments to the position of the envelopes or labels in your printer.


Click this to choose a different printer or to specify print options.


Click this to specify settings [image] such as resolution, paper size, paper source, and paper orientation [image] for your printer. The settings you select become the default settings for the printer during the Works session. TIf the document settings in the Page Setup dialog box will automatically change to match the changes you make in the Properties dialog box.differ from the properties settings, the settings in the Page Setup dialog box will take precedence.  Also, changes you make in the Page Setup dialog box will be automatically reflected in the Properties dialog box.


Lists the different paper and envelope sizes you can select. Click the scroll arrows to see the sizes available, and then click the one that you want.


Click this to connect to a network drive.


Click this to apply portrait orientation to your document. With portrait orientation, the height is greater than the width.


Click this to apply landscape orientation to your document. With landscape orientation, the width is greater than the height.


Shows the direction the information will be printed on the page. With portrait orientation, your document’s height is greater than its width. With landscape orientation, your document’s width is greater than its height.


Lists the available paper sources for your printer. Click the scroll arrow to display a list of paper sources, and then click the one you want. Different printer models support different paper sources, such as upper tray, lower tray, or envelope manual feed.


Click this to see additional options specific to your printer.


Lists the available object types that you can insert into your Word Processor document or Database form; for example, a Microsoft Excel chart, a Microsoft Paintbrush picture, or spreadsheet information from Works. Click the scroll arrows to move up or down in the list, and then click the type of object you want to insert.


Click this to create a new object to insert into your Word Processor document or Database form.


Click this to insert an existing file into your Word Processor document or a Database form.


Specifies that Works will display the information as an icon rather than display the information itself. This can be useful when you want easy access to information from another file, but do not want to include the information in your Works document. Click this to display and choose from a range of available icons.


Describes the type of object selected in the Object Type list box or the action performed by a selected option.


Click this to scan your folders (or directories) to locate the file you want to insert.


Click this to display and choose from a range of available icons.


Click Current to accept the currently selected icon, which is displayed next to this option.

Click Default to accept the default icon, which is displayed next to this option.

Click From File to display and choose from a range of available icons. Click the scroll arrows to move through the icon display, and then click the icon you want.


This is where you name the icon you want to insert in your Word Processor document or Database form.


Shows the icon you have chosen.


Shows the name of the document that contains the information you copied. It may also show the specific section of the document that you copied.


Click this to embed the copied information into your document. Changes you make to the embedded information will not appear in the original document, and changes made to the original document will not appear in this document.


Click this to link copied information to your document. Changes you make to the linked information will appear in the original document, and changes in the original document will also appear in this document.


Lists the different formats in which you can paste information into your document. This option is not available for all types of documents.


Shows how your selection will look with the options you have chosen.


Lists the information already linked to the document. Select the information for which you want to change the link.


Click this to automatically update the linked information when it changes in its source document.


Click this if you want to update the linked information only when prompted.


Click this to update the highlighted linked information.


Click this to change the source document that the information is linked to.


Click this to return to your document without changing the link.


This is where you type a measurement for the distance between the top of the page and the top of the first line on the page, or you can click the scroll arrows to display a new measurement. You can change the unit of measurement by typing in or " for inches, pi for picas, cm for centimeters, or mm for millimeters after the measurement.


This is where you type a measurement for the distance between the bottom of the page and the bottom of the last line on the page, or you can click the scroll arrows to display a new measurement. You can change the unit of measurement by typing in or " for inches, pi for picas, cm for centimeters, or mm for millimeters after the measurement.


This is where you type a measurement for the distance between the left edge of the page and the beginning of each line with no indent, or you can click the scroll arrows to display a new measurement. You can change the unit of measurement by typing in or " for inches, pi for picas, cm for centimeters, or mm for millimeters.


This is where you type a measurement for the distance between the right edge of the page and the right end of each line with no indent, or you can click the scroll arrows to display a new measurement. You can change the unit of measurement by typing in or " for inches, pi for picas, cm for centimeters, or mm for millimeters.


This is where you type a measurement for the distance between the top of the page and the top of the header. Type the measurement you want; it must be smaller than or equal to the Top Margin measurement. You can also click the scroll arrows to display a new measurement.


This is where you type a measurement for the distance between the bottom of the page and the top of the footer. Type the measurement you want; it must be smaller than or equal to the Bottom Margin measurement. You can also click the scroll arrows to display a new measurement.


Click this to restore the default page settings.


Lists the different sources for paper at your printer (your printer may have only one). Click the arrow to display a list of available sources, and then click the one you want.


Lists the paper measurements available. Click the arrow to display a list of available paper sizes, and then click the one you want. The measurements in the Width and Height boxes change to reflect the paper size option you choose. If you choose the Custom paper size option here, you must type the custom measurements in the Width and Height boxes.


The measurement in this box changes to reflect the width of the current paper size and orientation options. If you have specified a custom paper size, type the width here, or click the scroll arrows to display a new measurement.


The measurement in this box changes to reflect the height of the current paper size and orientation options. If you have specified a custom paper size, type the height here, or click the scroll arrows to display a new measurement.


Shows the direction the information will be printed on the page. With portrait orientation, your document’s height is greater than its width. With landscape orientation, your document’s width is greater than its height.


Click this to apply portrait orientation to your document. With portrait orientation, the height is greater than the width.


Click this to apply landscape orientation to your document. With landscape orientation, the width is greater than the height.


Shows how your document will look with the options you have specified.


This is where you type the number you want to assign to the first page of your document. You can also click the scroll arrows to display a new number.


Click this to reduce the chart to the size of your computer screen, approximately one-quarter page.


Click this to print the chart within the page margins, while retaining its width-to-height ratio.


Click this to expand the chart to fill the page when you print. Works will adjust its width-to-height ratio as needed to fit the page size.


Specifies that no header will print on the first page of your document. Useful for documents with a cover page. Click this to accept or clear this option.


Specifies that no footer will print on the first page of your document. Useful for documents with a cover page. Click this to accept or clear this option.


Specifies that all footnotes will be printed at the end of the document. Otherwise, footnotes are printed at the bottom of the page on which they appear. Click this to clear or accept this option.


Specifies that Works will print the horizontal and vertical cell gridlines on the database form.


Specifies that Works will print the row numbers (the numbers down the side of the spreadsheet) and column letters (the letters across the top of the spreadsheet).


Specifies that Works will print horizontal lines under each field in Form view or Form Design view.


Specifies that Works will print one record per page. Clear this check box to print more than one record per page.


This is where you type a measurement for spacing between records when printing several records on one page.  You can also click the scroll arrows to display a new measurement. This option is unavailable unless you clear the Page Breaks Between Records check box.


Specifies that Works will print labels for the records and fields in your database.


Click this to print only field entries and not labels or field names.


Click this to print all items on the form, including field names, field entries, and labels.


Specifies that Works will print only introductory and summary rows and not each record in the report.


Click this to open the text file as a Works Word Processor document.


Click this to open the text file as a Works spreadsheet.


Click this to open the text file as a Works database.


Click this if the text file you are opening was created and saved in an MS-DOS-based application.


Click this if the text file you are opening was created and saved in a Microsoft Windows-based application.


Click this to close this dialog box without opening a document.


Click this to close this dialog box and open the selected document.


Click this to open a new Word Processor document.


Click this to open a new Spreadsheet.


Click this to open a new Database.


Click this to use the Communications tool.


Click this to close all open Works documents and close Works.


Lists a wide range of documents designed to help you perform common tasks. Click the scroll arrows to move up or down in the list, click the kind of document you want, and then click the OK button. You can click the List Categories In Different Order button to rearrange the list.


Provides a description of the selected document.


Click this to arrange the task list differently. For example, you can arrange it alphabetically or have the most recently used documents appear at the top of the list.


Click this to arrange the task list by category.


Click this to arrange the task list alphabetically.


Click this to arrange the task list so that the most recently used tasks appear at the top of the list.


Click this to arrange the task list by document type.


Specifies that Works will include template documents in the task list.


Specifies that Works will include TaskWizards in the task list. When this check box is cleared, Works does not display the TaskWizards in the task list. Click this to clear or accept this option.


Lists recently used documents that you can open in Works. To view the path, or location, of a document, click the filename. The path and filename appear below the list box.


Shows the path and filename of the selected document.


Click this to open or locate a document that is not listed above.


Click this to locate an existing document.


Click this to close this dialog box without opening a TaskWizard.


Click this to go directly to the selected wizard so that you can start creating a new document now.


Click this to expand this dialog box and display a list of documents created by the selected wizard. To hide the list, click the button again.


Specifies that Works will always display this dialog box when you select a TaskWizard. Click this to clear this option. To turn the option back on, click Options on the Tools menu, click the View tab, and then click the Confirm TaskWizards check box.


Lists the most recent documents created by the selected wizard. Click the scroll arrows to move up or down in the list, and then click the document you want. If the document you want does not appear in the list, click the Open A Document Not Listed Here button.


Click this to open a document that is not listed above.


Click this to open the selected document.


Specifies that Works will make a second, backup copy when you save the document. The backup copy will preserve the last version of the document; the current copy will always contain the latest changes you make. Click this to clear or accept this option.


Click this to display the Save As Template dialog box, where you can save the active document as a custom template. A template contains all the settings, text, and formats you want to use later when you create new documents.


Click this to display information about your system.


Click this to close this Help window when you are finished reading the information.


This is where you type a word or words that describe the action you want to perform or the item you want to work with. For example, to learn how to add a field, you could type “adding fields,” “adding columns,” or “fields.”  If you do not see the index entry you want, try typing a different word in the text box.


Lists the index entries for Works. Click the scroll arrows to move up or down in the list, and then click the entry you want, or click a folder to see more topics.


Click this to close this Help window when you are finished.


Lists the Help topics by subject matter. Click the scroll arrows to move up or down in the list, and then click the topic you want.

A folder icon next to a topic indicates a main heading that contains individual Help topics or additional folders. Click a folder icon to list more detailed folders or individual topics. Click a document icon to display a Help topic.


Click this to display the Help topics, by subject matter, for the Word Processor tool.


Click this to display the Help topics, by subject matter, for the Spreadsheet tool.


Click this to display the Help topics, by subject matter, for the Database tool.


Click this to display the Help topics, by subject matter, for the Communications tool.


Displays any word not found in the main dictionary or custom dictionaries that are open.


Click this to ignore the suggested spelling and leave the highlighted word in your document unchanged.


Click this to ignore the suggested spelling and leave the highlighted word in your document unchanged.


Click this to replace the highlighted word with the spelling displayed in the Change To box.


Click this to add the highlighted word to your custom dictionary so that, in subsequent spelling checks, Works will not identify it as a misspelled word.


Click this to leave all instances of the same word in your document unchanged. When you click this button, Works will not highlight any other instances of this word during the spelling check.


Click this to replace all instances of the highlighted word with the spelling displayed in the Change To box. When you click this, Works will make the changes automatically and will not highlight any other instances of this word during the spelling check.


Click this to display a list of proposed spellings in the Suggestions box. Click the Always Suggest check box to always display a list of suggestions.


Click this to add words to or delete words from the custom dictionary.


Specifies that a list of proposed spellings is always automatically displayed in the Suggestions box. Click this to accept or clear this option.


Specifies that words with all capital letters are ignored during the spelling check. Click this to accept or clear this option.


Click this to end the spelling check and close this dialog box. Changes you have already made will be saved.


Click this to ignore any words that contain numbers during the spell check.


This is where you type the correct spelling for the highlighted word in your document. Click the Change button to accept the correct spelling, or click Ignore to ignore it and leave the word as it is. Click the Suggest button to see one or more words that are similar in spelling. If you have chosen one of the Suggest options, a proposed new spelling for the word may already be displayed here.


Lists the proposed correct spellings for the highlighted word in your document. When there are several proposed spellings, click the scroll arrows to move up or down in the list, and then click the one you want.


This is where you type a new word that you want to add to the custom dictionary.


Lists the words in the custom dictionary. Click the scroll arrows to move up or down in the list, and then click the word you want.


Click this to add the word you typed in the Word text box to the custom dictionary.


Click this to delete the selected word from the custom dictionary.


Click this when you are finished adding a word to or deleting a word from the custom dictionary.


Click to display and print the End User Licensing Agreement.


Click to view international warranty information for Microsoft Works.


Click to launch Online Registration Wizard.


Display information about system configuration, printers, system DLLs, fonts, proofing tools, graphics filters, text converters, display configuration, audio capabilities, applications that are running, active modules, and OLE settings for your computer.


Displays technical support information.


Click this to close this dialog box.


Click this to display either the generic series labels, or the text or cell references you have specified below as legend text. A legend is the explanatory list of the colors, markers, or symbols used in a chart.


Click this to show the legend as area labels in the chart.


Click this to use values in your spreadsheet as series labels in the chart.


Type the text you want as the label for the first value (Y) series in your chart. Or, if the text you want to use has already been entered in your spreadsheet, type the reference of the cell that contains the label text for the series.


Type the text you want as the label for the second value (Y) series in your chart. Or, if the text you want to use has already been entered in your spreadsheet, type the reference of the cell that contains the label text for the series.


Type the text you want as the label for the third value (Y) series in your chart. Or, if the text you want to use has already been entered in your spreadsheet, type the reference of the cell that contains the label text for the series.


Type the text you want as the label for the fourth value (Y) series in your chart. Or, if the text you want to use has already been entered in your spreadsheet, type the reference of the cell that contains the label text for the series.


Type the text you want as the label for the fifth value (Y) series in your chart. Or, if the text you want to use has already been entered in your spreadsheet, type the reference of the cell that contains the label text for the series.


Type the text you want as the label for the sixth value (Y) series in your chart. Or, if the text you want to use has already been entered in your spreadsheet, type the reference of the cell that contains the label text for the series.


Click this to assign generic labels [image] Series 1, Series 2, and so on [image] to the value (Y) series in your chart.


Type a title of up to 39 characters for the current chart. Works centers the title at the top of the chart and prints it with the chart. You can type the actual text you want here, or type the cell reference that contains the title you want.


Type a subtitle of up to 39 characters for the current chart. Works centers the subtitle just below the title at the top of the chart, and prints it with the chart. You can type the actual text you want here, or type the cell reference that contains the subtitle you want.


Type a title of up to 39 characters for the horizontal (X) axis for the current chart. Works displays the horizontal axis title below the chart and above the legend, and prints it with the chart. You can type the actual text you want here, or type the cell reference that contains the horizontal axis title you want.


Type a title of up to 39 characters for the vertical (Y) axis for the current chart. Works displays the vertical axis title along the left side of the chart, and prints it with the chart. You can type the actual text you want here, or type the cell reference that contains the vertical axis title you want.


Type a title of up to 39 characters for the right vertical axis for the current chart. Works displays the right vertical axis title along the right side of the chart, and prints it along with the chart. You can type the actual text you want here, or type the cell reference that contains the right vertical axis title you want.


Select this to show the actual numeric value of each bar or data point for each value series (a set of numeric values represented by bars, lines, or points in a chart). Clear the box to remove the numeric values.


Select the type of label to use for each slice in the pie chart.


Select the type of label to use for each slice in the pie chart. This value appears in parentheses to the right of the first label.


Shows how the labels will look on your chart.


Click this to highlight the cells for the first series of lines, bars, points, or labels in the corresponding spreadsheet. (The range reference is displayed here in parentheses.)


Click this to highlight the cells for the second series of lines, bars, points, or labels in the corresponding spreadsheet. (The range reference is displayed here in parentheses.)


Click this to highlight the cells for the third series of lines, bars, points, or labels in the corresponding spreadsheet. (The range reference is displayed here in parentheses.)


Click this to highlight the cells for the fourth series of lines, bars, points, or labels in the corresponding spreadsheet. (The range reference is displayed here in parentheses.)


Click this to highlight the cells for the fifth series of lines, bars, points, or labels in the corresponding spreadsheet. (The range reference is displayed here in parentheses.)


Click this to highlight the cells for the sixth series of lines, bars, points, or labels in the corresponding spreadsheet. (The range reference is displayed here in parentheses.)


Click this to highlight the cells for the category series or labels in the corresponding spreadsheet. (The range reference for the category (X) series is displayed here in parentheses.)


Click this to show the spreadsheet with the series you specified highlighted.


Type a new cell name, range reference, or range name to add or change the data that appears in the first value (Y) series in the chart. To delete the first series completely from the chart, clear this box.


Type a new cell name, range reference, or range name to add or change the data that appears in the second value (Y) series in the chart. To delete the second series completely from the chart, clear this box.


Type a new cell name, range reference, or range name to add or change the data that appears in the third value (Y) series in the chart. To delete the third series completely from the chart, clear this box.


Type a new cell name, range reference, or range name to add or change the data that appears in the fourth value (Y) series in the chart. To delete the fourth series completely from the chart, clear this box.


Type a new cell name, range reference, or range name to add or change the data that appears in the fifth value (Y) series in the chart. To delete the fifth series completely from the chart, clear this box.


Type a new cell name, range reference, or range name to add or change the data that appears in the sixth value (Y) series in the chart. To delete the sixth series completely from the chart, clear this box.


Type a cell name, range reference, or range name to change the category (X) series in the chart. To delete the category (X) series completely from the chart, clear this box.


Click the 1st, 2nd, 3rd,… box where you want to insert the range reference for a group of cells that you copied from the spreadsheet before choosing the Series command, and then click this button to insert the reference.


Select this to specify that no horizontal axis should appear on the current chart. Clear this to show a horizontal axis.


Select this to add vertical gridlines at each point on the horizontal axis. The lines extend from top to bottom and can make the chart data easier  to read. Clear this to hide the gridlines.


Select this to show droplines for the active Area or 3-D Area chart (available only for these chart types). Droplines are straight lines that extend from a data point to the horizontal (X) axis to show where one marker ends and the next begins. Clear this to hide the droplines.


Click this to plot data using a logarithmic scale. Useful when there is a large range of data values or when you need to show a logarithmic relationship. Clear this to use a regular numeric scale.


Type the interval for labels you want Works to display as category labels along the horizontal axis. Useful when lengthy category labels overlap. For example, type 2 to display every other category label.


Click this to position the category labels next to the horizontal (X) axis.


Click this to position the category labels at the bottom of the chart. This works only if you have negative numbers in your chart.


Type the lowest value you want to show on the horizontal axis. If you want Works to automatically set the lowest value for you, type auto.


Type the highest value you want to show on the horizontal axis. If you want Works to automatically set the highest value for you, type auto.


Type the increment by which the values progress along the horizontal axis. For example, type 5 to display the values 5, 10, 15, 20, 25,.... If you want Works to automatically set the increment, type auto.


Type the lowest value you want shown on the vertical axis. If you want Works to automatically set the lowest value for you, type auto.


Type the highest value you want shown on the vertical axis. If you want Works to automatically set the highest value for you, type auto.


Type the increment by which the values progress along the vertical axis. For example, type 5 to display the values 5, 10, 15, 20, 25,.... If you want Works to automatically set the increment, type auto.


Select this to add horizontal gridlines at each point on the vertical axis. The lines extend from left to right and can make the chart easier to read. Clear this to hide the gridlines.


Select this to add horizontal gridlines at each point on the vertical axis. The lines extend from right to left and can make the chart easier to read. Clear this to hide the gridlines.


Click this to plot data using a logarithmic scale. Useful when there is a large range of data values or when you need to show a logarithmic relationship. Clear this to use a regular numeric scale.


Select this to specify that no vertical axis should appear on the current chart. Clear this to show a vertical axis. If you have added a right vertical axis, click this to remove both vertical axes. Clear this to show the vertical axes.


Click this to adjust the vertical axis for a normal chart type, not one of the specific types listed below.


Click this to adjust the vertical axis to show values as they are charted for a stacked line chart. Stacked line charts show values stacked on top of each other to produce a cumulative total.


Click this to adjust the vertical axis to show values in relation to a 100% scale.


Click this to adjust the vertical axis to show values as they are charted for a hi-lo chart. A hi-lo chart is a variation of a line chart that shows the relationship between minimum and maximum values in each category.


Click this to adjust the vertical axis to show values for a chart using 3-D rows. This is available only for 3-D chart types; 3-D area, 3-D line and 3-D bar.


Click this to position tick labels next to the vertical (Y) axis. This is available only for scatter charts with one vertical axis and negative values.


Click this to position tick labels on the left side of the chart. . This is available only for scatter charts with one vertical axis and negative values.


Click this to display the first value series along the left vertical axis in a chart that has two vertical axes. When one value is on the left vertical axis, a value in another series should be on the right vertical axis. You can also have more than one set of values on the left and right axes. Useful when you want to compare two different values in a single chart, such as the price of one stock and the combined average of the stock market over the same period of months. The stock you want to track could be on the left vertical axis, the market on the right vertical axis; the horizontal (X) axis would be the time you want to show.


Click this to display the first value series along the right vertical axis in a chart with two vertical axes. When one value is on the right vertical axis, a value in another series should be on the left vertical axis. You can also have more than one set of values on the right and left axes. Useful when you want to compare two different values in a single chart, such as horsepower and torque over the same range of Rpms. The horsepower measurements could be on the right vertical axis, the torque measurements on the left vertical axis; the horizontal (X) axis would be the various Rpms you want to show.


Click this to display the second value series along the left vertical axis in a chart with two vertical axes. When one value is on the left vertical axis, a value in another series should be on the right vertical axis. You can also have more than one set of values on the left and right axes. Useful when you want to compare two different values in a single chart, such as the price of one stock and the combined average of the stock market over the same period of months. The stock you want to track could be on the left vertical axis, the market on the right vertical axis; the horizontal (X) axis would be the time you want to show.


Click this to display the second value series along the right vertical axis in a chart with two vertical axes. When one value is on the right vertical axis, a value in another series should be on the left vertical axis. You can also have more than one set of values on the right and left axes. Useful when you want to compare two different values in a single chart, such as horsepower and torque over the same range of Rpms. The horsepower measurements could be on the right vertical axis, the torque measurements on the left vertical axis; the horizontal (X) axis would be the various Rpms you want to show.


Click this to display the third value series along the left vertical axis in a chart with two vertical axes. When one value is on the left vertical axis, a value in another series should be on the right vertical axis. You can also have more than one set of values on the left and right axes. Useful when you want to compare two different values in a single chart, such as the price of one stock and the combined average of the stock market over the same period of months. The stock you want to track could be on the left vertical axis, the market on the right vertical axis; the horizontal (X) axis would be the time you want to show.


Click this to display the third value series along the right vertical axis in a chart with two vertical axes. When one value is on the right vertical axis, a value in another series should be on the left vertical axis. You can also have more than one set of values on the right and left axes. Useful when you want to compare two different values in a single chart, such as horsepower and torque over the same range of Rpms. The horsepower measurements could be on the right vertical axis, the torque measurements on the left vertical axis; the horizontal (X) axis would be the various Rpms you want to show.


Click this to display the fourth value series along the left vertical axis in a chart with two vertical axes. When one value is on the left vertical axis, a value in another series should be on the right vertical axis. You can also have more than one set of values on the left and right axes. Useful when you want to compare two different values in a single chart, such as the price of one stock and the combined average of the stock market over the same period of months. The stock you want to track could be on the left vertical axis, the market on the right vertical axis; the horizontal (X) axis would be the time you want to show.


Click this to display the fourth value series along the right vertical axis in a chart with two vertical axes. When one value is on the right vertical axis, a value in another series should be on the left vertical axis. You can also have more than one set of values on the right and left axes. Useful when you want to compare two different values in a single chart, such as horsepower and torque over the same range of Rpms. The horsepower measurements could be on the right vertical axis, the torque measurements on the left vertical axis; the horizontal (X) axis would be the various Rpms you want to show.


Click this to display the fifth value series along the left vertical axis in a chart with two vertical axes. When one value is on the left vertical axis, a value in another series should be on the right vertical axis. You can also have more than one set of values on the left and right axes. Useful when you want to compare two different values in a single chart, such as the price of one stock and the combined average of the stock market over the same period of months. The stock you want to track could be on the left vertical axis, the market on the right vertical axis; the horizontal (X) axis would be the time you want to show.


Click this to display the fifth value series along the right vertical axis in a chart with two vertical axes. When one value is on the right vertical axis, a value in another series should be on the left vertical axis. You can also have more than one set of values on the right and left axes. Useful when you want to compare two different values in a single chart, such as horsepower and torque over the same range of Rpms. The horsepower measurements could be on the right vertical axis, the torque measurements on the left vertical axis; the horizontal (X) axis would be the various Rpms you want to show.


Click this to display the sixth value series along the left vertical axis in a chart with two vertical axes. When one value is on the left vertical axis, a value in another series should be on the right vertical axis. You can also have more than one set of values on the left and right axes. Useful when you want to compare two different values in a single chart, such as the price of one stock and the combined average of the stock market over the same period of months. The stock you want to track could be on the left vertical axis, the market on the right vertical axis; the horizontal (X) axis would be the time you want to show.


Click this to display the sixth value series along the right vertical axis in a chart with two vertical axes. When one value is on the right vertical axis, a value in another series should be on the left vertical axis. You can also have more than one set of values on the right and left axes. Useful when you want to compare two different values in a single chart, such as horsepower and torque over the same range of Rpms. The horsepower measurements could be on the right vertical axis, the torque measurements on the left vertical axis; the horizontal (X) axis would be the various Rpms you want to show.


Select the number that corresponds to the pie slice or series whose color or pattern you want to change. If you are not sure which number corresponds to which slice or series, close the dialog box, and then double-click the slice or bar you want to change. Works reopens this dialog box with the correct number selected.


Select the color you want to apply to the pie slice or series you selected. Or click Automatic to let Works determine the color for you. If you do not have a color printer, Works will replace the colors with a different shade or pattern for each pie slice or series when you print.


Select the pattern you want to apply to the pie slice or series you selected. Or click Automatic to let Works determine the pattern for you.


Select the line style you want to apply to the series you selected. Or click Auto to let Works determine the line style for you.


Select the marker you want for the line chart, or line and bar chart you selected. Or click None to hide the markers.


Select this to show the current pie slice separated, or “exploded,” from the rest of the pie chart for emphasis. Clear this to show all pie slices within the pie.


Click this to apply the changes you specified for the series or slice you selected.


Click this to apply the changes you specified for all pie slices or series in your chart, not just the slice or series you selected.


Click this to close the dialog box.

Before you close the dialog box, you must click the Format or Format All button to have Works save any changes you made.


Select whether to display a line or a bar for the first value series in the line and bar chart. When one value series is a line, another should be a bar. Useful when you want to illustrate where two different sets of data overlap, or to superimpose one set on another set.


Select whether to display a line or a bar for the second value series in the line and bar chart. When one value series is a bar, another should be a line. Useful when you want to illustrate where two different sets of data overlap, or to superimpose one set on another set.


Select whether to display a line or a bar for the third value series in the line and bar chart. When one value series is a line, another should be a bar. Useful when you want to illustrate where two different sets of data overlap, or to superimpose one set on another set.


Select whether to display a line or a bar for the fourth value series in the line and bar chart. When one value series is a bar, another should be a line. Useful when you want to illustrate where two different sets of data overlap, or to superimpose one set on another set.


Select whether to display a line or a bar for the fifth value series in the line and bar chart. When one value series is a line, another should be a bar. Useful when you want to illustrate where two different sets of data overlap, or to superimpose one set on another set.


Select whether to display a line or a bar for the sixth value series in the line and bar chart. When one value series is a bar, another should be a line. Useful when you want to illustrate where two different sets of data overlap, or to superimpose one set on another set.


Select the name of the font you want to appear in the chart title, label, or legend.


Select the font size you want for the chart title, label, or legend.


Select the font style you want for the chart title, label, or legend.


Click this to display the chart title, label, or legend with the text underlined. You can combine this style with any of the others in the Font style box. Clear this to display text without an underline.


Click this to display the chart title, label, or legend with the text crossed out with a strikethrough. You can combine this style with any of the others in the Font style box. Clear this to display the text without a strikethrough.


Select the color you want for the chart title, label, or legend. Although you can display colors on your screen, you must have a color printer to print the information in color.


Select how you want to display a vertical axis title. A vertical axis can appear on the left and right side of a chart. You can choose Vertical from bottom, where the text appears on its side and goes from the bottom up, Vertical from top, where the text appears on its side and goes from the top down, and Horizontal from top, where the text appears upright and goes from the top down.


Click the type of chart you want to create or modify. A preview of how your chart will look appears on the right.


Type a title of up to 39 characters for the current chart. Works centers the title at the top of the chart and prints it with the chart. You can type the actual text you want here, or type the cell reference that contains the title you want.


Click this to show a border around the chart. Clear this to hide the border.


Select this to add vertical and horizontal gridlines at each point on the horizontal and vertical axes. The lines extend from top to bottom, and left to right, and can make it easier to read the chart. Clear this to hide the gridlines.


Shows how your data will look with the chart type and options you selected.


Click the type of chart you want to create or modify. The variations you can select from are based on the type of chart you selected on the Basic Types tab. A preview of how your chart will look appears on the right.


Click this if the values you want to chart are in a sequence of cells from left to right.


Click this if the values you want to chart are in a sequence of cells from top to bottom.


Select this if the first selected column contains information that describes the charted values, and you want to use this information as the legend.


Select this if the first selected row contains information that you want to appear on the horizontal (X) axis as a label.


Select this if the first selected column contains information that you want to appear on the horizontal (X) axis as a label.


Select this if the first selected row contains information that describes the charted values, and you want to use this information as the legend.


Select this if the first selected column contains information that describes the charted values, and you want to use this information as the legend.


Select this if the first selected row contains information that you want to appear on the axes as labels.


Select this if the first selected column contains information that you want to appear on the axes as labels.


Select this if the first selected row contains information that describes the charted values,  and you want to use this information as the legend.


Select this if the first selected row contains data, and you want to include the data in the pie chart.


Select this if the first selected row contains text that you want to appear as the category label for the pie chart.


Select this if the first selected column contains information that you want to appear as the category label for the pie chart.


Select this if the first selected column contains data, and you want to include the data in the pie chart.


Select the chart you want to make a copy of. The charts you can select from are based on the current spreadsheet.


Type a name of up to 15 characters you want to use for the new copy of the chart.


Click this to duplicate the selected chart.


Click this to delete any copies of charts you made while this dialog box was open. Works closes the dialog box and then deletes the copies of the charts you created.


Click this to close the dialog box and keep the new duplicated charts you created.


Select the chart you want to rename.


Type a new name of up to 15 characters for the chart you want to rename. Renaming a chart can make it easier to identify.


Click this to apply the new name you typed to the chart.


Click this to cancel any chart renaming you did while this dialog box was open. Works closes the dialog box and restores the original names to any charts you renamed.


Click this to close this dialog box, save any changes you made, and open the selected chart.


Click the chart you want to delete. The charts you can select from are based on the current spreadsheet.


Click this to delete the selected chart. Works removes the chart from the list.


Click this to restore any charts you deleted while the dialog box was open. Works closes the dialog box and restores any charts you deleted.


Click this to delete any charts and close the dialog box.


Click the chart that you want to look at.


Click this to close this dialog box and open the selected chart.


Click this to close this dialog box without viewing the selected chart.


Lists the fields in the database associated with this report. Click the field whose entries you want to summarize. The summary will appear in the highlighted cell of a Summary row. You need to repeat this process for each field you want to summarize.


Click this to total all the values in the field you highlighted in the Select A Field list box. Works will insert a SUM function in the highlighted cell of the Summary row, and will display the result when you preview or print the report.


Click this to average all the values in the field you highlighted in the Select A Field list box. Works will insert an AVG function in the highlighted cell of the Summary row, and will display the result when you preview or print the report.


Click this to count the number of entries in the field you highlighted in the Select A Field list box. Works will insert a COUNT function in the highlighted cell of the Summary row, and will display the result when you preview or print the report.


Click this to find and display the largest value in the field you highlighted in the Select A Field list box. Works will insert a MAX function in the highlighted cell of the Summary row, and will display the result when you preview or print the report.


Click this to find and display the smallest value in the field you highlighted in the Select A Field list box. Works will insert a MIN function in the highlighted cell of the Summary row, and will display the result when you preview or print the report.


Click this to calculate the standard deviation of the values in the field you highlighted in the Select A Field list box. Works will insert an STD function in the highlighted cell of the Summary row, and will display the result when you preview or print the report.


Click this to calculate the variance of the values in the field you highlighted in the Select A Field list box. Works will insert a VAR function in the highlighted cell of the Summary row, and will display the result when you preview or print the report.


Click this to close the dialog box and insert the field summary formula inat the current highlighted cell of a Summary row.


Click Title to print an introductory row at the beginning of a report.

Click Headings to print a row at the top of each page.

Click Intr fieldname to designate a blank row or a group heading before each sort break.

Click Record to print a row for each record in the database.

Click Summ fieldname to print a row after every sort break you specify.

Click Summary to print a row at the end of a report.

After you insert a row, you can leave it blank or insert a field name, field entry, or field summary to show more data in your report.

Note: The row types available depend on the way data is sorted and grouped in your report.


Click this to close the dialog box and insert the row type you selected.


Lists the available field names or field entry formulas for your report. Click the scroll arrows to move up or down in the list, and then click the field name or field entry formula you want to insert in the highlighted cell of your report.


Click this to close the dialog box and insert the field name or field entry formula in your report at the current highlighted cell.


Click this to see how the selected report will look when printed.


Click this to change the report specifications of the selected report.


Lists the existing database reports or spreadsheet charts. Click the scroll arrows to move up or down in the list, and then click the report or chart you want.


Displays your document at four times its normal size on the screen. This does not affect the way the document prints.


Displays your document at twice its normal size on the screen. This does not affect the way the document prints.


Displays your document at its normal size on the screen.


Displays your document at approximately three-fourths of its normal size. This does affect the way the document prints.


Displays your document at half its normal size. This does not affect the way the document prints.


Type a number to enlarge or shrink the display of your document. For most documents, use a number between 25 and 1000. This option does not affect the way the document prints.


Displays your document at a size you determine.


This is where you type a number to enlarge or shrink the display of your document. For most documents, use a number between 25 and 1000; for database forms, use a number between 33 and 63, depending on the screen resolution. This option does not affect the way the document prints.


Click the category of clip art you would like to view.


Click a sub-category to refine the search for clip art.


Click the type of clip art you want. Selecting a media type refines the search of the clip art files.


Click this to close this dialog box.


Click this to insert the selected clip art.


Enter a keyword to refine a search for clip art. Click to view the 10 previous keywords.


Click the type of clip art you want. Selecting a media type refines the search of the clip art files.


Click to search the Clip Gallery using the keywords or media type you chose.


Lists the keywords associated with a clip. Click the arrows to scroll through the list.


Click to see a larger picture of the clip.


Specifies that Works will assign generic labels [image] Series 1, Series 2, and so on [image] to the value (y) series in your chart. Click this to accept or clear this option.


This is where you type the text you want as the label for the first value (y) series in your chart. Or, if the text you want to use has already been entered in your spreadsheet, type the cell that contains the label text for the series.


This is where you type the text you want as the label for the second value (y) series in your chart. Or if the text you want to use has already been entered in your spreadsheet, type the cell that contains the label text for the series.


This is where you type the text you want as the label for the third value (y) series in your chart. Or if the text you want to use has already been entered in your spreadsheet, type the cell that contains the label text for the series.


This is where you type the text you want as the label for the fourth value (y) series in your chart. Or, if the text you want to use has already been entered in your spreadsheet, type the cell that contains the label text for the series.


This is where you type the text you want as the label for the fifth value (y) series in your chart. Or if the text you want to use has already been entered in your spreadsheet, type the cell that contains the label text for the series.


This is where you type the text you want as the label for the sixth value (y) series in your chart. Or, if the text you want to use has already been entered in your spreadsheet, type the cell that contains the label text for the series.


Click this to display either the Auto Series labels or the text or cell references you have specified above as legend text. A legend is the explanatory list of the colors, markers, or symbols used in chart.


Click this to display either the Auto Series labels or the text or cell references you have specified above as series labels. Series labels are labels that are displayed on the area chart itself.


Click this when you do not want to use a value series as a legend or an area label on the chart.


This is where you type a title of up to 39 characters for the current chart. Works will center the title at the top of the chart, and print it along with the chart. You can type the actual text you want here, or type the cell reference that contains the title you want.


This is where you type a subtitle of up to 39 characters for the current chart. Works will center the subtitle just below the title at the top of the chart, and print it along with the chart. You can type the actual text you want here, or type the cell reference that contains the subtitle you want.


This is where you type a label of up to 39 characters for the horizontal (x) axis for the current chart. Works will display the horizontal axis label below the chart and above the legend, and print it along with the chart. You can type the actual text you want here, or type the cell reference that contains the horizontal axis label you want.


This is where you type a label of up to 39 characters for the vertical (y) axis for the current chart. Works will display the vertical axis label along the left side of the chart, and print it along with the chart. You can type the actual text you want here, or type the cell reference that contains the vertical axis label you want.


This is where you type a label of up to 39 characters for the right vertical axis for the current chart. Works will display the right vertical axis label along the right side of the chart, and print it along with the chart. You can type the actual text you want here, or type the cell reference that contains the right vertical axis label you want.


Specifies that each data point (or bar) of each value series (a set of numeric values in a spreadsheet represented by bars, lines, or points in a chart) is labeled with its actual numeric value. Click this to accept or clear this option.


This is where you type the range reference for the group of cells in the spreadsheet that contains the information you want to use to label the first value (y) series. For example, type A1:F1.


This is where you type the range reference for the group of cells in the spreadsheet that contains the information you want to use to label the second value (y) series. For example, type A2:F2.


This is where you type the range reference for the group of cells in the spreadsheet that contains the information you want to use to label the third value (y) series. For example, type A3:F3.


This is where you type the range reference for the group of cells in the spreadsheet that contains the information you want to use to label the fourth value (y) series. For example, type A4:F4.


This is where you type the range reference for the group of cells in the spreadsheet that contains the information you want to use to label the fifth value (y) series. For example, type A5:F5.


This is where you type the range reference for the group of cells in the spreadsheet that contains the information you want to use to label the sixth value (y) series. For example, type A6:F6.


Click this to insert a range reference for a group of cells from your spreadsheet. Useful when you have added a new range of cells and you want to include them as labels for a chart that already exists. Copy the range of cells from the spreadsheet, click the Value Series box you want, and then click the Paste button.


Click this to label each slice in the pie chart with the actual numeric value from the spreadsheet that it was plotted from.


Click this to label each slice in the pie chart with the percentage of the total that it represents.


Click this to label each slice in the pie chart with the contents of the range reference you type in the Cell Range box below. Works will label the first pie slice with the contents of the first cell in the range, the second with the second cell in the range, and so on.


Click this to label each slice in the pie chart with a sequential number that corresponds to its value’s position in the spreadsheet; the first slice of the pie is labeled 1, the second 2, and so on.


Click this to remove any labels from the current pie chart.


This is where you type the range reference for the group of cells that contains the information you want to use to label the slices of the pie chart. Used with the Cell Contents option above.


Click this button when the insertion point is in the Cell Range box to insert a range reference that was copied from the spreadsheet.


Shows how the labels will look on your chart.


Click this to add a second label to the pie chart that shows the actual numeric value each slice was plotted from. The second label will display in parentheses to the right of the first label. Useful when you want to label each slice with both its percentage of the total and its numeric value.


Click this to add a second label that shows the percentage of the total that each slice represents. The second label will display in parentheses to the right of the first label. Useful when you want to label each slice with both its numeric value and its percentage of the total it represents.


Click this to add a second label to each slice that shows the contents of the range you typed the reference for in the Cell Range box below. The second label will display in parentheses to the right of the first label. Works will label the first pie slice with the contents of the first cell in the range, the second with the second cell in the range, and so on.


Click this to add a second label to each slice that shows a sequential number corresponding to its value’s position in the spreadsheet. The second label will display in parentheses to the right of the first label.


Click this to remove any second labels (enclosed in parentheses) from the current pie chart.


For the Go To command, click this to switch to the spreadsheet and highlight the cells for the first series of lines, bars, points, or labels in a chart. (The range reference is displayed here in parentheses.)

For the Paste Series command, click this to specify that the first series gets the copied information.


For the Go To command, click this to switch to the spreadsheet and highlight the cells for the second series of lines, bars, points, or labels in a chart. (The range reference is displayed here in parentheses.)

For the Paste Series command, click this to specify that the second series gets the copied information.


For the Go To command, click this to switch to the spreadsheet and highlight the cells for the third series of lines, bars, points, or labels in a chart. (The range reference is displayed here in parentheses.)

For the Paste Series command, click this to specify that the third series gets the copied information.


For the Go To command, click this to switch to the spreadsheet and highlight the cells for the fourth series of lines, bars, points, or labels in a chart. (The range reference is displayed here in parentheses.)

For the Paste Series command, click this to specify that the fourth series gets the copied information.


For the Go To command, click this to switch to the spreadsheet and highlight the cells for the fifth series of lines, bars, points, or labels in a chart. (The range reference is displayed here in parentheses.)

For the Paste Series command, click this to specify that the fifth series gets the copied information.


For the Go To command, click this to switch to the spreadsheet and highlight the cells for the sixth series of lines, bars, points, or labels in a chart. (The range reference is displayed here in parentheses.)

For the Paste Series command, click this to specify that the sixth series gets the copied information.


For the Go To command, click this to switch to the spreadsheet and highlight the cells for the category series or labels. (The range reference for the category (x) series is displayed here in parentheses.)

For the Paste Series command, click this to specify that the category series gets the copied information.


For the Go To command, click this to specify that Works switches to the spreadsheet and highlights the cells used to chart the series, not to the cells that contain the labels that describe the series.

For the Paste Series command, click this to create a series from a copied range.


For the Go To command, click this to specify that Works switches to the spreadsheet and highlights the cells that describe the series, not to the cells that contain the data used to chart the series.

For the Paste Series command, click this to create labels from the range information.


For the Go To command, click this to go to the series you specified.

For the Paste Series command, click this to copy the information into the specified series.


Click this to cancel the task and close the dialog box.


This is where Works displays the references for the cells that are currently charted. To change the first value series, type the cell reference, range reference, or range name here. To delete the first series completely from the chart, clear this box.


This is where Works displays the references for the cells that are currently charted. To change the second value series, type the cell reference, range reference, or range name here. To delete the second series completely from the chart, clear this box.


This is where Works displays the references for the cells that are currently charted. To change the third value series, type the cell reference, range reference, or range name here. To delete the third series completely from the chart, clear this box.


This is where Works displays the references for the cells that are currently charted. To change the fourth value series, type the cell reference, range reference, or range name here. To delete the fourth series completely from the chart, clear this box.


This is where Works displays the references for the cells that are currently charted. To change the fifth value series, type the cell reference, range reference, or range name here. To delete the fifth series completely from the chart, clear this box.


This is where Works displays the references for the cells that are currently charted. To change the sixth value series, type the cell reference, range reference, or range name here. To delete the sixth series completely from the chart, clear this box.


This is where Works displays the references for the cells that are currently charted. To change the category (x) series, type the cell reference, range reference, or range name here. To delete the category (x) series completely from the chart, clear this box.


Inserts the range reference for a group of cells you copied from the spreadsheet before choosing the Series command. Click the box where you want to insert the reference, and then click this button.


Specifies that you want to add vertical gridlines at each point on the horizontal axis. The lines extend from top to bottom, and can make it easier to read the chart data. Click this to accept or clear this option.


Specifies that droplines are shown for the active Area or 3-D Area chart (available only for these chart types). Click this to accept or clear this option. Droplines are straight lines that extend from a data point to the horizontal (x) axis to show where one marker ends and the next begins.


Specifies that no horizontal axis appears on the current chart. Click this to accept or clear this option.


This is where you type the number of labels you want Works to skip as it displays category labels along the horizontal axis. Useful when lengthy category labels overlap. For example, type 2 to display every other category label.


Click this to position category labels next to the horizontal (x) axis.


Click this to position category labels at the bottom of the chart.


This is where you type the lowest value you want to show on the horizontal axis. If you want Works to automatically set the lowest value for you, type auto.


This is where you type the highest value you want to show on the horizontal axis. If you want Works to automatically set the highest value for you, type auto.


This is where you type the increment by which values progress along the horizontal axis. For example, type 5 to display the values 5, 10, 15, 20, 25,.... If you want Works to automatically set the increment, type auto.


Specifies that data is plotted using a logarithmic scale. Click this to accept or clear this option. Useful when there is a large range of data values or when you need to show a logarithmic relationship.


This is where you type the lowest value you want shown on the vertical axis. If you want Works to automatically set the lowest value for you, type auto.


This is where you type the highest value you want shown on the vertical axis. If you want Works to automatically set the highest value for you, type auto.


This is where you type the increment by which the values progress along the vertical axis. For example, type 5 to display the values 5, 10, 15, 20, 25,.... If you want Works to automatically set the increment, type auto.


Specifies that you want to add horizontal gridlines at each point on the vertical axis. The lines extend from left to right, and can make it easier to read the chart data. Click this to accept or clear this option.


Specifies that data is plotted using a logarithmic scale. Click this to accept or clear this option. Useful when there is a large range of data values or when you need to show a logarithmic relationship.


Specifies that no vertical axis appears on the current chart. Click this to accept or clear this option. If you have added a right vertical axis, this will remove both vertical axes.


Click this to adjust the vertical axis for a Normal chart type, not one of the specific ones listed below.


Click this to adjust the vertical axis to show values as they are charted for a stacked line chart. Stacked line charts show values stacked on top of each other to produce a cumulative total.


Click this to adjust the vertical axis to show values in relation to a 100% scale.


Click this to adjust the vertical axis to show values as they are charted for a Hi-Lo chart. A Hi-Lo chart is a variation of a line chart that shows the relationship between minimum and maximum values in each category.


Click this to adjust the vertical axis to show values as they are charted for a chart with 3-D rows.


Click this to position tick labels next to the vertical (y) axis.


Click this to position tick labels at the left of the chart.


Click this to display the first value series along the left vertical axis in a chart with two vertical axes. When one value is on the left vertical axis, another value should be on the right vertical axis. You can also have more than one set of values on the left and right axes. Useful when you want to compare two different values along a shared axis, like the price of one stock and the combined average of the stock market over the same period of months. The stock you want to track could be on the left vertical axis, the market on the right vertical axis; the horizontal x-axis would be the time you want to show.


Click this to display the first value series along the right vertical axis in a chart with two vertical axes. When one value is on the right vertical axis, another value should be on the left vertical axis. You can also have more than one set of values on the right and left axes. Useful when you want to compare two different values along a shared axis, like horsepower and torque over the same range of Rpm’s. The horsepower measurements could be on the right vertical axis, the torque measurements on the left vertical axis; the horizontal x-axis would be the various Rpm’s you want to show.


Click this to display the second value series along the left vertical axis in a chart with two vertical axes. See the context Help for 1st Value Series for an explanation of when to use more than one vertical series.


Click this to display the second value series along the right vertical axis in a chart with two vertical axes. See the context Help for 1st Value Series for an explanation of when to use more than one vertical series.


Click this to display the third value series along the left vertical axis in a chart with two vertical axes. See the context Help for 1st Value Series for an explanation of when to use more than one vertical series.


Click this to display the third value series along the right vertical axis in a chart with two vertical axes. See the context Help for 1st Value Series for an explanation of when to use more than one vertical series.


Click this to display the fourth value series along the left vertical axis in a chart with two vertical axes. See the context Help for 1st Value Series for an explanation of when to use more than one vertical series.


Click this to display the fourth value series along the right vertical axis in a chart with two vertical axes. See the context Help for 1st Value Series for an explanation of when to use more than one vertical series.


Click this to display the fifth value series along the left vertical axis in a chart with two vertical axes. See the context Help for 1st Value Series for an explanation of when to use more than one vertical series.


Click this to display the fifth value series along the right vertical axis in a chart with two vertical axes. See the context Help for 1st Value Series for an explanation of when to use more than one vertical series.


Click this to display the sixth value series along the left vertical axis in a chart with two vertical axes. See the context Help for 1st Value Series for an explanation of when to use more than one vertical series.


Click this to display the sixth value series along the right vertical axis in a chart with two vertical axes. See the context Help for 1st Value Series for an explanation of when to use more than one vertical series.


Lists all the slices or bars in the currently active pie chart or 1-series bar chart. Click the number that corresponds to the slice or bar whose color or pattern you want to change. Click the scroll arrows to see the entire list. If you are not sure which slice or bar in your chart is number 1, number 2, and so on, close the dialog box, and then double-click the slice or bar you want to change. Works reopens this dialog box with the correct slice or bar selected.


Lists the colors you can apply to a pie slice or bar. Click the scroll arrows to see the entire list, and then click the color you want. Or click Auto to let Works determine the color for you. If you do not have a color printer, Works will replace the colors with a different shade or pattern for each pie slice or bar when you print.


Lists the patterns you can apply to a pie slice or bar. Click the scroll arrows to see the entire list, and then click the pattern you want. Or click Auto to let Works determine the pattern for you.


Specifies that the current pie slice is separated or “exploded” from the rest of the pie chart for emphasis. Click this to accept or clear this option.


Click this to apply the changes you have specified to the pie slice or bar whose number you clicked in the Slices or Bars box.


Click this to apply the changes you have specified to all the pie slices or bars in your chart, not just the slice or bar whose number you clicked in the Slices or Bars box.


Click this to close the dialog box.

Before you close the dialog, you must click the Format or Format All button to have Works save any changes you made.


Click the number that corresponds to the value series whose color or pattern you want to change. A value series is a group of related values, such as all the values in a single row or column in the spreadsheet selection you used to create the chart.


Lists the available colors for charts. Click the scroll arrows to see the entire list, and then click the color you want for the bars, lines, or markers. Or click Auto to let Works determine the color for you. If you do not have a color printer, Works will replace the colors with shades or patterns of gray when you print.


Lists the available patterns for charts. Click the scroll arrows to see the entire list, and then click the pattern you want for the bars or lines. Or click Auto to let Works determine the pattern for you.


List the available markers for the series you want to change in a line chart or a mixed line and bar chart. Click the scroll arrows to see the entire list, and then click the marker you want. Or click Auto to let Works determine the marker for you.


Click this button to apply changes to the value series you chose without closing the dialog box. A value series is a group of related values, such as all the values in a single row or column in the spreadsheet selection you used to create the chart.


Click this to apply changes to all the value series in the chart without closing the dialog box. A value series is a group of related values, such as all the values in a single row or column in the spreadsheet selection you used to create the chart.


Click this to close the dialog box.

Before you close the dialog box, you must click the Format or Format All button to have Works save any changes you made.


Click this to display the first value series as a line in a mixed line-and-bar chart. When one value series is a line, another should be a bar. Useful when you want to illustrate where two different sets of data overlap, or to superimpose one set on another set.


Click this to display the first value series as a bar in a mixed line-and-bar chart. When one value series is a bar, another should be a line. Useful when you want to illustrate where two different sets of data overlap, or to superimpose one set on another set.


Click this to display the second value series as a line in a mixed line-and-bar chart. When one value series is a line, another should be a bar. Useful when you want to illustrate where two different sets of data overlap, or to superimpose one set on another set.


Click this to display the second value series as a bar in a mixed line-and-bar chart. When one value series is a bar, another should be a line. Useful when you want to illustrate where two different sets of data overlap, or to superimpose one set on another set.


Click this to display the third value series as a line in a mixed line-and-bar chart. When one value series is a line, another should be a bar. Useful when you want to illustrate where two different sets of data overlap, or to superimpose one set on another set.


Click this to display the third value series as a bar in a mixed line-and-bar chart. When one value series is a bar, another should be a line. Useful when you want to illustrate where two different sets of data overlap, or to superimpose one set on another set.


Click this to display the fourth value series as a line in a mixed line-and-bar chart. When one value series is a line, another should be a bar. Useful when you want to illustrate where two different sets of data overlap, or to superimpose one set on another set.


Click this to display the fourth value series as a bar in a mixed line-and-bar chart. When one value series is a bar, another should be a line. Useful when you want to illustrate where two different sets of data overlap, or to superimpose one set on another set.


Click this to display the fifth value series as a line in a mixed line-and-bar chart. When one value series is a line, another should be a bar. Useful when you want to illustrate where two different sets of data overlap, or to superimpose one set on another set.


Click this to display the fifth value series as a bar in a mixed line-and-bar chart. When one value series is a bar, another should be a line. Useful when you want to illustrate where two different sets of data overlap, or to superimpose one set on another set.


Click this to display the sixth value series as a line in a mixed line-and-bar chart. When one value series is a line, another should be a bar. Useful when you want to illustrate where two different sets of data overlap, or to superimpose one set on another set.


Click this to display the sixth value series as a bar in a mixed line-and-bar chart. When one value series is a bar, another should be a line. Useful when you want to illustrate where two different sets of data overlap, or to superimpose one set on another set.


Shows the available chart types. Click the picture representing the type of chart you want.


Shows how your data will look with the chart type you selected.


Shows variations of the chart type you selected on the Basic Types tab. Click the picture representing the type of chart you want.


Click this to make values in the series appear in decreasing order from left to right.


Click this if the values you want to chart are in a sequence of cells from top to bottom.


Shows the available chart types. Click the picture representing the type of chart you want.


This is where you type a name for the chart.


Shows the chart type you selected.


Specifies that Works will place a border around the chart. Click this to clear or accept this option.


Specifies that Works will display gridlines in the chart. Click this to clear or accept this option.


Shows how your data will look with the chart type you selected.


Click this if the first highlighted row or column contains information that describes the charted values.


Click this if the first row or column contains charted values.


Click this to increase or decrease the number series you are creating based on the number in the Step By box.


Click this to fill the blank cells in a selection with a series based on the information at the beginning of the selection. For example, Quarter 1, Quarter 2, Quarter 3, Quarter 4. You can use AutofFill with seasons, days of the week, and months of the year.


Click this to fill the blank cells in a selection with a series of dates that increases by days, including Saturday and Sunday. For example, July 21, 1995, July 22, 1995, July 23, 1995, July 24, 1995, July 25, 1995, July 26, 1995.


Click this to fill the blank cells in a selection with a series of dates that increases by weekdays only, excluding Saturday and Sunday from the series. For example, July 21, 1995, July 24, 1995, July 25, 1995, July 26, 1995.


Click this to fill the blank cells in a selection with a series of dates that increases by months. For example, November 27, 1995, December 27, 1995, January 27, 1996, February 27, 1996.


Click this to fill the blank cells in a selection with a series of dates that increases by years. For example, April 15, 1995, April 15, 1996, April 15, 1997, April 15, 1998.


This is where you type the amount by which you want a series to increase or decrease. Type a positive number to make the series increase (1, 2, 3, 4); type a negative number to make the series decrease (4, 3, 2, 1).


Click this to paste the resulting value of a formula, but not the formula itself, into a new location. Useful when you are consolidating information from several spreadsheets into one.


Click this to add pasted values to any existing values already contained in the cell or range you are copying or moving to.


Click this to subtract pasted values from any existing values already contained in the cell or range you are copying or moving to.


Click this to have Works search left to right by rows for the characters you have specified.


Click this to have Works search top to bottom by columns for the characters you have specified.


Click this to have Works search through the formulas in your spreadsheet for the characters you have specified.


Click this to have Works search through the values that result from formulas rather than the formulas themselves as it looks for the characters you have specified.


Click this to stop your search and close this dialog box.


This is where you type the exact column width measurement you want for the highlighted column(s).


Click this to apply the standard column width to the highlighted column(s).


Click this to apply the column width necessary to accommodate the largest entry in the highlighted column(s). When more than one column is highlighted, Works applies an appropriate width to each column.


This is where you type the exact row height measurement you want for the highlighted row(s).


Click this to apply the standard row height to the highlighted row(s).


Click this to apply the row height necessary to accommodate the tallest entry in the row(s). When more than one row is highlighted, Works applies an appropriate row height to each row.


Specifies that the currently highlighted cell(s) are locked, which means that the cells are protected and neither the formatting of nor the information in the cell(s) can be changed. Click this to accept or clear this option. To lock cells, you must also click the Protect Data option below.


Specifies that protection is turned on for cells that are formatted as locked. Click this to accept or clear protection for the currently selected cells.


Click this to display the numbers in the selected cell(s) in General format. Numbers are displayed as precisely as possible and aligned to the right; text is aligned to the left.


Click this to display the numbers in the selected cell(s) rounded to the number of decimal places you specify in the Options box. For example, if you specify two decimal places, then 1234.567 displays as 1234.57.


Click this to display the numbers in the selected cell(s) with a currency sign and commas every three places. You can specify the number of decimal places you want to show, and you can also display (and print, if you have a color printer) negative numbers in red.


Click this to display the numbers in the selected cell(s) with a comma every three places. You can specify the number of decimal places you want to show, and you can also display (and print, if you have a color printer) negative numbers in red.


Click this to display the numbers in the selected cell(s) as percentages. For example, .0625 displays as 6.25%. You can specify the number of decimal places you want to show in the Options box.


Click this to display the numbers in the selected cell(s) in exponential (scientific) notation. For example, 1234567 displays as 1.23E+06. Use the Options box to specify the number of decimal places you want to show.


Click this to display the numbers in the selected cell(s) as numbers whose first digit is zero. If you do not apply this format to numbers that begin with zero, Works automatically suppresses the zeros. Useful for postal codes, invoices, social security numbers, credit card numbers, and so on. You can specify the number of leading zeros you want to display in the Options box. For example, 123 displays as 00123 if you specify 5 as the total number of digits.


Click this to display the numbers in the selected cell(s) as fractional values. Use the Options box to specify whether you want to round to or reduce the fraction.


Click this to display the values in the selected cell(s) as logical values. All cells whose value is 0 (zero) display FALSE, and all non-zero cells display TRUE.


Click this to display the numbers in the selected cell(s) in the date format you specify in the Options box.


Click this to display the numbers in the selected cell(s) in the time format you specify in the Options box.


Click this to display the values in the selected cell(s) as text, regardless of whether the cell contains numbers, text, or both. Useful for entering part numbers or postal codes that you want Works to treat as text.


This is where you type the number of decimal places you want to display. Works will display numbers rounded to the number of decimal places you specify.


Specifies that Works displays (and prints, if you have a color printer) negative numbers in red in selected cells formatted with the currency or comma number format. Click this to accept or clear this option.


This is where you type the total number of digits, including the zeros, you want to display in selected cells formatted with the leading zeros number format. For example, 521 displays as 000521 if you specify 6 as the total number of digits.


Lists the fractional denominators you can choose to display numbers in selected cells formatted with the Fraction number format. Click the scroll arrows to move up or down in the list, and then click the fractional denominator you want. Click All Fractions to convert numbers to their precise fractional value.


Specifies that Works will round the value in this cell or field to the fixed fractional denominator you specified and not reduce fractions. For example, in a cell or field formatted with this option, 6/8 will display as 6/8; otherwise, it is reduced to 3/4.


Shows how numbers or text will look in cells formatted with the formatting options you have specified.


Lists the available formats you can apply to the selected area in your spreadsheet. Click the scroll arrows to move up or down in the list, and then click the format you want.


Specifies that you want the last row of the selection formatted as a Totals row for easy identification. Otherwise, Works does not format the last row differently than the rest of the selection. The AutoFormat style does not compute the totals for you.


Shows an example of how your data will look in the format you have chosen.


Click this to display a list of all the functions. Click one of the other options to display a shorter list of related functions.


Click this to display a list of all financial functions. You can use financial functions to calculate loan payments or track an investment.


Click this to display a list of all date and time functions. You can use dates and times in formulas to calculate the days in a project or to determine the time between events.


Click this to display a list of all math and trigonometric functions.


Click this to display a list of all statistical functions. You can use statistical functions to count numbers in a column, find an average of numbers, find the standard deviation of numbers in a specified range, and so on.


Click this to display a list of all lookup and reference functions.


Click this to display a list of all text functions. You can use text functions to perform comparisons or to convert values.


Click this to display a list of all logical functions. Logical functions can give only one of two answers: the value 1 (TRUE) or the value 0 (FALSE).


Click this to display a list of all informational functions.


Lists all functions in the category you have clicked. To see an alphabetical list of all functions, click the All option.


Provides a brief description of the function highlighted in the Choose A Function list.


Click this to insert the selected function in your spreadsheet.


Lists the columns in the spreadsheet or table. To specify a different column as the basis for sorting, click the arrow to display a list of columns, and then click the column you want.


Lists additional columns in the spreadsheet or table. To sort by more than one column, click the arrow to display a list of columns, and then click the column you want.


Click this to list sorted cell or field entries in ascending order (from A to Z or 1 to 99, for example).


Click this to list sorted cell or field entries in descending order (from Z to A or 99 to 1, for example).


Click this to have Works ignore the first row while sorting. Use this option when your first row contains headings.


Click this to have Works sort all rows in the spreadsheet or table, including the first row.


Click this to sort by more than one column. Works can sort one, two, or three columns at a time.


Click this to close the dialog box and perform the sort.


Click this to total numbers. Works will display a dialog box asking you to highlight the cells or cell range that contain the values you want to total.


Click this to multiply numbers. Works will display a dialog box asking you to highlight the cells that contain the values you want to multiply.


Click this to subtract numbers. Works will display a dialog box asking you to highlight the cells that contain the values on which you want to perform the subtraction.


Click this to divide numbers. Works will display a dialog box asking you to highlight the cells that contain the values on which you want to perform the division.


Click this to average numbers. Works will display a dialog box asking you to highlight the cells or cell range that contain the values you want to average.


Click this to see a complete list of functions available in Works.


Shows the Works formula for the specified function applied to the cells you highlighted.


Click this to return to the previous dialog box.


The name of this button changes. When the button is Next, Works performs the next step in the calculation. When the button is Finish, Works closes the dialog box and completes the calculation.


This is where you enter the cell reference(s) for the value(s) you want to use in the calculation. If cell references are already displayed, you can accept the displayed references, or you can highlight other cells on the spreadsheet or type cell references in this text box.

When the text box name changes to Result At, enter the reference for the cell in which you want the result of the calculation to appear.


Click this to sort only the highlighted information in the spreadsheet. All other columns and rows will not be sorted.


Click this to sort all the information in the spreadsheet.


This is where you type the filename for the active document you want to save as a custom template. The filename can have capitalized letters and spaces.


Specifies that the active document will be the default template for the current tool. Click this to clear or accept this option.


Click this to set and clear default templates for the current tool or for all tools. When you set a default template, Works automatically loads the template whenever you start a new document using the tool.


Shows the current default template. If no template is used, this box displays None.


Click this to clear, or stop using, the default template for the current tool. It is important to clear the current template if you want to use a different template as your default template.


Click this to clear, or stop using, the default templates for all of the tools. It is important to clear the current templates if you want to use different templates as your default templates.


Click this to apply the new name you typed to the selected report.


Click this to delete the selected report. Works will remove the report from the list.