Double-click a workbook:window number in the list to display that workbook and window.


Name the custom chart type you want to add. The name can contain up to 31 characters and will appear in the Chart type box on the Custom Types tab.


Describe the custom chart type you want to add. The description can contain up to 250 characters and will appear under the Sample box on the Custom Types tab when you click the name of the custom chart in the Chart type box.


Locates an add-in program installed on your computer. By default, the Add-Ins available box lists add-ins installed only in the Library folder, or one of its subfolders, in the Microsoft Office\Office folder; or in the Profiles\your user name\Application Data\Microsoft\AddIns folder in your Windows folder. If an add-in that comes with Microsoft Excel is not on your computer, you can install it.


Select a check box to load an add-in and make its commands and features available in Microsoft Excel. To unload an add-in and free up memory, clear the check box. Unloading the add-in does not remove it from your computer.


Describes the add-in you selected in the Add-Ins available box.


Type a name up to 31 characters long for the selected worksheet. The length of the name determines the width of the corresponding tab at the bottom of the workbook window. The longer the name, the fewer tabs you can see at one time.


Enter a view name to add a new view of the active worksheet to the active workbook.


Click Print settings to save the currently selected print settings with the added view on the worksheet. Click Hidden rows, columns and filter settings to save these options with the added view.


Removes the cell contents, formats, and comments from selected cells.


Removes only the cell formats from selected cells; cell contents and comments are unchanged.


Removes only the formulas from selected cells; formatting, comments, and values are unchanged.


Click Options to include row or column names and to change the order in which names are applied.


Click the names you want to use in place of references in the Apply names box, which lists all names defined in a workbook that refer to a cell or range of cells.


Replaces references with names, regardless of the reference types of the names or references. If you clear this check box, Microsoft Excel replaces absolute references with absolute names, relative references with relative names, and mixed references with mixed names.


Uses the names of row and column ranges that refer to the cells if the exact names for the cells can't be found.


Replaces the reference with the row-oriented name without including the column name. Clear the check box if you want to include the column name.


Replaces the reference with the column-oriented name without including the row name. Clear the check box if you want to include the row name.


When a cell reference is replaced by both a row-oriented and a column-oriented range name, click Row column. Click Column row if you want the column name to appear first.


Clears any formatting options you have set.


Click Tech Support for information about obtaining technical support. Click System Info for information about your computer and the software that's currently running.


Sets the chart type selected in the list as the default chart type for creating new charts.


Select 3-D effect to apply a 3-D appearance to all data markers in a bubble chart. Clear this check box to remove the 3-D effect from bubble data markers.


Applies a 3-D shaded appearance to the selected 3-D surface chart.


Specify the types of changes you want to review.


Specify the types of changes you want to highlight.


Type a value between 5 and 200 in the Size of second plot box to specify the percent size of the second pie or bar plot in relation to the first pie in a pie of pie or bar of pie chart. For example, type 100 in the box to display the second pie or bar plot the same size as the first pie plot.


Select the Automatic text check box to link data in data labels directly from the worksheet. Use this option to relink data labels to their source data after the labels have been changed manually in the chart.


Describes the type, subtype, or variation of the chart selected in the Chart type box. If there are no subtypes displayed, the current chart may be a custom chart type.


Specify the items you want to protect on your worksheet or workbook. Type a password to prevent unauthorized users from removing protection. Using a password is optional.


Applies the default settings for the selected object.


Displays the axis, line, or border as it will look with the selected options applied.


Click an option under Arrange to arrange windows in a preset pattern shown below.


Arranges the windows of only the active workbook. To display and arrange different parts of the active workbook in multiple windows, click New Window on the Window menu, and then click Windows of the active workbook.


Enter the value, or the cell reference where the value is stored, that you want to use for your parameter query. The Collapse Dialog button at the right end of this box temporarily moves the dialog box so that you can enter the range by selecting cells on the worksheet. When you finish, you can click the button again to display the entire dialog box.


Select to use the value displayed in this dialog box as the parameter for your parameter query whenever you refresh the external data range. If you entered a value as the parameter, the query will always use the value in future refreshes; if you entered a cell reference as the parameter, the query will always use the value from the specified cell to refresh the external data range.


Select to automatically refresh the external data range when the cell value specified in the parameter box changes. This option is available only if you selected the Use this value/reference for future refreshes check box and entered a single cell reference in the parameter box.


Copies the selected toolbars in the Custom toolbars box to the active workbook.


Click the toolbar names in the Custom toolbars box to specify which toolbars you want to attach to the active workbook. This box lists all the custom toolbars in the current workspace.


Lists all the toolbars attached to the active workbook. When you click Copy to attach more toolbars, the additional toolbars are listed in this box.


Creates a custom list from existing items that you've listed on a worksheet. Click Rows if your items are listed across rows, or click Columns if your items are listed down columns.


Click the format you want to use. Report 1 through Report 10 displays a PivotTable report in indented format, similar to a traditional banded or formatted database report.

Table 1 through Table 10 and PivotTable Classic display a report in nonindented format. Table 1 through Table 10 do not move column fields in a report to the row area.

Table 1 through Table 5 and Table 7 add a blank line after each item in the outermost row field and apply character and cell formats. None removes all character and cell formats.


Click an option in the Category box, and then select the options that you want to specify a number format. The Sample box shows how selected cells will look with the formatting you choose. Click Custom if you want to create your own custom formats for numbers, such as product codes.


Shows how your document will look with the selected options.


Specifies how dates, times, fractions, or custom formats are displayed.


Select the number format under Type, and then click Delete to delete a custom number format. You cannot delete built-in number formats.


Enter a number to specify the number of digits displayed to the right of the decimal point.


Displays a currency symbol with your numbers.


Select the Use 1000 separator check box to include a separator between thousands.


Select an option in the Negative numbers box to specify how negative numbers are displayed.


Cells with General format have no specific number format applied. Cells with Text format are treated as text even when a number is entered in the cell; the number is displayed exactly as entered.


Select an option in the Horizontal list box to change the horizontal alignment of cell contents. By default, Microsoft Excel aligns text to the left, numbers to the right, and logical and error values are centered. The default horizontal alignment is General. Changing the alignment of data does not change the data type.


Changes the horizontal or vertical alignment of cell contents, based on the options you choose.


Indents cell contents from the left side of the cell. Each increment in the Indent box is equivalent to the width of one character.


Select an option in the Vertical box to change the vertical alignment of cell contents. By default, Microsoft Excel aligns text vertically on the bottom of a cell. The default horizontal alignment is General.


Wraps text into multiple lines in a cell. The number of wrapped lines is dependent on the width of the column and the length of the cell contents.


Combines two or more selected cells into a single cell. The cell reference for a merged cell is the upper-left cell in the original selected range.


Select an option under Orientation to change the orientation of text in selected cells. Rotation options may not be available if other alignment options are selected.


Sets the amount of text rotation in the selected cell. Use a positive number in the Degree box to rotate the selected text from lower left to upper right in the cell. Use negative degrees to rotate text from upper left to lower right in the selected cell.


Changes the orientation of cell contents to vertical.


Indents contents of selected cells.


Select a font name to change the font of the selected text. Select the options you want on the Font tab to change the appearance of the selected text.


Changes the font style of the selected text.


Changes the size of the selected text. The sizes available depend on the printer and the selected font.


Select the Strikethrough check box to draw a line through selected text or numbers.


Formats the selected text or numbers as superscript.


Formats the selected text or numbers as subscript.


Select an underline type to format the selected text with an underline.


Select a color from the list to change the color of the selected text or object.


Select the Normal font check box to set the font, font style, size, and effects to the Normal style.


Shows how your document will look with the selected options.


Describes the font you selected in the Font box.


Select an option under Style to specify the line size and style for a border. If you want to change a line style on a border that already exists, select the line style option you want, and then click the area of the border in the Border model where you want the new line style to appear.


Removes borders from selected cells.


Click a line style in the Style box, and then click the buttons under Presets or Border to apply borders to the selected cells. To remove all borders, click the None button. You can also click areas in the text box to add or remove borders.


Applies color to the selected cells.


Adds a border around only the outside edge of the range of selected cells, using the line style you select under Style.


Adds a border to the inside grid of the range of selected cells, using the line style you select under Style.


Select a color to change the background color of the selection.


Select a background color in the Color box, and then select a pattern in the Pattern box to format the selection with color patterns.


Shows how your document will look with the options you select.


Prevents selected cells from being changed, moved, resized, or deleted.

Locking cells has no effect unless the sheet is protected. To protect a sheet, point to Protection on the Tools menu, click Protect sheet, and then select the Contents check box.


Hides a formula in a cell so that it doesn't appear in the formula bar when the cell is selected.

If you select this option, it has no effect unless the sheet is protected. To protect a sheet, point to Protection on the Tools menu, click Protect sheet, and then select the Contents check box.


Reduces the apparent size of font characters so that all data in a selected cell fits within the column. The character size is adjusted automatically if you change the column width. The applied font size is not changed.


Select options under Text control to adjust how you want text to appear in a cell.


Select options under Effects to apply text effects to selected text.


Select border options under Presets to apply borders to or remove borders from selected cells.


Click in the Range box, and then select the data on your worksheet that you want to plot. If you want the column or row label for the new data to appear in the chart, include the cell that contains the label in the selection.


Click Rows or Columns to create the data series from the contents of each row or column in the copied selection.


Uses the first row or column of your selection as the label for your data series.


Uses the first row or column of your selection as category labels on the x axis.


Replaces the existing chart category labels with the category labels you want to paste.


Click New series to add the copied data to the chart as a new data series.

Click New points to add the copied data to the chart as an additional data point in each existing data series.


Click the attribute of the copied chart you want to paste to the selected chart.


Pastes both formats and values of the copied chart to the selected chart.


Pastes only formats of the copied chart to the selected chart.


Pastes only values of the copied chart to the selected chart.


Removes the cell contents, formats, or comments from selected cells.


Removes the cell contents, formats, and comments from selected cells.


Removes only the cell formats from selected cells; cell contents and comments are unchanged.


Removes only the cell contents from selected cells; formats are unchanged.


Removes only the cell comments from selected cells; cell contents and formats are unchanged.


Align Left (Formatting toolbar)

Aligns the selected text, numbers, or inline objects to the left with a ragged right edge.


Align Right (Formatting toolbar)

Aligns the selected text, numbers, or inline objects to the right with a ragged left edge.


Borders

Adds a border to the selected cell or range.

To format a cell or range with the last selected border, click  [image]. To specify another type of border, click the arrow next to the button, and select a border style from the palette.


Insert Cells

Displays the Insert dialog box, where you specify the direction you want to shift the surrounding cells, rows, or columns to make room for inserted cells.


Center (Formatting toolbar)

Centers the selected text, numbers, or inline objects.


Fill Color

Adds, changes, or removes the fill color or fill effect from the selected cell or object.


Comma Style

Applies the Comma style to the selected cells. To change the Comma style, use the Style command on the Format menu.


Currency Style

Applies the Currency style to the selected cells. To change the Currency style, use the Style command on the Format menu. Depending on the country selected in the Windows Regional Settings Properties dialog box, the International Currency Style button might appear instead of the Currency Style button.


Decrease Decimal

Decreases the number of digits displayed after the decimal point in the selected cells.


Find (Edit menu)

Searches selected cells or sheets for the characters you specify, and selects the first cell that contains those characters.


Font Color

Formats the selected text with the color on the button. To format the text for a different color, click the arrow next to  [image], and then click the color you want.


Format Painter (Standard toolbar)

Copies the format from a selected cell, range, text, or object and applies it to the object or text you click. To copy the formatting to more than one item, double-click  [image], and then click each item you want to format. When you are finished, press ESC or click  [image]  again to turn off the Format Painter.


Formula Bar

Displays or hides the formula bar.


Office Assistant

The Office Assistant provides Help topics and tips to help you accomplish your tasks.


Increase Decimal

Increases the number of digits displayed after the decimal point in the selected cells.


Lotus 1-2-3

Helps you learn the Microsoft Excel equivalents for Lotus 1-2-3 menu and command items. You can display the instructions for the equivalent item on your worksheet, or you can view a demonstration that shows the Microsoft Excel steps.


Percent Style

Applies the Percent style to the selected cells. To change the Percent style, use the Style command on the Format menu.


Replace

Searches for and replaces specified text, formatting, footnotes, endnotes, or comment marks in the active document.


Sort Ascending

Sorts the selected items in order from the beginning of the alphabet, the lowest number, or the earliest date by using the column that contains the active cell.


Sort Descending

Sorts the selected items in order from the end of the alphabet, the highest number, or the latest date by using the column that contains the active cell.


Spelling (Tools menu)

Checks spelling in the active document, file, workbook, or item.


Status Bar

Shows or hides the status bar. The status bar is the bar near the bottom of the screen that displays information about a selected command or an operation in progress. The right side of the status bar show whether keys such as CAPS LOCK, SCROLL LOCK, or NUM LOCK are turned on.


Bold (Formatting toolbar)

Makes selected text and numbers bold. If the selection is already bold, clicking  [image]  removes bold formatting.


Font

Changes the font of the selected text and numbers. In the Font box, select a font name.


Font Size

Changes the size of the selected text and numbers. In the Font Size box, enter a size. The sizes in the Font Size box depend on the selected font and active printer.


Print Preview (File menu)

Shows how a file will look when you print it.


Italic (Formatting toolbar)

Makes selected text and numbers italic. If the selection is already italic, clicking  [image]  removes italic formatting.


Underline (Formatting toolbar)

Underlines selected text and numbers. If the selection is already underlined, clicking  [image]  removes underlining.


Type a value from 0 (zero) through 255 to change the width of columns where you have selected cells. This number represents the number of characters that can be displayed in a cell formatted with the standard font. If the column width is 0, the column is hidden.


Applies the type of conditional format you want to the selected cell or range of cells. Click Cell Value Is to format a cell based on a cell's value or contents. Click Formula Is to format a cell based on the formula you specify. The formula you specify must evaluate to true or false.


Click the operator you want to use to set the condition on the selected cell range. When you click between or not between, you must specify top and bottom values for the condition you want to format. The top and bottom values are included in the range you apply conditional formats to.


Enter a value or a formula for the condition you want to format in the selected cell range. If you select between or not between when you apply conditional formats to cell values, you must specify top and bottom values for the range. The top and bottom values are included in the range you apply conditional formats to.


Shows how the cell range will look with the conditional formats applied.


Select the format elements you want to apply with conditional formatting. You can apply only one conditional format to a cell at a time.


Adds additional conditions to the selected cell range. Up to three conditions can be specified in one conditional format.

If more than one condition is true in a selected cell, the formatting you specify for the first true condition is applied. If none of the conditions specified are met, the default formatting of the cell is retained.


Removes conditions from the conditional format.


Keeps the change you made. Information about the change is displayed in the Your changes on sheet box.


Keeps the change the other person made. Information about the change is displayed in the Conflicting changes by box.


Keeps and saves all of your remaining changes.


Keeps all the remaining changes made by other users that conflict with the changes you are saving.


Displays information about a change you made during the current session that conflicts with another user's entry. Also describes related changes that will be affected by your decision. Use the scroll bar on the right of the box to review the entire contents of the box.


Displays information about a change saved by another user during the current session that conflicts with your entry. Also describes related changes that will be affected by your decision. Use the scroll bar on the right of the box to review the entire contents of the box.


Retype the password to confirm the password and protect the worksheet or workbook.


If you assign password protection to a worksheet or workbook and then forget the password, you can't open the workbook, gain access to its data from another workbook through links, remove protection from the worksheet or workbook, or recover data from the workbook.

A password is case sensitive, can be up to 255 characters long, and can contain any combination of letters, numbers, and symbols.


Identifies the appearance of the copied object. As shown on screen copies the object as it appears on your monitor. As shown when printed copies the object as it appears in print preview. If your selected printer is not a color printer, colored graphic objects will appear in black and white.


Identifies the appearance of the copied object. As shown on screen copies the object as it appears on your monitor. As shown when printed copies the object as it appears in print preview. If your selected printer is not a color printer, colored graphic objects will appear in black and white.


Select the Bitmap check box to copy a picture as a bitmap. A bitmapped picture will appear correctly only if the screen from which it is copied has the same resolution and is of the same type as the screen on which it is displayed.

Select the Picture check box to copy a picture as a Windows metafile. A Windows metafile can be resized; it will appear correctly whether or not the screen from which it is copied differs from the screen on which it is displayed.


Identifies the appearance of the copied object. As shown on screen copies the object as it appears on your monitor. As shown when printed copies the object as it appears in print preview. If your selected printer is not a color printer, colored graphic objects will appear in black and white.


Select the Bitmap check box to copy a picture as a bitmap. A bitmap picture will appear correctly only if the screen from which it is copied has the same resolution and is of the same type as the screen on which it is displayed.

Select the Picture check box to copy a picture as a Windows metafile. A Windows metafile can be resized; it will appear correctly whether or not the screen from which it is copied differs from the screen on which it is displayed.


Select or clear options under Show to display or hide the formula bar or status bar.


Displays the formula bar. The formula bar appears at the top of the worksheet.


Displays the status bar, which shows information about a selected command or option. The status bar appears at the bottom of the program window.


Select options under Comments to determine how comments are displayed on the worksheet.


Hides comments and comment indicators in cells that have comments attached.


Displays a small red triangle in the upper-right corner of a cell when there is a comment attached to the cell. Comments are displayed only when you rest a pointer over a cell that has a comment.


Displays the comment and comment indicator, a small red triangle in the upper-right corner of a cell, when there is a comment attached to the cell.


Select options under Objects to display or hide graphic objects in the workbook.


Displays all graphic objects, buttons, text boxes, drawn objects, and pictures.


Displays pictures and charts as gray rectangles. Displaying object placeholders can significantly increase the speed of scrolling through a sheet. Microsoft Excel does not display buttons, text boxes, or other types of graphic objects as gray rectangles when you select the Show placeholders option.


Hides all graphic objects, buttons, text boxes, drawn objects, and pictures. Microsoft Excel does not print hidden objects.


Select display options under Window options for the active window.


Displays page breaks that have been set automatically by Microsoft Excel.


Displays the formulas in cells instead of the values that the formulas produce.


Displays cell gridlines. To print gridlines, make sure the gridlines check box is checked on the Sheet tab of the Page Setup dialog box.


Sets the color for gridlines. If you click Automatic, the color is based on the text color defined in Windows Control Panel.


Displays row numbers on the left side of the sheet and column letters at the top of the sheet.


Displays outline symbols. Microsoft Excel does not display outline symbols unless the worksheet contains a previously created outline.


Displays a 0 (zero) in cells that contain zero values.


Displays the horizontal scroll bar at the bottom of the sheet.


Displays the vertical scroll bar on the right side of the sheet.


Displays sheet tabs so that you can move among and select workbook sheets. Sheet tabs appear at the bottom of the sheet window.


Calculates all open worksheets, including data tables, and updates all open chart sheets.


Calculates the active worksheet and any charts and chart sheets linked to this worksheet.


Select options under Calculation to specify how you want Microsoft Excel to calculate worksheets. To calculate the active worksheet and any charts and chart sheets linked to it, click Calc Sheet. Selecting other calculation options affects all open worksheets in the current session. The default calculation for Microsoft Excel is automatic.


Calculates all dependent formulas every time you make a change to a value, formula, or name. This is the default calculation setting.


Calculates all dependent formulas except data tables. To calculate data tables, click Calc Now on the Calculation tab.


Calculates open workbooks only when you click Calc Now on the Calculation tab. When you click Manual, Microsoft Excel automatically selects the Recalculate before save check box. If saving a workbook takes a long time, clearing Recalculate before save may improve the save time.


Limits iteration for goal seeking or for resolving circular references. Unless you specify otherwise, Microsoft Excel stops after 100 iterations or when all values change by less than 0.001. You can limit iteration by changing the number in the Maximum iterations box, the Maximum change box, or both boxes.


Type the numbers in the Maximum iterations and Maximum change boxes to change the maximum number of iterations used and the maximum amount of change below which iteration stops.


Sets calculation options that affect the entire workbook.


Calculates and updates formulas that include references to other applications.


Permanently changes stored values in cells from full precision (15 digits) to whatever format, including decimal places, is displayed.


Changes the starting date from which all dates are calculated from January 1, 1900, to January 2, 1904.


Recalculates data before the workbook is saved.


Saves copies of values contained in an external document linked to a Microsoft Excel worksheet.

If a worksheet with links to large ranges on an external document requires an unusually large amount of disk space or takes a very long time to open, clearing the Save external link values check box can reduce the disk space and time needed to open the worksheet.


Lets you use label names in formulas if ranges on your worksheet have row or column labels.


Sets options for editing your worksheet. Options checked on the Edit tab affect all worksheets in the workbook.


Select the Edit directly in cell check box to edit inside a cell by double-clicking the cell, rather than editing the cell contents only in the formula bar.


Select the Allow cell drag and drop check box to move and copy cells and data by dragging. With this option selected, you can also drag the fill handle to copy data and to fill adjacent cells with a series of data.


Displays a message if you drop cells over other cells that contain data.


Makes an adjacent cell the next active cell after you press ENTER in the current active cell. In the Direction box, indicate which adjacent cell becomes active.


Enter the number of decimal places in the Places box to indicate where Microsoft Excel will automatically put the decimal point in the numbers you enter as constants on a worksheet. A positive number moves the decimal point to the left; a negative number moves the decimal point to the right. If the Places box is left blank or set at 0 (zero), you need to enter the decimal point manually. To override this option, type a decimal point as you enter the number.


Keeps graphic objects, buttons, text boxes, drawn objects, and pictures with their associated cells whenever you cut, copy, filter, or sort on a worksheet.


Displays a message that lets you confirm before linked items are updated.


Displays worksheet movement and changes when you insert or delete cells, rows, or columns. Animation may slow video performance on some systems.


Completes text entries you start to type in a column of data. If the first few letters you type match an existing entry in that column, Microsoft Excel fills in the remaining text for you.


Type the key you want to press to activate the Microsoft Excel menu bar or start Help for Lotus 1-2-3 users. To specify other transition options, select the option you want under Sheet options.


Activates the Microsoft Excel menu bar when you press the key you typed in the Microsoft Excel menu or Help key box.


Starts Help for Lotus 1-2-3 users when you press the key you typed in the Microsoft Excel menu or Help key box.


Activates an alternate set of keys for worksheet navigation, formula entry, label entry, and other actions.


Select or clear options under Sheet options to specify how you want to evaluate expressions and convert formulas when you open a workbook: with Lotus 1-2-3 rules or Microsoft Excel rules.


Opens and evaluates Lotus 1-2-3 files without losing or changing information. With this option selected, Microsoft Excel evaluates text strings as 0 (zero), Boolean expressions as 0 or 1, and database criteria according to the rules used in Lotus 1-2-3.


Converts formulas entered in Lotus 1-2-3 release 2.2 syntax to Microsoft Excel syntax, and makes names defined in Microsoft Excel behave like names defined in Lotus 1-2-3.


Changes the reference style of row and column headings and cell references from A1 style to R1C1 style. In A1 style, columns are labeled alphabetically, and rows are labeled numerically. In R1C1 style, both columns and rows are labeled numerically.


Prevents exchange of data with other applications that use Dynamic Data Exchange (DDE).


Displays a list of recently used files at the bottom of the File menu, so you can open the files quickly. Enter the number of files you want to display in the entries box.


Reminds you to enter summary information — such as title, subject, author, keywords, and comments — for each new workbook as you save.


Sets the number of worksheets you want when you create a new workbook.


Enter the font size in the Size box to set the standard (default) font size for new sheets and workbooks. The new standard font size is used the next time you start Microsoft Excel and create a new worksheet or workbook.


Click the font in the Standard font box to set the standard (default) font for new sheets and workbooks. The new standard font is used the next time you start Microsoft Excel and create a new worksheet or workbook.


Type the path in the Default file location box to set the default working folder. If you want to type a path to a network server location for the default file location, enter the path by using the UNC syntax:

\\servername\foldername

You must restart Microsoft Excel to change the default working folder location to a network server.


Type the full path in the Alternate startup file location box to specify a folder for additional workbooks or other files you want to open automatically when you start Microsoft Excel. Excel opens files from this folder in addition to files in the default file location.


Type a new name in the User name box to change your user name.


To import list entries from a worksheet range, click in the Import list from cells box, select the range on the sheet, and then click Import. The worksheet range must have each entry in a separate cell. The first character of an entry cannot be a number.


Creates a custom list from existing items that you've listed in a worksheet range. Click in the Import list from cells box, select the range on the sheet, and then click Import.


Click a list that you want to edit, or click New List in the Custom lists box to create a new list, and then type the entries in the List entries box. The first character cannot be a number. Press ENTER to separate each entry.


Saves a custom list in the List entries box.


Deletes a selected custom list. You cannot delete the built-in custom lists.


Select chart display options under Active chart for the active chart in your workbook.


Controls how empty worksheet cells are plotted as data points.


Leaves gaps in the line for empty worksheet cells in a data series, making the line segmented.


Treats blank cells as zeros, so that the line drops to zero for zero-value data points.


Interpolates data points that represent blank cells, and fills in the gaps with connecting lines.


Automatically updates the chart to reflect only values in cells that are visible on the worksheet. Clear this check box if you also want hidden cells to be plotted.


Sizes chart sheets with the window so that the chart always fills the window. To size the chart sheet independently of the window, clear this check box. Chart sizes with window frame is available only for chart sheets, not for embedded charts.


Displays the name of a chart item when you rest the pointer over it.


Displays the value of a data marker when you rest the pointer over it.


Copies a color palette to the active workbook from another currently open workbook. Click the name of the other workbook in the Copy colors from box.


Displays the current colors.


The first eight colors Microsoft Excel uses for chart lines. These colors also can be used to format anything you can apply color to.


The first eight colors Microsoft Excel uses for chart fills. These colors also can be used to format anything you can apply color to.


Displays the Colors dialog box. You can edit any of the original 56 colors on the color palette to create custom colors.


Resets the color palette to its original 56 colors.


Plays available sounds that are associated with Microsoft Office program events, such as opening, saving, and printing files, and displaying error messages. Sounds assigned to different events can be changed in the Sounds Properties dialog box in Windows Control Panel. If you select or clear the Provide feedback with sound check box in one Office program, it is also turned on or off for all other Office 2000 programs. To change the sound that is associated with an event, open the Sounds folder in Windows Control Panel. Your computer must have a sound card to play most sounds.


Select or clear the boxes below to display or hide chart item names or data series names and values when you rest the pointer over chart items.


If you have the Microsoft IntelliMouse pointing device, sets the wheel button to zoom instead of scroll on your worksheet or chart sheet.


Specify display, viewing, and opening settings for your workbook.


Sets the default file type when you save workbooks. If your workbooks are used in different versions of Microsoft Excel, as Web pages, or in other programs, you can select the file type you most frequently use.


Select to automatically format new items added to the end of a list to match the format of the rest of the list. Formulas that are repeated in every row are also copied. To be extended, formats and formulas must appear in at least three of the five last rows preceding the new row.


Select to multiply by 100 all numbers less than 1 that you enter in cells formatted in the Percentage format. Clear this check box to multiply by 100 all numbers that you enter in cells formatted in the Percentage format, including numbers equal to or greater than 1.


Sets options for how your Microsoft Excel data will look and respond when the data is viewed in a Web browser.


Select to display an icon on the Windows taskbar for each open Microsoft Excel workbook or window. Clear this check box to display a single icon for the Excel program.


right-to-left\visual
Sets insertion point movement to progress within bidirectional text by moving to the next visually adjacent character. For example, when using the arrow keys to move from right to left through Arabic and then English text, the insertion point moves in a right-to-left direction through the Arabic text and then continues at the rightmost character of the English text and progresses in a right-to-left direction.


Cursor Movement
Detemines how the insertion point moves through bidirectional text.


Default direction
Specifies the direction for new worksheets and charts.


Alignment tab\right-to-left group
Select an option in the Text direction box to specify reading order and alignment.


right-to-left\logical
Sets the insertion point to move through bidirectional text according to the direction of the language encountered. For example, when using the arrow keys to move through Arabic text and then English text, the insertion point moves in a right-to-left direction through the Arabic text and then starts at the leftmost character of the English word and progresses in a left-to-right direction.


Alignment tab\left-to-right list box
Specifies fixed or variable text reading order and alignment. Click Right-to-Left to set the starting alignment to the right and the reading order to right-to-left. Click Left-to-Right to set the starting alignment to the left and reading order to left-to-right. Click Context to set attributes to match the language of the text entered — for example, if Arabic text is entered, reading order will be right-to-left and alignment will be to the right.


right-to-left\show control characters
Shows or hides bidirectional control characters; used to force right-to-left or left-to-right direction behavior.


default direction\left-to-right
Sets worksheets and charts to display with a left-to-right direction familiar to English and European language users — for example, displays cell A1 in the upper-left corner of the worksheet window and sets cell reading order to left-to-right, with text flowing to the right.


Sets worksheets and charts to display with a right-to-left direction familiar to users of languages that flow from the right to the left — for example, displays cell A1 in the upper-right corner of the worksheet window and sets cell reading order to right-to-left, with text flowing to the left.


View tab\right-to-left
Changes the direction of the current worksheet to a right-to-left direction, with cell A1 in the upper-right corner of the worksheet window.


Select the check boxes for the rows or columns, or a combination of rows and columns, that contain the labels you want to use for names.


Lists available standard chart types.


Click the subtype, or variation, of the chart type you want to use. If there are no subtypes displayed, the current chart may be a custom chart type.


Select chart type and formatting options for the active chart or selected data series, based on the chart type you've chosen.


Applies the chart type you've clicked to the selected data series on your chart. If a single data series is not selected, this option is not available.


Removes formatting you've applied to the chart type or any selected chart item, and returns the chart to the default appearance; the data is not affected.


Previews the currently selected chart type as it looks when applied to your data.


Displays the user-defined or built-in custom chart types Microsoft Excel provides.


Displays custom charts that you've defined.


Displays built-in custom chart types to apply to your chart.


Choose the user-defined chart type or a Microsoft Excel built-in chart type to apply to your chart.


Adds the active chart to the list of available chart types.


Deletes the custom chart type selected in the list.


Displays a sample of the selected custom chart type.


Starts the Microsoft Office Assistant. Displays tips and Help topics that assist you with steps in the wizard.


Advances to the next step of the wizard.


Accepts the default options for the remaining steps of the wizard, and displays the results in your document.


Returns to the previous step in the wizard.


Specifies that your data series are in rows.


Specifies that your data series are in columns.


Click an option to plot the data series from the rows or columns in your selection. The data series name appears in the legend.


Click in the Data range box. Select the data on your worksheet to designate the data you want to plot. If you select the data before you start the Chart Wizard, or if you change the existing source data, the range may already appear in this box. If you change the existing source data, make sure the entire reference in the Data range box is selected, and then select the new data on your worksheet. The Collapse Dialog button at the right end of this box temporarily moves the dialog box so that you enter the range by selecting cells in the worksheet. When you finish, you can click the button again to display the entire dialog box.


Specify a range of cells to be used for category labels. The Collapse Dialog button at the right end of this box temporarily moves the dialog box so that you enter the range by selecting cells in the worksheet. When you finish, you can click the button again to display the entire dialog box.


Lists existing data series names. You can add and remove data series from the chart without affecting the data on your worksheet.


Shows how the options you select will affect your chart.


Click an option to plot the data across rows or down columns.


Specifies that your data series are from the rows of the worksheet.


Specifies that your data series are from the columns of the worksheet.


Click in the Data range box, and then select the data on your worksheet that you want to plot. If you select the data before you start the Chart Wizard, or if you change the existing source data, the range may already appear in this box. The Collapse Dialog button at the right end of this box temporarily moves the dialog box so that you enter the range by selecting cells in the worksheet. When you finish, you can click the button again to display the entire dialog box.


The Chart Wizard cannot understand your chart. Any changes will result in new chart data.


Specify a range of cells other than the default selection, to be used for category labels. The Collapse Dialog button at the right end of this box temporarily moves the dialog box so that you enter the range by selecting cells in the worksheet. When you finish, you can click the button again to display the entire dialog box.


Lists existing data series names. You can add and remove data series from the chart without affecting the data on your worksheet.


Displays the cell reference that contains the label for the data series selected in the Series box. You can change the name of the series in the Name box without affecting the text on your worksheet. The name you enter will appear in the legend for the selected series. If you type a name in the Name box, the name is no longer linked to a worksheet cell. The Collapse Dialog button at the right end of this box temporarily moves the dialog box so that you enter the range by selecting cells in the worksheet. When you finish, you can click the button again to display the entire dialog box.


Displays the cell reference that contains the data for the series selected in the Series box. To add values for the new series, click in the Values box, and then select a worksheet range; or type the values in the boxes. If you type values in the Values box, data is not added to the worksheet. The Collapse Dialog button at the right end of this box temporarily moves the dialog box so that you enter the range by selecting cells in the worksheet. When you finish, you can click the button again to display the entire dialog box.


Displays the cell reference that contains the data used to determine the size of bubble data markers.


Click to add a new blank data series to the chart. To add the series name and values for the new series, click in the boxes for Name and Values, and then select a worksheet range; or type the name and values in the boxes. If you type a name in the Name box or values in the Values box, data is not added to the worksheet.


Removes the selected data series from the chart. You can add and remove data series from the chart without affecting the data on your worksheet.


Shows how the options you select will affect your chart.


Place the chart on an existing worksheet or on a new chart sheet.


Click As new sheet, and then type a name for the new chart sheet in the As new sheet box to place the chart on a new chart sheet.


Click As object in, click a sheet name in the As object in box, and then click OK to place the chart as an embedded object on a worksheet. Drag the embedded chart where you want it on the worksheet.


Select a filtering operation in the box on the left, and enter a value from the worksheet in the box on the right. To include another set of criteria in the filter, click And or Or, and then use the bottom row of boxes.


Click And to combine two criteria. Click Or to use either of two criteria.


Indicates which record is displayed and how many records are in a list. The record number changes to New Record when you scroll past the end of the list.


Click the New button to clear the fields in the Data Form dialog box and enter data for a new record. Press ENTER to add the record to the end of the list; click Close to add the new record and close the data form.


Permanently deletes the displayed record in the data form and in the list.


Click Restore before pressing ENTER or scrolling to another record to undo changes you made in the data form. Clicking Restore will not restore a deleted record.


Displays the column labels that correspond to each column in your list. In the box to right of the column labels, you can enter new records, edit existing records, or find records in your list based on criteria you specify.


Displays the previous record in a list. If you specified criteria using the Criteria button, Find Prev displays the previous record that matches the criteria.


Displays the next record in a list. If you specified criteria using the Criteria button, Find Next displays the next record that matches the criteria.


Finds records based on the criteria you specify. When you click Criteria, the record number at the upper right of the form changes to Criteria. In the boxes on the left side of the form, type a value or values for which you want to find matching records, and then click Find Next or Find Prev.


Use the scroll bar to move between adjacent records in a list.


Closes the data form. You must save your workbook to save any records added to your list with the data form.


Adds data labels to or removes them from all data points in a chart.


Removes data labels from all data points.


Displays the value of all data points.


Displays the percentage of the whole for all data points in pie and doughnut charts.


Displays the category label assigned to all data points. For area charts, this option displays the series name.


In pie and doughnut charts, displays both the percentage of the whole and the category labels for each section of the chart.


Displays the sizes for each bubble in a bubble chart, based on the values of the third data series.


Places legend keys, with the assigned format and color, next to the data labels in the chart.


Lets you find other workbooks with data you want to include in the consolidation.


Adds the source area displayed in the Reference box to the All references box.


Removes the source area displayed in the Reference box.


Specifies the range of cells you select as a source area to consolidate with other source areas listed in the All references box. You can consolidate up to 255 source areas. The Collapse Dialog button at the right end of this box temporarily moves the dialog box so that you enter the range by selecting cells in the worksheet. When you finish, you can click the button again to display the entire dialog box.


Lists the source area references selected for the consolidation.


Specifies the summary function Microsoft Excel will use to consolidate data.


Uses labels from your source areas when you consolidate by category, if you included the labels when you selected the data. Use the Top row or Left column boxes only when you want to consolidate data with labels that are similar but arranged differently in each source area selected for consolidation.

If you want to consolidate data that has different category labels but contains similar data arranged identically in each source area, or if you want to consolidate by position, do not include labels when you select source areas.


Updates the consolidation area data automatically when the data changes in any of the source areas.


Adds the selected entry in the Names in workbook and Refers to boxes to the list of names defined for the workbook.


Deletes the name selected in the Names in workbook list.


Click a name in the Names in workbook list to select from the list of all names defined in the workbook.


Displays the cell reference, defined name, formula, or constant for the defined name you select in the Names in workbook list. If a name is not selected in the list or there are no names defined for the workbook, the cell reference of the active cell is displayed.


Select the format condition you want to remove from the selected cells.


Groups the rows or columns containing the selected data to create an outline. Use the Settings command on the Group and Outline menu to determine how the data is grouped.


Displays or hides the primary axes of your chart.


Displays the category (x) axis.


Automatically displays data with a time-scale (x) axis, if x axis data is date formatted. Displays the default category (x) axis with all other data.


Displays data on the selected axis as the default category (x) axis, even if data is date formatted.


Displays the category axis with a time-scale (x) axis, even if axis data is not date formatted. Time-scale tick marks are evenly spaced across the x axis, based on the major and minor units of time.


Displays the value (y) axis.


Displays the secondary axis of your chart.


Displays a secondary category (x) axis.


Displays a secondary value (y) axis.


Sets display options for the primary axes of your chart.


Displays the 3-D category (x) axis.


Displays the series (y) axis in a 3-D chart.


Displays the value (z) axis in a 3-D chart.


Aligns text labels from the data on your spreadsheet with the chart elements you choose.


Attaches a title to the top of your chart.


Attaches a title to the axis you choose.


Displays gridlines on the category (x) axis, based on the options you choose.


Displays gridlines at the major intervals on the category (x) axis.


Displays gridlines at the minor intervals on the category (x) axis.


Displays gridlines on the value (y) axis, based on the options you choose.


Displays gridlines on the series (y) axis, based on the options you choose.


Displays gridlines at the major intervals on the series (y) axis.


Displays gridlines at the minor intervals on the series (y) axis.


Displays gridlines on the value (z) axis of a 3-D chart, based on the options you choose.


Displays gridlines at the major intervals on the value (z) axis of a 3-D chart.


Displays gridlines at the minor intervals on the value (z) axis of a 3-D chart.


Applies a two-dimensional appearance to the walls and gridlines for 3-D bar charts, 3-D stacked area charts, and 3-D clustered column charts.


Adds a legend to the chart area.


Places the selected legend in the location you want, and resizes the plot area to accommodate the legend.


Adds or removes data labels to or from all data points in a chart.


Removes data labels from all data points.


Displays the value of all data points.


In pie and doughnut charts, displays the percentage of the whole for all data points.


Displays the category label assigned to all data points. For area charts, this option displays the series name.


In pie and doughnut charts, displays both the percentage of the whole and the category labels for each section of the chart.


Displays the sizes for each bubble in a bubble chart, based on the values of the third data series.


Places legend keys, with the assigned format and color, next to the data labels in the chart.


In pie charts, displays a line from the pie slice data point to its label.


Displays the values for each data series in a grid below the chart. This option is not available for pie, xy (scatter), doughnut, bubble, radar, or surface charts.


Displays legend keys, with the assigned format and color for each plotted series, next to the series label in the data table.


Shows how the options you select will affect your chart.


Click in a box, and then type the text you want for a chart or axis title. To insert a line break in a chart or axis title, click the text in the chart, click where you want to insert the line break, and then press ENTER.


Displays a label that exists in more than one cell on your worksheet. If the same label is used for more than one range of cells, Microsoft Excel may not be able to determine what cell should be used for the label name you want to use in a formula. In the box following Select the cell containing the label to use, enter the cell reference containing the label you want to refer to.


Select the cell on the worksheet that refers to the label you want to use in your formula. The Collapse Dialog button at the right end of this box temporarily moves the dialog box so that you enter the cell reference by selecting the cell on the worksheet. When you finish, you can click the button again to display the entire dialog box.


Click the data validation option in the Allow box, and then choose the comparison operator and restrictions you want to apply to the selected cells in the boxes that follow the Allow box.


Click a data validation option in the Allow box to apply restrictions on data entry to selected cells on the worksheet. Click the Custom option to enter a formula, use an expression, or refer to a calculation in another cell to determine valid entries.


Click the comparison operator you want to use. The available operators depend on the type of data you chose in the Allow box.


Enter the minimum value, start date, or start time as a value, cell reference, or formula for the data validation option you chose in the Allow box.


Apply the maximum value, end date, or end time as a value, cell reference, or formula for the data validation option you chose in the Allow box.


Stops an error message from appearing when a restricted cell or a dependent cell for references or formulas is blank.


Displays an arrow for the list of restricted entries that are assigned to the selected cell. The reference for the restricted list is in the Source box.


Applies all restrictions, input messages, and error messages displayed in this dialog box to other cells on the worksheet that have the same data validation settings as the selected cells.


Select the Show input message when cell is selected check box to display a message that prompts for entry into the selected cell.


Type an optional title for the input message you want to display when a user selects the restricted cell. The title will appear in bold text in the message.


Type the text of the message you want to display, up to 255 characters. Press ENTER to start a new line in the message box.


Select the Show error alert after invalid data is entered check box to display an error alert message when incorrect data is entered in a cell, or prevents the entry of incorrect data entirely.


Click an error style in the list. The style of error alert you choose determines what choices the error message presents when an invalid entry is made in a restricted cell.


Type an optional title for the error message box. The title will appear in bold text in the error message.


Type an error message that will appear when an incorrect entry has been made. You can enter up to 225 characters for the error message.


Cancels all selections and deletes information from all three tabs of the Data Validation dialog box. To undo the effects of Clear All, click Cancel.


Sets the default IME mode for entering data.


Specifies the direction you want to shift the surrounding cells, rows, or columns when you delete cells.


Shifts the contents of the remaining cells to the left to fill the remaining space when you delete cells.


Shifts the contents of the remaining cells up to fill the remaining space when you delete cells.


Deletes an entire row.


Deletes an entire column.


Specifies the direction you want to shift the surrounding cells, rows, or columns to make room for inserted cells.


Shifts the contents of the destination cells right when you insert cells.


Shifts the contents of the destination cells down when you insert cells.


Inserts an entire row when you insert cells.


Inserts an entire column when you insert cells.


Specifies the direction you want to shift the surrounding cells, rows, or columns to make room for copied cells you want to insert.


Select an option under Fill to specify which items to copy across grouped sheets from the selected cells.


Click an option under Action to hide rows that do not meet the specified criteria, or to copy the filtered data to another location on the worksheet.


Enter the range of cells you want to filter in the List range box. The Collapse Dialog button at the right end of this box temporarily moves the dialog box so that you enter the range by selecting cells in the worksheet. When you finish, you can click the button again to display the entire dialog box.


Enter the range of cells that contain your criteria in the Criteria range box. The Collapse Dialog button at the right end of this box temporarily moves the dialog box so that you enter the range by selecting cells in the worksheet. When you finish, you can click the button again to display the entire dialog box.


Specify a range of cells to copy the rows that meet your criteria. The Collapse Dialog button at the right end of this box temporarily moves the dialog box so that you enter the range by selecting cells in the worksheet. When you finish, you can click the button again to display the entire dialog box.


Select the Unique records only check box to display or copy only the unique rows that meet your criteria and to exclude duplicate rows. If you do not specify a criteria range, selecting this option hides all duplicate rows in the list.


Specify a file type or converter for the file you are opening.


Assists you in building a formula with worksheet functions.

The Formula Palette displays the name of the selected function and each of its arguments, describes the function and each argument, and gives the current result of both the function and the entire formula. You can edit functions in a formula by clicking the function name in the formula bar and then changing the arguments in the edit boxes.

For more information about the selected function, click  [image]  in the lower-left corner of this dialog box. When the Office Assistant appears, click Help with this wizard, and then click Help on selected function.


Select a font name to change the font of the selected text.


Formats the selected text or numbers with an outline around the text.


Shadows the selected text or numbers.


Formats the background of the selected text or numbers with the pattern or color you choose.


Scales text and numbers attached to an object in proportion when you resize the object.


Shows how text or numbers will look with the selected options.


Select an option in the Line box to specify the line style, color, or weight for a gridline or border.


Applies the default settings for the gridline or border of the selected data table.


Removes a gridline or border from the selected data table.


Select an option in the Style box to specify the line style for a gridline or border.


Select an option in the Color box to change the gridline or border color of the selected data table.


Select an option in the Weight box to change the weight or thickness of the gridline or border of the selected data table.


Places legend keys, with the assigned format and color, next to the series names in the data table for the chart.


Shows how the data table will look with the options you select.


Select or clear the check box to apply or remove formatting on the gridlines in the selected data table. The sample picture in the Sample box displays the formatting you've applied.


Click the location on the data marker where you want the data label to appear.


Select the Floor (XY plane) check box to have Microsoft Excel determine where the selected axis crosses the value or category axis. Change the value in the Floor (XY plane) crosses at box if you want the selected axis to cross at a different value on the axis.


For the selected category (x) axis scale, type a value in the Category (X) axis crosses at box to specify the value at which you want the (x) axis to cross the value (y) axis. Selecting the Auto check box causes the (x) axis to cross the value (y) axis at 0 (zero) or at the number in the value-axis range closest to 0 (zero).

For the selected value (y) axis scale, type a value in the Value (X) axis crosses at box to specify the value at which you want the value (x) axis to cross the value (y) axis. Selecting the Auto check box causes the value (x) axis to cross the value (y) axis at 0 (zero) or at the number in the value axis range closest to 0 (zero).


Select the Value (Y) axis check box to have Microsoft Excel determine where the value (y) axis crosses the value (x) axis. Change the value in the Value (Y) axis crosses at box if you want the selected axis to cross at a different value on the value (x) axis.


Select the Floor (XY plane) check box to have Microsoft Excel determine where the selected axis crosses the value or category axis. Change the value in the Floor (XY plane) crosses at box if you want the selected axis to cross at a different value on the axis.


Select the Values in reverse order box to flip the direction of values on the axis of an xy scatter chart, or to flip the direction of bars or columns in a bar or column chart.


Select the Floor (XY plane) crosses at minimum value box to have the floor or the category axis, depending on the 3-D chart type, cross the value axis at the lowest value. This option overrides the Floor (XY plane) crosses at value.


For the selected category (x) axis scale, select the Category (X) axis crosses at maximum value box to have the category (x) axis cross the value (y) axis at the highest value. This option overrides the Category (X) axis crosses at value.

For the selected value (y) axis scale, select the Value (X) axis crosses at maximum value box to have the value (x) axis cross the value (y) axis at the highest value. This option overrides the Value (X) axis crosses at value.


Select the Value (Y) axis crosses at maximum value box to have the value (y) axis cross the value (x) axis at the highest value. This option overrides the Value (Y) axis crosses at value.


Each category on the category axis is identified by a label and separated from other categories by tick marks. You can change the intervals at which labels and tick marks appear.


Type a number in the Number of series between tick-mark labels box to specify the frequency at which you want series on the selected axis to be labeled. Type 1 to label every series, type 2 to label every other series, type 3 to label every third series, and so on.


Type a number in the Number of series between tick marks box to specify the number of series you want between each pair of tick marks on the selected axis.


Select the Series in reverse order box to reverse the order in which you want the series on the series axis to be displayed.


Closes this dialog box and applies any changes you've made.


The Cancel button closes this dialog box without applying any changes you have made. The Close button closes this dialog box and retains the changes you made.


Sets options for a border around the selected object.


Applies the default settings for the line or border of the selected object.


Removes a line or border from the selected object. If the object is a line you've drawn, clicking None may make it invisible.


Applies the custom formats you choose on the selected object.


Select an option in the Style box to specify the line style for a line or border.


Select an option in the Color box to change the line or border color of the selected object.


Select an option in the Weight box to change the weight or thickness of the selected line or border.


Adds a shadow to the bottom and right side of the selected object.


Sets options for the background area of the selected object.


Applies the default settings for the area of the selected object.


Removes any settings applied to the area of the selected object.


Click the boxes you want in the Pattern box to specify a pattern and a color for the selected object.


Click the color you want in the Color box to specify a color for the chart item.


Changes the foreground color of the data marker.


Changes the background color of the data marker.


Click Fill Effects to change options for gradients, textures, patterns, and pictures used in formatting the selected object.


Reverses the foreground and background colors for a data series when the value it represents is negative. This option applies to data series in bar, column, area, and pie charts.


Applies formatting options you select to all data series.


Displays the colors and patterns that you select.


Specify the style, color, and weight of lines on a selected object.


Smoothes out angularity or jagged edges in the lines of a line chart or an xy (scatter) chart. This smoothing does not affect your data.


Specify the type and style of data markers in line, radar, and xy (scatter) charts.


Specify the style, color, weight, or display of axes on a selected chart object.


Specify the type of major or minor tick mark you want to display on the selected axis.


Displays tick marks at the major gridlines on the selected axis.


Hides major tick marks for the selected axis.


Displays major tick marks on the chart side (inside) of the selected axis.


Displays major tick marks on the outside of the selected axis.


Displays major tick marks that cross inside and outside the selected axis.


Displays tick marks at the minor gridlines on the selected axis.


Hides minor tick marks for the selected axis.


Displays minor tick marks on the chart side (inside) of the selected axis.


Displays minor tick marks on the outside of the selected axis.


Displays minor tick marks that cross inside and outside the selected axis.


Specify the type of major or minor tick-mark label you want to display on the selected axis.


Hides tick-mark labels for the selected axis.


Displays tick-mark labels at the bottom of the plot area for a horizontal axis or to the right of the plot area for a vertical axis, depending on the selected axis.


Displays tick-mark labels at the top of the plot area for a horizontal axis or to the left of the plot area for a vertical axis, depending on the selected axis.


Displays tick-mark labels next to the selected axis.


Displays the axis as it will look with the selected options applied.


You can change the range, or scale, of values on the selected axis. You can also change the intervals at which the values occur and the point at which one axis crosses another.


Microsoft Excel automatically calculates the scale of the selected axis, based on the range of data values. All check boxes under Auto are selected by default, and the automatic values shown in the Minimum, Maximum, Major unit, Minor unit, and Category axis cross boxes are displayed next to the labels. Type the values you want to use to calculate the axis scale in the boxes below. Click the check boxes of items you want to reset to the default scale.


Select the Minimum check box to display the lowest value (rounded) from all data series as the smallest data value on the selected axis.


Type a value in the Minimum box to specify the smallest data value you want to appear on the selected axis.


Select the Maximum check box to display the highest value (rounded) from all data series as the highest data value on the selected axis.


Type a value in the Maximum box to specify the highest data value you want to appear on the selected axis.


Select the Major unit check box to have Microsoft Excel determine the interval of major tick marks and major gridlines (if they are displayed) on the selected axis.


Type a value in the Major unit box to specify the interval of major tick marks and major gridlines (if they are displayed) on the selected axis.


Select the Minor unit check box to have Microsoft Excel determine the interval of minor tick marks and minor gridlines (if they are displayed) on the selected axis.


Type a value in the Minor unit box to specify the increment you want between minor tick marks and minor gridlines (if they are displayed) on the value (y) axis.


Type a value in the Category (X) axis crosses at box to specify the value at which you want the category (x) axis to cross the value (y) axis. Selecting the Auto check box causes the category (x) axis to cross the value (y) axis at 0 (zero) or at the number in the value-axis range closest to 0 (zero).


Select the Logarithmic scale check box to recalculate the values shown in the Minimum, Maximum, Major unit, and Minor unit boxes as powers of 10 for the value axis, based on the range of data plotted in the chart. No zeros or negative data values are permitted on logarithmic charts, and the values in the Major unit and Minor unit boxes must be 10 or greater.


Select the Values in reverse order box to flip the direction of bars or columns in a bar or column chart.


Select the Category (X) axis crosses at maximum value box to have the category (x) axis cross the value (y) axis at the highest value. This option overrides the Category (X) axis crosses at value.


Each category on the category axis is identified by a label and separated from other categories by tick marks. You can change the intervals at which labels and tick marks appear. For 2-D charts, you can specify where you want the value (y) axis to cross the category (x) axis.


Type the number in the Value (Y) axis crosses at category number box to specify the category number where you want the value (y) axis to cross the category (x) axis.


Type a number in the Number of categories between tick-mark labels box to specify the frequency at which you want categories on the category (x) axis to be labeled. Type 1 to label every category, type 2 to label every other category, type 3 to label every third category, and so on.


Type a number in the Number of categories between tick marks box to specify the number of categories you want between each pair of tick marks on the category (x) axis.


Select the Value (Y) axis crosses between categories box to have the value (y) axis cross the category (x) axis at the edge of the category indicated in the Value (Y) axis crosses at category number box. If this box is selected, data points are plotted between tick marks; if this box is cleared, points are plotted at the tick-mark positions. To have the edges of an area chart meet the edges of the plot area, clear the Value (Y) axis crosses between categories box.


Select the Categories in reverse order box to reverse the order you want the categories on the category (x) axis to be displayed in.


Select the Value (Y) axis crosses at maximum category box to have the value (y) axis cross the category (x) axis after the last category on the x axis. This option overrides the Value (Y) axis crosses at category number value.


Select the Value (Z) axis crosses between categories box to display the value (z) axis between categories. This option is available only for 3-D line charts and 3-D area charts.


A time-scale axis is a special type of category axis for data that is organized by date. Microsoft Excel automatically uses a time-scale axis in your chart if the worksheet data contains date number formatting. The time-scale axis in the chart displays the dates in chronological order, even if the dates are not in order on the worksheet. Time-scale axes are available on 2-D column, line, bar, and area charts and 3-D column, line, bar, area, and surface charts. They are not available in PivotChart reports or charts with multiple-level category labels.


Microsoft Excel automatically uses a time-scale axis in your chart if the worksheet data contains date number formatting and not more than one level of category labels. Microsoft Excel calculates the time-scale of the selected axis, based on the range of date values. All check boxes under Auto are selected by default, and the minimum, maximum, major unit, minor unit, and base unit automatic values are displayed in the boxes adjacent to the labels. Type the values you want to use to customize the time-scale axis in the boxes below. Click the check boxes of items you want to reset to the default scale.


Select the Minimum check box to have Microsoft Excel determine the beginning, or minimum, time interval of major tick marks and major gridlines (if they are displayed) on the time-scale axis.


Type a date in the Minimum box to specify the beginning, or minimum, time interval of major tick marks and major gridlines (if they are displayed) on the time-scale axis. To reset the default time-scale that Microsoft Excel determines, click the Minimum check box.


Select the Maximum check box to have Microsoft Excel determine the ending, or maximum, time interval of major tick marks and major gridlines (if they are displayed) on the time-scale axis.


Type a date in the Maximum box to specify the ending, or maximum, time interval of major tick marks and major gridlines (if they are displayed) on the time-scale axis. To reset the default time-scale that Microsoft Excel determines, click the Maximum check box.


Select the Base unit check box to have Microsoft Excel determine the unit of time, or base unit, used as the interval between two dates on the time-scale axis.


Click Day(s), Month(s), or Year(s) to change the base unit of the time-scale axis to different levels of dates in the chart. The unit of time, or base unit, in the time-scale axis is the smallest time difference between two dates in the data.


Enter a value in the Major unit box to specify the time interval of major tick marks and major gridlines (if they are displayed) on the time-scale (x) axis. In the box to the right of the Major unit box, click Day(s), Month(s), or Year(s) to change the base unit of the time-scale axis to different levels of dates in the chart. The time-scale axis in the chart displays the dates in chronological order, even if the dates are not in order on the worksheet. The unit of time, or base unit, in the time-scale axis is the smallest time difference between two dates in the data.


Enter a value in the Minor unit box to specify the time interval of minor tick marks and minor gridlines (if they are displayed) on the time-scale (x) axis. In the box to the right of the Minor unit box, click Day(s), Month(s), or Year(s) to change the base unit of the time-scale axis to different levels of dates in the chart. The time-scale axis in the chart displays the dates in chronological order, even if the dates are not in order on the worksheet. The unit of time, or base unit, in the time-scale axis is the smallest time difference between two dates in the data.


Select the Value (Y) axis crosses at check box to have the value (y) axis cross the time-scale (x) axis at the date specified in the Minimum box. Change the date in the Value (Y) axis crosses at box if you want the value (y) axis to cross at a different date on the time-scale axis.


Select the Value (Y) axis crosses between dates box to display the value (y) axis between dates.


Select the Dates in reverse order box to reverse the order that you want the dates on the time-scale (x) axis to be displayed in.


Select the Value (Y) axis crosses at maximum value box to have the value (y) axis cross the time-scale (x) axis at the highest date value. This option overrides the Value (Y) axis crosses at date value.


Select the Strikethrough check box to draw a line through selected text or numbers.


Formats the selected text or numbers as superscript.


Formats the selected text or numbers as subscript.


Select an underline type to format the selected text with an underline.


Select a color from the list to change the color of the selected text or object.


Select the Normal font check box to set the font, font style, size, and effects to the Normal style.


Click an option in the Background box to specify whether you want the background behind chart text to be opaque, transparent, or determined automatically by Microsoft Excel.


Describes the font you selected in the Font box.


Select the Linked to source check box to link the number formats of values on the chart to the worksheet data. If you change a data label on the chart manually, the link for that label is broken.


Changes the horizontal or vertical alignment of text, based on the options you choose.


Select an option in the Horizontal box to change the horizontal alignment of text.


Select an option in the Vertical box to change the vertical alignment of text.


Select an option under Orientation to change the orientation of text. Rotation options may not be available if other alignment options are selected.


Click an option to reposition the selected legend on the bottom, upper-right corner, top, left, or right of the chart area.


Inserts a linear trendline. This option creates a trendline by using the linear equation y = mx + b.


Inserts a logarithmic trendline. This option creates a trendline by using the logarithmic equation y = clnx + b.


Inserts a polynomial or curvilinear trendline. This option creates a trendline by using the polynomial equation  [image].


Inserts a power trendline. This option creates a trendline by using the power equation  [image]. This option is not available when your data includes negative or zero values.


Inserts an exponential trendline. This option creates a trendline by using the exponential equation  [image]. This option is not available when your data includes negative or zero values.


Inserts a moving average trendline. A moving average uses a specific number of points (set by the Period option), averages them, and uses the average value as a point in the line.


Enter a value in the Order box to determine the highest polynomial order. The value is expressed as an integer between 2 and 6.


Enter a value in the Period box to specify the number of periods you want to use to calculate the moving average.


Click the option you want under Trend/Regression type to add trendlines to, or change the trendline type for, data series in area, bar, column, line, and xy (scatter) charts. Trendlines cannot be added to 3-D, radar, pie, doughnut, or bubble charts.


Select the series you want to display a trendline for.


Specifies how you want the trendline name to be created. The name assigned to the trendline is displayed in the legend.


Automatically names the trendline, based on the type selected and the series it is associated with. The name that will be used for the trendline appears to the right of this option.


Click Custom, and then type a name up to 256 characters long in the Custom box to assign a custom name to a trendline.


Type the numbers you want in one of the two boxes under Forecast to specify how you want regression trendlines to be forecast. This option is not available for moving average trendlines.


Type a number in the Forward box to specify how many periods (or units, for xy charts) you want to plot a trendline forward.


Type a number in the Backward box to specify how many periods (or units, for xy charts) you want to plot a trendline backward.


Type a value in the Set intercept = box to specify the point at which you want the trendline to meet the y axis. This option applies to linear, polynomial, and exponential trendlines; it is not available for logarithmic, power, and moving average trendlines.


Displays a regression equation for the trendline in the trendline label in the chart.


Displays an R-squared value for the trendline in the trendline label in the chart. The R-squared value that is displayed is not an adjusted value.


Rounds the corners of a border on the selected object.


Adjusts the amount of text rotation for the selected text. Use a positive number in the Degree box to rotate the selected text from lower left to upper right. Use negative degrees to rotate text from upper left to lower right.


Sets the amount of text rotation for the selected text. Use a positive number in the Degree box to rotate the selected text from lower left to upper right. Use negative degrees to rotate text from upper left to lower right.


Changes the orientation of selected text to vertical.


Protects the selected object from changes.


Protects the text of a selected object from changes.


Formats Y error bars without a T-top.


Formats Y error bars with a T-top.


Makes value axis text shorter and more readable. For example, if the chart values range from 1,000,000 to 50,000,000, you can display the numbers as 1 to 50 on the axis by clicking Millions in the list.


Select to show a label that describes the units selected in the Display units list. For example, if you select Millions in the Display units list, a label that says "Millions" will be displayed next to the value axis on the chart.


Changes the alignment position of category axis labels. If you have multiple-level category labels, you can change the alignment of all but the first level of labels.


Changes the spacing between the label and the category axis line, or between multiple-level category labels. The higher the value, the more space between the items.


Click the vertical and horizontal alignment settings you want for the text in the selected object or cells.


Click the orientation you want for the text in the selected cell or text box.


Orients text horizontally in the selected cells or text box. This is the default text orientation.


Aligns selected text vertically, with each character below the previous one, so that you read it from top to bottom:

T

E

X

T


Orients text vertically, bottom-to-top.


Orients text vertically, top-to-bottom.


Automatically adjusts the size of the AutoShape, so that the text fills it completely.


Select an option in the Style box to specify the line style for a line or border.


Select an option in the Width box to change the width or thickness of the selected line or border.


Select an option in the Length box to change the length of the selected line.


Shows how the selected object will look with the options you select.


Displays the value of all data points.


Displays legend keys, with the assigned format and color.


Indents cell contents from the left side of the cell, or text from the left side of the text box. Each increment in the Add indent box is equivalent to the width of one character.


Prevents selected objects from being changed, moved, resized, or deleted. You must also select Lock Text if you want to prevent text within the selected object from being changed, moved, or deleted.

Locking objects has no effect unless the sheet is protected. To protect a sheet, point to Protection on the Tools menu, click Protect Sheet, and then select the Objects check box.


Prevents text in selected objects from being changed, moved, or deleted. You must also select Locked to prevent both the selected object and the text within from being changed, moved, resized, or deleted.

Locking text in objects has no effect unless the sheet is protected. To protect a sheet, point to Protection on the Tools menu, click Protect Sheet, and then select the Objects check box.


Locking objects or text in objects has no effect unless the sheet is protected. To protect a sheet, point to Protection on the Tools menu, click Protect Sheet, and then select the Objects check box.


Specifies how objects are sorted and sized in relation to adjacent cells.


For a graphic object on a chart, ensures that the object will move with and resize with the chart.

For a graphic object on a worksheet, ensures that the object will move with and resize with its underlying cells. Use this option if you want to sort graphic objects with the underlying cells. The objects can be no taller than the row or no wider than the column you want to sort.


Ensures that a graphic object will move, but not resize, with its underlying cells.


Maintains the position and size of a graphic object on your worksheet.


Prints selected graphic objects when you print a worksheet.


Changes the color, brightness, and contrast of the selected picture object.


Specify options for moving and sizing the selected object in relation to adjacent cells.


Function box

Displays the most recently used worksheet function. Click the arrow to the right of the function box to view other available worksheet functions. If you do not see the function you need, click More Functions at the bottom of the list to display the Paste Function dialog box, which contains all available worksheet functions.


Cancel formula

Cancels the formula entry, closes the Formula Palette, and returns you to the active cell.


Enter formula

Enters the formula displayed in the formula bar into the active cell on your worksheet. The cell references, values, and expected result of the formula you enter are displayed in the Formula Palette.


Displays the Formula Palette to assist you in building a formula with worksheet functions.

The Formula Palette displays the name of the selected function and each of its arguments, describes the function and each argument, and gives the current result of both the function and the entire formula. You can edit functions in a formula by clicking the function name in the formula bar and then changing the arguments in the edit boxes.

For more information about the selected function, click  [image]  in the lower-left corner of this dialog box. When the Office Assistant appears, click Help with this wizard, and then click Help on selected function.


Enter the cell reference or name to identify the cell that contains the formula you want to find a solution for. The Collapse Dialog button at the right end of this box temporarily moves the dialog box so that you enter the range by selecting cells in the worksheet. When you finish, you can click the button again to display the entire dialog box.


Type a number to specify the new value or target value you want to solve for.


Enter a reference to the cell that contains the value you want to adjust during goal seeking. This cell must be referenced directly or indirectly by the formula in the cell you specified in the Set cell box. The Collapse Dialog button at the right end of this box temporarily moves the dialog box so that you enter the range by selecting cells in the worksheet. When you finish, you can click the button again to display the entire dialog box.


Click Pause to interrupt the goal-seeking process; click Continue to resume the process.


Click Step to move through the goal-seeking process one step at a time.


Displays the results of the goal-seeking process. Click OK to keep the resulting values on the worksheet. Click Cancel to restore the original values.


Displays the value you entered in the To value edit box.


Displays the value from the Set cell box after the goal-seeking process succeeds or fails to find a solution for the target value.


Selects objects, comments, or cells with special characteristics or entries.


Specifies a cell reference or named range you want to go to.


Select a named range from the active workbook in the Go to box. You can also return to any of the four most recent references from which you used the Go To command.


Click in the Left section, Center section, or Right section box, and then enter the text you want. You can click the appropriate button to insert a page number, date, time, file name, or sheet name in your header or footer.

To format text, select the text, and then click the Font button  [image]  in this dialog box.


Enter the text you want in the Left section box to display or print the header in the top-left corner of the worksheet or the footer in the bottom-left corner of the worksheet.


Enter the text you want in the Center section box to display or print the header or footer centered at the bottom of the worksheet.


Enter the text you want in the Right section box to display or print the header in the top-right corner of the worksheet or the footer in the bottom-right corner of the worksheet.


Font button

Changes the font, font size, and text style of the selected text in the Left section, Center section, or Right section box.


Page Number button

Inserts page numbers in the header or footer when you print the worksheet. Microsoft Excel updates the page numbers automatically when you add or delete data, or set page breaks.


Total Pages button

Inserts the total number of pages in the active worksheet and adjusts the page numbers automatically when you print the worksheet. For example, if you want to use the format "Page 1 of 12," "Page 2 of 12," and so on, click  [image]  where you want to insert the first page number, and then click  [image]  where you want to insert the total page number.


Date button

Inserts the current date.


Time button

Inserts the current time.


File Name button

Inserts the file name of the active workbook.


Sheet Name button

Inserts the name of the active worksheet.


Select Sheet name to display specific sheet names you want to link to in the destination file.


Select Defined name to display specific defined names that refer to cell ranges you want to link to in the destination file.


Type the cell range you want to link to in the destination file.


Click a sheet name or defined name you want to link to in the destination file.


Select Sheet name to display specific sheet names you want to link to in the destination file.


Select options under Browse from to look for a specific sheet name, cell or range reference, or defined name within the destination file you want to specify a hyperlink to. For information about specifying locations in other types of Office files, see Help for the Office program used to create the file.


In the Choose list, select the worksheet or item you want to publish. To update data previously saved by Microsoft Excel, select Previously published items in the Choose list, and then select the worksheet or item you want to republish.


Select the worksheet or item you want to republish.


Removes the selected worksheet or item from the Previously published items list.


Select the range of cells you want to publish.


Select the worksheet, items on a worksheet, or range of cells you want to publish.


Select to let users change data or rearrange the way they view data in their Web browser, and then enter the type of interactivity you want — Spreadsheet functionality, PivotTable functionality, or Chart functionality — in the Add interactivity with list.

Clear this check box if you want users to only view the data. Data in noninteractive format is similar to putting a snapshot of your data on the Web.


Describes the type of interactivity you've chosen for the item you're publishing.


Click Change to create or change a title for your Web page. The title you create or change appears centered above each item or worksheet on the Web page after the item or worksheet is published. If you do not add a title, no title appears unless you publish to an existing file that already has a title.


Creates or changes the title for your Web page.


In the File name box, enter a path and file name to specify a location for your Web page.


Click to search for a location for your Web page on your computer or network.


Select if you want to view your Web page in a Web browser after you publish it.


Makes a copy of the item you selected in the Choose box and saves it as an HTML file on the location you specified.


Click Esc to return to the initial Help for Lotus 1-2-3 Users dialog box or to a previous step.


Enter the requested additional information in the dialog box that appears at the top of the screen to continue the demonstration.

Use the arrow keys to select a cell range. To anchor a range, click the cell that you want to specify as the upper-left corner of the range, press PERIOD, and then use the arrow keys to select the cells in the range.


Click an item in the Menu box to get information about Lotus 1-2-3 menus and command items. The box to the right of the Menu box displays information about the selected item. Press ESC to go back one screen.


Displays information about the Lotus 1-2-3 command selected in the Menu box.


Click Instructions under Help options to display the instructions for performing the equivalent of a Lotus 1-2-3 command on your worksheet. Click Demo to see a demonstration of the equivalent action in Microsoft Excel.


Click Faster or Slower under Help options to change the speed of demonstrations of Microsoft Excel equivalents for Lotus 1-2-3 menu items. The fastest speed is 5, and the slowest speed is 1.


Click Help for more information about using Microsoft Excel with Lotus 1-2-3 files.


Lists the subcommands of the Lotus 1-2-3 command selected in the Menu box, or states that a demonstration is available for the selected command.


Adds the cell or range of cells that contain label names to the Existing label ranges box.


Removes the cell or range of cells that contain label names from the Existing label ranges box. Removing label ranges from the Existing label ranges box does not remove the labels from the worksheet.


Select the cells on the worksheet that refer to the labels you want to use in your formula. The Collapse Dialog button at the right end of this box temporarily moves the dialog box so that you enter the cell or range of cells by selecting cells on the worksheet. When you finish, you can click the button again to display the entire dialog box.


Specify cells or cell ranges on your worksheet that contain label names you want to use in formulas. Label names can be used as row or column labels.


Click Row labels to add label names as row labels. The cell range you enter in the Add label range box can be only one column wide.


Click Column labels to add label names as column labels.


Displays the label ranges you have added. To remove an existing label range name from the list, select the range in the box, and click Remove. Removing label ranges from the Existing label ranges box does not remove the labels from the worksheet.


Updates data for the selected link when you open the container file and every time the source file changes. Automatic is unavailable if the link is locked.


Updates data for the selected link when you click Update Now. If the link is locked, Manual is unavailable.


Lists the names and locations of the files your workbook is linked to.


Indicates whether the link is updated manually or automatically and whether it is locked.


Specify a different source file for a selected link. Click Change Source, and then select the options you want in the Change Source dialog box.


Updates all of the links selected in the Links dialog box.


Opens the selected file your workbook is linked to.


Displays the name of the application or type of application or object your workbook is linked to.


Displays the range name of the linked item.


Closes this dialog box, and saves any changes.


Displays the macro name of the macro you want to set options for.


Type the macro name in the Macro name box, or use the default name given by Microsoft Excel to assign a name to the new macro.


Type a letter in the Shortcut key box to assign shortcut keys to the selected macro. The resulting shortcut keys are CTRL+ the letter you type. If you hold down SHIFT while you type the letter in the Shortcut key box, the resulting shortcut keys are CTRL+SHIFT+ the letter you type.


If you want a macro to be available whenever you use Microsoft Excel, click Personal Macro Workbook to store the new macro in your Personal Macro Workbook.

Click New Workbook to store the new macro in a new workbook.

Click This Workbook to store the new macro in the active workbook.


Type text in the Description box to add or edit descriptive information about the selected macro. This information may include any information that might help users decide how to use the macro.


Click a macro name in the Macro name box to specify which macro you want to run, modify, delete, or set options for. Type a macro name in the box to create a new macro.


Specifies the location of the macro you want to create, run, modify, delete, or set options for. If you want a macro to be available whenever you use Microsoft Excel, store the macro in the Personal Macro Workbook.


Displays descriptive information about the selected macro. Click Options to add to or edit the description of the selected macro.


Runs the selected macro. If a macro takes arguments, you cannot run it from the Macro dialog box. To run macros that require you to supply arguments, use the Visual Basic Editor command (Tools menu, Macro submenu).


Runs the selected macro one line of code at a time.


Opens the selected macro in the Visual Basic Editor.


Opens a new module in the Visual Basic Editor so that you can create a new macro. The Create button is only available if you have entered a new name in the Macro name box.


Deletes the selected macro.


Assigns the selected macro to a shortcut key. You can also add to or edit the description of the selected macro.


New/Edit button
New opens the Microsoft Visual Basic Editor so that you can create a new macro. Edit opens the selected macro in the Visual Basic Editor.


Record button
Records a new macro.


Select a workbook in the Merge styles from box to specify the workbook from which you want to copy styles. You must have that workbook open.


Moves or copies the selected sheets to another workbook or to a different location in the same workbook.


Click the open workbook to which you want to move or copy the selected sheets. Click New Book to create a workbook that contains only the moved or copied sheets.


Click the sheet name that you want the moved or copied sheets placed in front of. Click Move to End to place the sheet at the end of the sheets in the open workbook displayed in the To book box.


Copies the selected sheets and leaves the originals in place.


Indicates that the formula or worksheet you are moving or copying contains a defined name that already exists in the destination workbook.


Displays the defined name in the formula or worksheet you are moving or copying that conflicts with the name in the destination workbook.


Type a new name to replace the conflicting defined name. If you choose not to rename the conflicting name, click Cancel to return to the message.


Distinguishes between half-width and full-width characters
Distinguishes between half-width and full-width characters.


Enter the information you want to search for. You can use a question mark (?) to match any single character or an asterisk (*) to match any string of characters. For example, sm?th finds "smith" and "symth" and *east finds "Northeast" and "Southeast."


Type the replacement characters you want to use to replace the characters in the Find what box. To delete the characters in the Find what box from your document, leave the Replace with box blank.


Click the direction you want to search: down through columns by using By columns or to the right across rows by using By rows. To search up in columns or to the left across rows, hold down SHIFT and click Find Next. In most cases, it is faster to select By columns.


Click the worksheet element that contains the information you want to search for.


Distinguishes between uppercase and lowercase characters.


Searches for the next occurrence of the characters specified in the Find what box. To find the previous occurrence, hold down SHIFT and click Find Next.


Closes the Find or Replace dialog box when you've completed your search.


Replaces the selected occurrence of the criteria in the Find what box, finds the next occurrence, and then stops. If you want to automatically replace all occurrences of the search criteria in your document, click Replace All.


Replaces all occurrences of the search criteria in your document. If you want to review and selectively replace each occurrence, click Replace instead of Replace All.


Searches for an exact and complete match of characters specified in the Find what box.


Notifies you when the workbook becomes available for you to modify and save changes to. The workbook will open as read-only. If you make changes to the read-only version of the workbook, you will be asked to discard your changes and open the newest version of the workbook, or save changes to a different name and compare workbook versions with the newest version of the available workbook.


Displays the workbook name and the name of the person who is currently making changes to the workbook.


Click Read Only to open the file as read-only. If you open the workbook as read-only, changes you make to this workbook cannot be saved, unless you save the workbook with a different name. Click Notify and you will be alerted when the workbook becomes available for you to modify and save changes to.


Displays the type of object — for example, a Microsoft Word document — that you have selected or that you want to convert or start.


Converts the selected embedded object to the program format or type of information selected in the box. Use this option to change the file format of the embedded object so that you can open it in the programs you use.


Opens or activates the embedded object for editing.


Click a program or object type in the box to convert the selected object to another object type. The embedded object opens for editing in the source program for the object type you've selected.


Displays the embedded object as an icon. Use this option if you do not want the data from the object to be displayed in your file.


Select the icon you want to use to represent the linked or embedded object in your file.


Type the caption, such as the file name, you want to appear under the linked or embedded object icon in your file.


Displays the location and file name of the icon you want to use to represent the linked or embedded object.


Click Browse to locate files that contain icons you want to use to represent linked or embedded objects.


Select the type of object you want to insert into your file in the Object type box; the Result box describes the result of the selected object. If the object type does not appear in this box, you may need to run the Office Setup program to install the source program.


Click Browse to locate the file that you want to link to or insert as an embedded object.


Creates a link to the selected file rather than embedding it.


Type the name of the file that you want to link to or insert as an embedded object, or click Browse to locate the file.


Displays the icon that represents the embedded object in your file. Click Change Icon to change the icon image and descriptive text.


Inserts or embeds the Clipboard contents at the insertion point in the format specified in the As box. When you select this option, the Clipboard contents are pasted or embedded, but no link is created.

Select the Paste link check box to link the pasted data to its source document.


Specifies the type of information you want to paste from the Clipboard.


Displays the Clipboard contents as an icon. Use this option if you do not want linked data to be displayed in your file.


Displays the icon that represents the embedded object in your file. Click Change Icon to change the icon image and descriptive text.


Click Change Icon to change the icon that represents an embedded object, and then select the options you want in the Change Icon dialog box.


Displays the name of the source data and its location. If you copied the data from an application that did not provide the source data and its location to the Clipboard, the source is identified as "Unknown."


Describes the results of selected options.


Applies built-in cell styles when you create an outline. Microsoft Excel applies the built-in styles RowLevel_1, ColLevel_1, and so on, to the various levels of summary data. Styles are applied to all summary rows and columns.


Specifies where the rows or columns that contain the summary data appear in relation to the detail rows or columns in the data to be outlined.


Specifies where the summary rows are in relation to the detail rows in the data to be outlined.


Specifies where the summary columns are in relation to the detail columns in the data to be outlined.


Creates an outline of the selected data based on the formulas on the worksheet and the settings in this dialog box.


Applies the built-in cell styles RowLevel_1, ColLevel_1, and so on, to the various summary levels of an outline that already exists.


Lists the prompt text for the different parameters established for this query. Select a parameter to edit.


Click this option to display a prompt with text that you specify whenever you refresh the data. Enter the prompt text string in the box to display your customized prompt, or leave the box blank to display the default prompt when you run the query.


Enter the value that you want to use for this parameter. This option lets you set the parameter, instead of prompting you for a parameter value each time you run the query.


Enter the cell reference for the value that you want to use for this parameter. This option lets you set the parameter, instead of prompting you for a parameter value each time you run the query. To edit this value when you refresh the query in the future, change the value in the cell. The query will use the current contents of the cell each time you refresh the query.


Select to automatically refresh the external data range when the cell value specified in the Get the value from the following cell box changes.


Type the password to gain access to the worksheet or workbook. Passwords are case sensitive. You must type uppercase and lowercase letters correctly when you enter the password.


Displays the function you selected.


The function you selected produces different results that are determined by the arguments you choose. Select the set of arguments in the Arguments box, based on the results you want. For more information about the function arguments, click  [image]  at the bottom of this dialog box.


Select a function category in the Function category box below. The function names grouped by category will then appear in the Function name box to the right. If you can't find a specific function, select All in the Function category box, and all available functions will appear in the Function name box.


Click a function name in the Function name box to see the function arguments and a description of the function. Double-click a function name to display the function and its arguments in the Formula Palette. As you create a formula, the Formula Palette will assist you.


Displays the formula and its arguments for the formula name you select in the Function name box.


Describes the calculations or results of the formula you select in the Function name box.


Pastes all names defined in your workbook, starting at the active cell.

On a worksheet, the list of names is an area two columns wide. The left column lists names; the right column lists the cell references, formulas, or constants to which the names refer.


Double-click the name in the Paste name box to paste into the formula bar a name from the list of all names defined in the active workbook.


Links the pasted data to the active worksheet.


Click the attribute of the copied data you want to paste.


Pastes all cell contents and formatting. This option is the same as using the Paste command on the Edit menu.


Pastes only the formulas as entered in the formula bar.


Pastes only the values as displayed in the cells.


Pastes only cell formatting.


Pastes only comments attached to the cell.


Pastes all cell contents and formatting applied to the copied cell except borders.


Specifies which mathematical operation, if any, you want to apply to the copied data.


Avoids replacing values in your paste area when blank cells occur in the copy area.


Changes columns of copied data to rows, and vice versa.


Pastes data validation rules for the copied cells to the paste area.


Pastes the width of one column to another column.


Applies the current settings to the active chart without closing the dialog box, so you can see the effects of your changes in the sample chart.


Returns all settings in the dialog box to the original default settings without closing the dialog box, so you can see the effects of your changes.


The sample chart displayed in the dialog box shows the result of the current settings.


Increases the elevation of the view in increments of 5 degrees. For all charts except pie charts and 3-D bar charts, the view ranges from -90 degrees (view from directly below the plot area) to 90 degrees (view from directly above the plot area). For pie charts, the view ranges from 10 degrees to 80 degrees. For 3-D bar charts, the view ranges from 0 (zero) degrees to 44 degrees.


Decreases the elevation of the view in increments of 5 degrees. For most chart types, the view ranges from -90 degrees (view from directly below the plot area) to 90 degrees (view from directly above the plot area).


Type a value in the Elevation box to specify the height you want to view the chart from. For most chart types, the view ranges from -90 degrees (view from directly below the plot area) to 90 degrees (view from directly above the plot area).


Increases the Perspective setting in increments of 5 degrees, thereby increasing the depth of the chart. The perspective value specifies the ratio of the front of the chart to the back of the chart; it ranges from 0 (zero) degrees to 100 degrees. This option is unavailable for 3-D bar charts or when the Right angle axes check box is selected.


Decreases the Perspective setting in increments of 5 degrees, thereby decreasing the depth of the chart. The perspective value specifies the ratio of the front of the chart to the back of the chart; it ranges from 0 (zero) degrees to 100 degrees. This option is unavailable for 3-D bar charts and when the Right angle axes check box is selected.


Type a value (in degrees) in the Perspective box to control the view of chart depth. The perspective value specifies the ratio of the front of the chart to the back of the chart; it ranges from 0 (zero) degrees to 100 degrees. This option is unavailable for 3-D bar charts or when the Right angle axes check box is selected.


Type a value in the Rotation box to control the rotation of the plot area around the z axis (vertical axis). Rotation is measured in degrees, from 0 to 360. For 3-D bar charts, the rotation ranges from 0 (zero) degrees to 44 degrees.


Rotates the plot area to the left around the z axis (vertical axis) in increments of 10 degrees. The rotation is measured in degrees from 0 (zero) to 360. For 3-D bar charts, the rotation ranges from 0 (zero) degrees to 44 degrees.


Rotates the plot area to the right around the z axis (vertical axis) in increments of 10 degrees. The rotation is measured in degrees, from 0 (zero) to 360. For 3-D bar charts, the rotation ranges from 0 (zero) degrees to 44 degrees.


Sets the axes at right angles independent of chart rotation or elevation. To see axes in perspective, clear this check box. For 3-D bar charts, this option is always selected.


Type a value in the Height box to control the height of the z axis and the chart walls relative to the length of the x axis or the width of the chart at its base. The height is measured as a percentage of the x axis length. For example, a value of 200 percent makes the chart height twice the length of the x axis.


Scales a 3-D chart so that it's closer in size to the 2-D version. When you change a 2-D chart to a 3-D chart, Microsoft Excel sometimes draws the chart smaller, especially if it has a rotation of less than 45 degrees. This option is available only when the Right angle axes check box is selected.


Close button (3-D View)
The Close button closes this dialog box.


Reduces or enlarges the printed worksheet. Select the Adjust to check box, and then enter a percentage number in the % normal size box. You can reduce the worksheet to 10 percent of normal size or enlarge it to 400 percent of normal size.


Reduces the worksheet or selection when you print so that it fits on the specified number of pages. Select the Fit to check box, enter a number in the page(s) wide by box, and enter a number in the tall box. To fill the paper width and use as many pages as necessary, type 1 in the pages(s) wide by box and leave the tall box blank.


Click Letter, Legal, or other size options to indicate the size you want your document or envelope printed.


Click the resolution you want to specify print quality for the active worksheet. Resolution is the number of dots per linear inch (dpi) that appear on the printed page. Higher resolution produces better quality printing in printers that support high-resolution printing.


Enter Auto to start numbering pages at "1" (if it is the first page of the print job) or at the next sequential number (if it is not the first page of the print job). Enter a number to specify a starting page number other than "1."


Specifies the orientation for the printed page.


Reduces or enlarges the worksheet, or fits the worksheet to a specific number of pages when you print.


Enter margin settings and see results in the Preview box. Adjust measurements in the Top, Bottom, Left, and Right boxes to specify the distance between your data and the edge of the printed page.


Enter a number in the Header or Footer box to adjust the distance between the header and the top of the page or between the footer and the bottom of the page. The distance should be smaller than the margin settings to prevent the header or footer from overlapping the data.


Center the data on the page within the margins by selecting the Vertically check box, the Horizontally check box, or both.


Shows how your printout will look with the selected options.


Click a built-in header in the Header box, and then click Custom Header to create a custom header for your worksheet. The built-in header is copied to the Header dialog box, where you can format or edit the selected header.


Click a built-in footer in the Footer box, and then click Custom Footer to create a custom footer for your worksheet. The built-in footer is copied to the Footer dialog box, where you can format or edit the selected footer.


Click the Print area box to select a worksheet range to print, and then drag through the worksheet areas that you want to print. The Collapse Dialog button at the right end of this box temporarily moves the dialog box so that you enter the range by selecting cells in the worksheet. When you finish, you can click the button again to display the entire dialog box.


Select an option under Print titles to print the same columns or rows as titles on every page of a printed worksheet. Select Rows to repeat at top if you want specific rows as your horizontal title for each page. Select Columns to repeat at left if you want vertical titles on each page. Then on the worksheet, select a cell or cells in the title columns or rows you want. The Collapse Dialog button at the right end of this box temporarily moves the dialog box so that you enter the range by selecting cells in the worksheet. When you finish, you can click the button again to display the entire dialog box.


Select the Gridlines check box to print horizontal and vertical cell gridlines on worksheets.


Select the Black and white check box if you formatted data with colors but are printing on a black-and-white printer. If you are using a color printer, selecting this option may reduce printing time.


Select the At end of sheet option to print comments beginning on a separate page at the end of the document. Select the As displayed on sheet option to print comments where they are displayed when you view them on the worksheet.

If you click As displayed on sheet, Microsoft Excel will print only the comments that are displayed. To display all comments, click Comments on the View menu. To display an individual comment, right-click the cell that contains the comment, and then click Show Comment on the shortcut menu.


Select the Row and column headings check box to print row numbers and column letters in the A1 reference style or numbered rows and columns in the R1C1 reference style.


Select the Draft quality check box to reduce printing time. When this option is selected, Microsoft Excel does not print gridlines and most graphics.


Click Down, then over or Over, then down to control the order in which data is numbered and printed when it does not fit on one page. The sample picture previews the direction your document will print when you choose one of these options.


Specifies what is printed from your worksheet, whether printout is in color or black and white, and what the print quality is.


Select one of these options to specify the size of your chart when printed.


Scales the chart sheet on the screen to a size you've specified.


Expands the chart to the nearest page margin before printing. The chart expands in both dimensions (width and height) proportionally until one dimension fills the space between the margins.


Expands the chart to fit the full width and height of the page margins. The size of chart objects relative to one another may change on the printed page, because the proportions of the chart are changed to fill the page.


Specifies what the print quality is and whether the printout is in color or in black and white.


Suppresses the printing of graphics and cell gridlines. This option reduces printing time; it also increases memory efficiency for plotters. Select this option when low memory causes printing problems.


Select the Print in black and white check box to print your chart data series in black and white (patterns replace colors). On a color printer, other areas of the chart (for example, the plot area) are still printed in color. Clear the Print in black and white check box to print colors as shades of gray on a black-and-white printer and as colors on a color printer.


Shows how your chart will look when printed with the selected options.


Click Print to select additional options and print your document.


Click Print Preview to display each page as it will look when printed.


Click Options to set options specific to your selected printer. For more information, see your printer documentation.


Double-click the sheet name in the box to display hidden sheets.


Shows how your document will look with the selected options.


Select a printer. The information that appears below the Printer box applies to the selected printer.


Click Properties to change the options for the selected printer. The settings you specify apply to the active document, and they may also affect print settings in other applications you use.


Displays the Print To File dialog box when you click OK. Prints your document to a file instead of to a printer.


Identifies the selected printer.


Describes the status of the selected printer, for example, busy or idle.


Identifies the location of your printer if you are connected to a network printer or the port on your computer if you are connected to a local printer.


Indicates the portion of the document you want to print.


Prints only the cells and objects selected on the worksheet.


Prints each of the selected sheets. Each sheet in the workbook starts on a new page. If a sheet has a print area, only the print area is printed. If a chart object is selected, this option changes to Selected chart.


Prints all sheets in the active workbook that contain any data. If a sheet has a print area, only the print area is printed.


Indicates the portion of the document you want to print.


Indicates the pages of the document you want to print. If you click Pages, you must also enter the page numbers you want.


Prints the entire document.


Prints only the pages you specify.


Enter the starting page number of the page range you want to print.


Enter the ending page number of the page range you want to print.


Specifies the number of copies you want to print.


Organizes numbered pages when you print multiple copies of a document. A complete copy of the document is printed before the first page of the next copy is printed.


In an outlined worksheet, removes selected rows or columns from a group.

In a PivotTable report, separates each instance of a group into the items contained in the group; for example, it separates quarters into the original individual dates.


Type a password to prevent unauthorized users from removing sheet protection. A password is case sensitive, can be up to 255 characters long, and can contain any combination of letters, numbers, and symbols.


Prevents changes to cells on worksheets, and prevents changes to items in charts.


Prevents others from deleting, moving, editing, or resizing graphic objects on a worksheet or chart sheet.


Prevents changes to window size and placement.


Prevents changes to the definitions of scenarios on a worksheet.


Type the password to turn off password protection of your worksheet, workbook, or shared workbook. When you remove protection from a shared workbook, you remove the workbook from shared use and erase the change history information.

Passwords are case sensitive. You must type the password exactly as you want users to enter it, including uppercase and lowercase letters.


Type a password to prevent unauthorized users from removing workbook protection. A password is case-sensitive, can be up to 255 characters long, and can contain any combination of letters, numbers, and symbols.


Protects the sharing and change history tracking in a shared workbook so that they cannot be turned off. If the workbook is not a shared workbook when you select this check box and click OK, you are asked whether you want to save the workbook as a shared workbook. In a workbook that is already shared, you can turn on protection for sharing and the change history, but you cannot assign a password for this protection. To assign a password, you must first remove the workbook from shared use.


default startup workbook

The new, unsaved workbook that's displayed when you start Microsoft Excel. The default startup workbook is displayed only if you haven't included other workbooks in the Xlstart folder. The Xlstart folder is in Root\OS\Profiles\User_name\Application Data\Microsoft\Excel, where Root is a server location or a folder on a drive from which all other folders branch (for example, C:\), OS is the operating system folder (for example, Windows or Winnt), and User_name is your user name; or the Xlstart folder is in Root\Program Files\Microsoft Office\Office.

If you've created a template named Book.xlt and saved it in the Xlstart folder or the alternate startup folder, Microsoft Excel uses the template to create the new default workbook when you start Microsoft Excel, click the New button on the Standard toolbar, or select the Workbook template in the New dialog box (File menu).


active sheet

The sheet that you're working on in a workbook. The name on the tab of the active sheet is bold.


array

Used to build single formulas that produce multiple results or that operate on a group of arguments that are arranged in rows and columns. Microsoft Excel has two types of arrays: array ranges and array constants. An array range is a rectangular area of cells that share a common formula; an array constant is a specially arranged group of constants that's used as an argument in a formula.


paste area

The target destination for data that's been cut or copied by using the Clipboard.


pane

Used to view different areas of a large worksheet at the same time. You can split a window into two panes either horizontally or vertically. If you split the window both vertically and horizontally, you can display four panes.


view

A set of display and print settings that you can name and apply to a workbook. You can create more than one view of the same workbook without saving separate copies of the workbook.


constraints

Limitations placed on a Solver problem. You can apply constraints to adjustable (changing) cells, the target cell, or other cells that are directly or indirectly related to the target cell. For linear problems, there is no limit on the number of constraints. For nonlinear problems, each adjustable cell can have the following constraints: a binary constraint; an integer constraint plus upper, lower, or both limits; upper, lower, or both limits; and you can specify an upper or lower limit for up to 100 other cells.

The following operators can be used in constraints.

Operator	Meaning
<=	Less than or equal to
>=	Greater than or equal to
=	Equal to
int	Integer (applies only to adjustable cells)
bin	Binary (applies only to adjustable cells)


regression analysis

A form of statistical analysis that is used for forecasting. Regression analysis estimates the relationship between variables, so that a given variable can be predicted from one or more other variables.


moving average

A sequence of averages that are computed from the parts of a data series. In a chart, a moving average smoothes the fluctuations in data, thus showing the pattern or trend more clearly.


fill handle

The small black square in the corner of the selection. When you point to the fill handle, the pointer changes to a black cross. To copy contents to adjacent cells or to fill in a series such as dates, drag the fill handle.

To display a shortcut menu that contains fill options, hold down the right mouse button as you drag the fill handle.


constant

A numeric or text value that you type directly into a cell or formula, or that is represented by a name. For example, the date 10/9/96, the number 210, and the text "Quarterly Earnings" are all constants. A formula or a value that results from a formula is not a constant.


worksheet

The primary document that you use in Microsoft Excel to store and work with data. Also called a spreadsheet. A worksheet consists of cells that are organized into columns and rows; a worksheet is always stored in a workbook.


module

A container that stores a set of Microsoft Visual Basic procedures, which are known as macros in Microsoft Excel. Macros that you write or record can perform common tasks such as opening a workbook automatically, selecting a cell or range, entering text, formatting data, or creating a chart.


formula

A sequence of values, cell references, names, functions, or operators in a cell that together produce a new value. A formula always begins with an equal sign (=).


alternate startup folder

A folder in addition to the Xlstart folder that contains workbooks or other files that you want opened automatically when you start Microsoft Excel. The alternate startup folder can be a location on a shared network drive. Templates placed in this folder are available in the New dialog box (File menu). To specify an alternate startup folder, click Options on the Tools menu, and then click the General tab.


template

A workbook that you create and then use as the basis for other similar workbooks. You can create templates for workbooks and worksheets.

The default template for workbooks is called Book.xlt. The default template for worksheets is called Sheet.xlt.


default workbook template

The Book.xlt template that you create when you want to change the default format of new blank workbooks. Microsoft Excel uses the template to create the blank workbook that opens when you start Microsoft Excel, or when you click the New button on the Standard toolbar, or when you select the Workbook template in the New dialog box (File menu). Unless you create the Book.xlt template, Microsoft Excel bases the new blank workbook on built-in program settings. You must store the Book.xlt template in the Xlstart folder or in the alternate startup folder.

The Xlstart folder is in Root\OS\Profiles\User_name\Application Data\Microsoft\Excel, where Root is a server location or a folder on a drive from which all other folders branch (for example, C:\), OS is the operating system folder (for example, Windows or Winnt), and User_name is your user name. Or the XLstart folder is in Root\Program Files\Microsoft Office\Office.


default sheet template

The Sheet.xlt template that you create when you want to change the default format of new blank worksheets. Microsoft Excel uses the template to create the blank worksheet that you insert when you click Worksheet on the Insert menu. Unless you create the Sheet.xlt template, Microsoft Excel bases the new worksheets on built-in program settings. You must store the Sheet.xlt template in the XLStart folder or in the alternate startup folder.

The Xlstart folder is in Root\OS\Profiles\User_name\Application Data\Microsoft\Excel, where Root is a server location or a folder on a drive from which all other folders branch (for example, C:\), OS is the operating system folder (for example, Windows or Winnt), and User_name is your user name. Or the XLstart folder is in Root\Program Files\Microsoft Office\Office.


autotemplate

Workbooks that you save as templates in your Xlstart startup or alternate startup folder by using specific file names, such as Book.xlt, Sheet.xlt, Dialog.xlt, and Macro.xlt. You can use autotemplates as the basis for all the new workbooks and sheets that you insert in workbooks.

The Xlstart folder is in Root\OS\Profiles\User_name\Application Data\Microsoft\Excel, where Root is a server location or a folder on a drive from which all other folders branch (for example, C:\), OS is the operating system folder (for example, Windows or Winnt), and User_name is your user name. Or the XLstart folder is in Root\Program Files\Microsoft Office\Office.


Microsoft Excel add-in

Components that can be installed on your computer to add commands and functions to Excel. These add-in programs are specific to Excel. Other add-in programs that are available for Excel or Microsoft Office are Component Object Model (COM) add-ins.


standard font

The default text font for worksheets. The standard font determines the default font for the Normal cell style.


iteration

The repeated calculation of a worksheet until a specific numeric condition is met.


input cell

A cell in which a list of input values from a data table is substituted. Any cell on the worksheet can be used for the input cell. Although the input cell does not need to be part of the data table, the formulas in data tables must refer to the input cell.


cell reference

The set of coordinates that a cell occupies on a worksheet. For example, the reference of the cell that appears at the intersection of column B and row 3 is B3.


range

Two or more cells on a sheet. The cells in a range can be adjacent or nonadjacent.


select

To highlight a cell or range of cells on a worksheet. The selected cells will be affected by the next command or action.


scroll lock

With scroll lock turned on, the arrow keys scroll the active sheet rather than make a different cell active. To turn scroll lock off or on, press the SCROLL LOCK key.


data region

A range of cells that contains data and that is bounded by empty cells or worksheet borders.


activate

To make a chart sheet or worksheet the active, or selected, sheet. The sheet that you activate determines which menu bar and toolbars are displayed. To activate a sheet, click the tab for the sheet in the workbook.


data marker

A bar, area, dot, slice, or other symbol in a chart that represents a single data point or value that originates from a worksheet cell. Related data markers in a chart constitute a data series.


data label

A label that provides additional information about a data marker, which represents a single data point or value that originates from a worksheet cell. Data labels can be applied to a single data marker, an entire data series, or all data markers in a chart. Depending on the chart type, data labels can show values, names of data series or categories, percentages, or a combination of these.


data series

A group of related data points that are plotted in a chart. Each data series in a chart has a unique color or pattern and is represented in the chart legend. You can plot one or more data series in a chart. Pie charts have only one data series.


data points

Individual values that are plotted in a chart. Groups of related data points make up a data series. Data points are represented by bars, columns, lines, pie or doughnut slices, dots, and various other shapes. These shapes are called data markers.


3-D walls and floor

The areas surrounding many 3-D chart types that give dimension and boundaries to the chart. Two walls and one floor are displayed within the plot area.


trendline

A graphical representation of the trend, or direction, of data in a series. Trendlines are used for the study of problems of prediction, also called regression analysis. You can add trendlines to data series in unstacked 2-D area, bar, column, line, stock, xy (scatter), and bubble charts.


trendline label

Optional text for a trendline, including either the regression equation or the R-squared value, or both. A trendline label can be formatted and moved; it cannot be sized.


what-if analysis

A process of changing the values in cells to see how those changed values affect the outcome of formulas on the worksheet. For example, varying the interest rate that is used in an amortization table to determine the amount of the payments is a form of what-if analysis.


error bars

Graphic bars that express potential error (or degree of uncertainty) relative to each data marker in a series. You can add y error bars to data series in 2-D area, bar, column, line, xy (scatter), and bubble charts. Bubble and xy charts can also display x error bars. You can select error bars and format them as a group.


legend

A box that identifies the patterns or colors that are assigned to the data series or categories in a chart.


gridlines in charts

Lines that you can add to a chart to make it easier to view and evaluate data. Gridlines extend from the tick marks on an axis across the plot area.


tick marks and tick-mark labels

Tick marks are small lines of measurement, similar to divisions on a ruler, that intersect an axis. Tick-mark labels identify the categories, values, or series in the chart. Tick-mark labels come from the cells on the worksheet used to create the chart.


axis

A line that borders one side of the plot area, providing a frame of reference for measurement or comparison in a chart. For most charts, data values are plotted along the value axis, which is usually vertical (the y-axis), and categories are plotted along the category axis, which is usually horizontal (the x-axis).


text box

A rectangular object on a sheet or chart, in which you can type text.


group

In an outline or PivotTable report, one or more detail rows or columns that are adjacent and subordinate to a summary row or column.


detail data

For automatic subtotals and worksheet outlines, the subtotal rows or columns that are totaled by summary data. Detail data is typically adjacent to and either above or to the left of the summary data.


absolute reference

In a formula, the exact address of a cell, regardless of the position of the cell that contains the formula. An absolute cell reference takes the form $A$1, $B$1, and so on. Some cell references are mixed. An absolute row reference takes the form A$1, B$1 and so on. An absolute column reference takes the form $A1, $B1, and so on. Unlike relative references, absolute references don't automatically adjust when you copy formulas across rows and down columns.


relative reference

A cell reference, such as A1, that's used in a formula that changes when the formula is copied to another cell or range. After the formula is copied and pasted, the relative reference in the new formula is changed to refer to a different cell that is the same number of rows and columns away from the formula as the original relative cell reference is to the original formula. For example, if cell A3 contains the formula =A1+A2 and you copy cell A3 to cell B3, the formula in cell B3 becomes =B1+B2.


password

A word, phrase, or string of characters that must be entered to gain access to a protected cell, graphic object, sheet, workbook, folder, or file. In Microsoft Excel, a password can be up to 255 characters long and can contain any combination of letters, numbers, spaces, and symbols. As you type the password, Microsoft Excel displays an asterisk (*) for each character that you type. Because passwords are case-sensitive, you must type uppercase and lowercase letters correctly when you set and enter passwords.


list

A series of worksheet rows that contain related data, such as an invoice database or a set of client names and phone numbers. A list can be used as a database, in which rows are records and columns are fields. The first row of the list has labels for the columns.


custom sort order

A nonalphabetic, nonnumeric sort order, such as Sunday, Monday, Tuesday; or Low, Medium, High. You can use one of the custom sort orders that comes with Microsoft Excel, or you can create your own sort order by using the Custom Lists tab in the Options dialog box (Tools menu).


comparison criteria

A set of search conditions that is used to find data. Comparison criteria can be a series of characters that you want to match, such as "Northwind Traders," or an expression, such as ">300."


comparison operator

A sign that is used in comparison criteria to compare two values. The following table shows the six standard comparison operators.

Operator	Meaning
=	Equal to
>	Greater than
<	Less than
>=	Greater than or equal to
<=	Less than or equal to
<>	Not equal to
Custom AutoFilter also provides the following comparison operators that are useful, for example, to filter text: begins with, does not begin with, ends with, does not end with, contains, and does not contain.


criteria range

A cell range that contains a set of search conditions that you can use with the Advanced Filter command (Data menu, Filter submenu) to filter data in a list. A criteria range consists of one row of criteria labels and at least one row that defines the search conditions.


sort order

A way to arrange data based on value or data type. You can sort data alphabetically, numerically, or by date. Sort orders use an ascending (1 to 9, A to Z) or descending (9 to 1, Z to A) order.


summary data

For automatic subtotals and worksheet outlines, all rows or columns that summarize detail data. Summary data usually is adjacent to and below the detail data.


query

In Microsoft Query or Microsoft Access, a means of finding the records that answer a particular question you ask about the data that is stored in a data source.


pivot area

The worksheet area into which you drag PivotTable or PivotChart fields to change the fields from one orientation to another. For example, you can change a PivotTable row field to a column orientation by dragging it to the pivot area for columns. When you click Finish to complete the PivotTable and PivotChart Wizard or click a cell in an existing report, dashed blue outlines indicate the pivot area on the worksheet.

The term "pivot area" also applies to the layout area in the PivotTable and PivotChart Wizard - Layout dialog box, which is available from Step 3 of the PivotTable and PivotChart Wizard.


PivotTable data area label

In a PivotTable report, the cell that identifies the source field for the data area. Usually, the label includes the name of the function that's used to calculate the values of the cells. For example, the data label "Sum of Sales" identifies a data field that's calculated by using the default summary function (Sum) in the Sales field.


row field

A field that's assigned a row orientation in a PivotTable report. Items associated with a row field are displayed as row labels.


column field

A field that's assigned a column orientation in a PivotTable report. Items associated with a column field are displayed as column labels.


legend keys

Symbols in legends that show the patterns and colors assigned to the data series (or categories) in a chart. Legend keys appear to the left of legend entries. Formatting a legend key also formats the data marker associated with it.


data table in charts

A grid that can be added to some charts and contains the numeric data used to create the chart. The data table usually is attached to the category axis of the chart and replaces the tick-mark labels on the category axis.


chart sheet

A sheet in a workbook that contains only a chart. A chart sheet is beneficial when you want to view a chart or a PivotChart report separately from worksheet data or a PivotTable report.


titles in charts

Descriptive text that is automatically aligned to an axis or centered at the top of a chart.


embedded chart

A chart object that is placed on a worksheet and saved with that worksheet when the workbook is saved. Embedded charts are beneficial when you want to view or print a chart or a PivotChart report with its source data or with other information in a worksheet.


plot area

In a 2-D chart, the area that's bounded by the axes and includes all data series. In a 3-D chart, the area that's bounded by the axes and includes the data series, category names, tick-mark labels, and axis titles.


chart area

The entire chart and all its elements.


series lines

In 2-D stacked bar and column charts, lines that connect the data markers in each data series.


drop lines

In line and area charts, lines that extend from a data point to the category (x) axis. Most useful in area charts to clarify where one data marker ends and the next begins.


up-down bars

In line charts with two or more data series, bars that indicate at a glance the difference between the data points in the first and last series. Microsoft Excel automatically uses white bars to show that the point in the last series is greater than the point in the first series, and black bars to show that the point in the last series is smaller than the point in the first series.


high-low lines

In 2-D line charts, lines that extend from the highest to the lowest value in each category.


custom calculation

A method of summarizing the values in selected cells in the data area of a PivotTable report by using the values in other cells in the data area. For example, a % Of Row custom calculation displays the value of each cell as a percentage of the grand total of the row.


summary function

A type of calculation that you direct Microsoft Excel to use when you are combining source data in a PivotTable report or a consolidation table, or when you are inserting automatic subtotals in a list or database. Examples of summary functions include Sum, Count, and Average.


nonadjacent selection

A selection of two or more cells or ranges that don't touch each other. When plotting nonadjacent selections in a chart, make sure that the selections form a rectangular shape.


PivotTable data

In a PivotTable report, the summarized data that's calculated from the data fields of a source list or table.


page field

A field that's assigned to a page orientation in a PivotTable report or PivotChart report. You can either display a summary of all items in a page field, or display one item at a time, which filters out the data for all other items. In PivotTable lists on Web pages, filter fields are the same as page fields in PivotTable reports.


PivotTable report

An interactive table that summarizes and analyzes data from existing lists, tables, and databases. Use the PivotTable and PivotChart Wizard to specify the source data that you want to use. After you create a PivotTable report, you can display and organize the data by dragging the fields and items.


source areas

The cell ranges that you consolidate in the destination area you specify. Source areas can be on any worksheet in a workbook, in other open or closed workbooks, or on Lotus 1-2-3 worksheets.


destination area

The range of cells that you select to hold the summarized data in a consolidation. The destination area can be on the same worksheet as the source data or on a different worksheet. A worksheet can contain only one consolidation.


formula bar

A bar at the top of the Microsoft Excel window that you use to enter or edit values or formulas in cells or charts. Displays the constant value or formula stored in the active cell. To display or hide the formula bar, click Formula Bar on the View menu.


dependents

Cells that contain formulas that refer to other cells. For example, if cell D10 contains the formula =B5, cell D10 is a dependent of cell B5.


precedents

Cells that are referred to by a formula in another cell. For example, if cell D10 contains the formula =B5, cell B5 is a precedent to cell D10.


data source

A stored set of information that identifies the database a user wants to gain access to and includes the information needed to connect to that database. A data source has an identifying name and can include the name and location of the database server, the name of the driver program used to connect to the database, and information the database needs when you log on. Data sources can connect to relational databases (such as Microsoft Access and Microsoft SQL server), On-Line Analytical Processing (OLAP) databases (such as Microsoft SQL Server OLAP Services), text file databases, and lists on Microsoft Excel worksheets.


main document

In a mail-merge operation in Microsoft Word, the document that contains the text and graphics that are the same for each version of the merged document, for example, the return address or salutation in a form letter.


merge field

In a mail-merge operation in Microsoft Word, a placeholder for the information that changes for each version of a merged document. For example, the merge field «PostalCode» indicates where information is inserted from the PostalCode field of the data source.


shortcut menu

A menu that shows the most useful commands for the item that you're working with. Among items for which you can display a shortcut menu are selected rows, columns, and cells; worksheet buttons and text boxes; toolbars; charts and chart items; objects; PivotTable and PivotChart reports; and worksheet tabs.

To display a shortcut menu, right-click an item on the sheet, or press SHIFT+F10.


scenario

A named set of input values that you can substitute in a worksheet model.


source data for PivotTable reports

The list or table that's used to create a PivotTable report. Source data can be a Microsoft Excel list or database, an external data source such as a dBASE or Microsoft Access file, Microsoft Excel worksheet ranges with labeled rows and columns, or another PivotTable report.


data area

The part of a PivotTable report that contains summary data. Values in each cell of the data area represent a summary of data from the source records or rows.


PivotTable subtotal

A row or column that uses a summary function to display the total of detail items in a PivotTable field.


data field

A field from a source list, table, or database that contains data that is summarized in a PivotTable report or PivotChart report. A data field usually contains numeric data, such as statistics or sales amounts, but it can also contain text. Data from a data field is summarized in the data area of a PivotTable or PivotChart report.


item

A subcategory of a PivotTable field or PivotChart field. Items in a PivotTable report or PivotChart report are derived from unique entries in a database field or from unique values in a list column. For example, a field called Month might have items March, April, and so on. In a PivotTable report, items appear as row or column labels, or in the page field lists. In a PivotChart report, items appear as category labels or series names either in the legend or in the page field lists.


PivotTable grand totals

Total values for all cells in a row or all cells in a column of a PivotTable report. Values in a grand total row or column are calculated by using the same summary function used in the data area of the PivotTable report.


field

In a PivotTable report or PivotChart report, a category of data that's derived from a field in a source list, table, or database. For example, the Month field in the source data becomes the Month field in a PivotTable report or PivotChart report. Items from the source data — such as March, April, and so on — become row labels, column labels, or page field items in a PivotTable report, or they become data series, categories, or page field items in a PivotChart report.


field button

Buttons in the field list on the PivotTable toolbar and also in a finished PivotTable report or PivotChart report. Field buttons display field names from the source data. Drag these buttons to row or column orientation to show items in the data area as row or column labels in a PivotTable report, or drag them to the series or category area or to plot them in a PivotChart report. Field buttons can also be dragged into the data area to summarize values for data labels, or to the page area to show data for one item at a time in a page field.


name

A word or string of characters that represents a cell, a range of cells, a formula, or a constant value. Using names in formulas often makes it easier to understand the structure of formulas. For example, if Total_Purchase represents a cell and SalesTax represents the local sales tax amount, then =Total_Purchase*SalesTax calculates the sales tax due for a purchase.


operand

Items on either side of an operator in a formula. In Microsoft Excel, operands can be values, cell references, names, labels, and functions.


argument

The values that a function uses to perform operations or calculations. The type of argument a function uses is specific to the function. Common arguments that are used within functions include numeric values, text values, cell references, ranges of cells, names, labels, and nested functions.


external reference

A reference to a cell or range on a sheet in another Microsoft Excel workbook, or a reference to a defined name in another workbook.


remote reference

A reference to data stored in a document from another program.


iteration

Repeated calculation of a worksheet until a specific numeric condition is met. Iteration is most commonly used to solve circular reference formulas. When a circular reference formula is iterated, the formula uses the result from the previous iteration.


3-D reference

A reference to a range that spans two or more worksheets in a workbook.


function

A pre-written formula that takes a value or values, performs an operation, and returns a value or values. Use functions to simplify and shorten formulas on a worksheet, especially those that perform lengthy or complex calculations.


operator

A sign or symbol that specifies the type of calculation — such as addition, subtraction, or multiplication — to perform on the elements of a formula. Operators include:

•	Mathematical operators, which perform basic mathematical operations.

•	Comparison, or logical, operators, which compare two values and produce the value TRUE or FALSE.

•	The text operator & (ampersand), which connects, or concatenates, two pieces of text into a single combined text value.

•	Reference operators, which produce one reference to a cell or range of cells from two references.


page break

Divides a worksheet into multiple pages for printing if the worksheet is too large to fit onto one page. Microsoft Excel inserts automatic page breaks based on the paper size, margin settings, and scaling options that are in the Page Setup dialog box (File menu).

You can control where page breaks occur by inserting manual page breaks. When you insert a manual page break, Microsoft Excel adjusts the automatic page breaks in the rest of the worksheet.


array formula

Performs multiple calculations and then returns either a single result or multiple results. Array formulas act on one or more sets of values, known as array arguments. Each array argument must be rectangular, and each argument must have the same number of rows and/or the same number of columns as the other arguments. To return multiple results, the formula must be entered into multiple cells.

To enter an array formula, press CTRL+SHIFT+ENTER. Microsoft Excel encloses array formulas between braces ( { } ).


matrix

A rectangular array of values or a range of cells that is combined with other arrays or ranges to produce multiple sums or products. Microsoft Excel has predefined matrix functions that can produce the sums or products.


external data range

Data from an external database that is brought into Microsoft Excel by using the Query Wizard, creating a query in Microsoft Query, creating a Web query, or importing a text file. You can format an external data range or use the data in calculations as you would any other data in Microsoft Excel. If the data in the underlying database changes, you can refresh the external data range in Microsoft Excel by clicking Refresh Data on the External Data toolbar.


external data

Data that is stored in an external database such as Microsoft Access, dBASE, SQL Server, or a Web source. You can bring external data into Microsoft Excel by using the Query Wizard, Microsoft Query, the PivotTable and PivotChart Wizard, or a Microsoft Visual Basic for Applications macro, or by creating a Web query.


tracer arrows

When auditing formulas, arrows that show the relationship between the active cell and its related cells. Tracer arrows are blue when pointing from a cell that provides data to another cell; if a cell contains an error value, such as #VALUE! or #DIV/0!, the tracer arrows are red.


implicit intersection

In a formula, a reference to either a column of cells or a row of cells instead of a single cell. Microsoft Excel chooses one cell in the reference that is in either the same row (if the reference is to a column of cells) or the same column (if the reference is to a row of cells) as the formula. For example, if cell C10 contains the formula =B5:B15*5, Microsoft Excel multiplies the value in cell B10 by 5 because cells B10 and C10 are in the same row.


Formula AutoCorrect

A feature that automatically checks a formula for common typing mistakes and suggests a correction if possible. You can accept or reject the suggested correction, which appears in an alert. For example, if you enter a formula that contains a function and then you include an extra closing parenthesis, Formula AutoCorrect finds the extra parenthesis and suggests that it be removed.


Formula Palette

A tool that helps you create or edit a formula and also provides information about functions and their arguments. The palette appears below the formula bar when you click the Edit Formula  [image]  button on the formula bar or the Paste Function  [image]  button on the Standard toolbar.


pan

To scroll continuously through a worksheet by using the Microsoft IntelliMouse pointing device.


Microsoft Visual Basic Help

To install Visual Basic Help, run the setup program that you used to install Microsoft Office or Microsoft Excel. Click Add or Remove Features, and then click  [image]  next to Office Tools. Click the icon next to Visual Basic Help, click Run from My Computer or Run from Network (as appropriate), and then click Update Now.

To get Help for Visual Basic in Excel, point to Macro on the Tools menu, and then click Visual Basic Editor. Click Microsoft Visual Basic Help  [image]; type the method, property, function, statement, or object that you want information about; click Search, and then click the topic you want.


current region

The block of filled-in cells that includes the currently selected cell or cells. The region extends in all directions to the first empty row or column.


outline

Worksheet data in which rows or columns of detail data are grouped so that you can create summary reports. The outline can summarize either an entire worksheet or a selected portion of it.


outline symbols

Symbols that you use to change the view of an outlined worksheet. You can show or hide detailed data by using the  [image],  [image], and  [image]  outline symbols. To show or hide the symbols, click Options on the Tools menu, click the View tab, and then select or clear the Outline symbols check box.


copy area

The cells that you copy when you want to paste data into another location. After you copy cells, a moving border appears around them to indicate that they've been copied.

When you copy cells, references in the original cells aren't affected. Microsoft Excel adjusts relative references of formulas that are pasted into a new location.


consolidation table

The table of combined results that appears in the destination area. Microsoft Excel creates the consolidation table by applying the summary function that you select to the source area values that you specify.


style

A collection of formats — such as font size, patterns, and alignment — that you can define and save as a group.


autoformat

A built-in collection of formats — such as font size, patterns, and alignment — that you can quickly apply to a range of data. Microsoft Excel determines the levels of summary and detail in the selected range and applies the formats accordingly.


active cell

The selected cell in which data is entered when you begin typing. Only one cell is active at a time. The active cell is bounded by a heavy border.


relative reference

A cell reference, such as A1, that's used in a formula, that changes when the formula is copied to another cell or range. After the formula is copied and pasted, the relative reference in the new formula is changed to refer to a different cell that is the same number of rows and columns away from the formula as the original relative cell reference is to the original formula. For example, if cell A3 contains the formula =A1+A2 and you copy cell A3 to cell B3, the formula in cell B3 becomes =B1+B2.


goal seek

A method for finding the input value that a formula needs to return a given result. When goal seeking, Microsoft Excel varies the value in a cell that you specify until a formula that's dependent on that cell returns the result you want. Use the Goal Seek command (Tools menu) when you want to find a specific value for a particular cell by adjusting the value of only one other cell.


data table

A range of cells that shows the results of substituting different values in one or more formulas. There are two types of data tables: one-input tables and two-input tables. For a one-input data table, you enter different values for one variable and see the effect on one or more formulas. For a two-input data table, you enter different values for two variables and see the effect on one formula.


section

Any combination of a sheet, view, and scenario that you choose when you create a report. A report can contain several sections.


print area

One or more ranges of cells that you can print when you don't want to print an entire worksheet. If a worksheet includes a print area, only the print area will be printed. You create a print area by using the Set Print Area command (File menu, Print Area submenu).


selection handles

Small squares that appear at the corners and along the sides of a rectangular area that surrounds a selected drawing object. Dragging a selection handle resizes the object.


moving border

An animated border that appears around a worksheet range that has been cut or copied. To cancel a moving border, press ESC.


outline data

The data that is contained within a worksheet outline. Outline data includes both the summary and detail rows or columns of an outline.


open database connectivity (ODBC)

A standard method of sharing data between databases and other programs. ODBC drivers use the standard Structured Query Language (SQL) to gain access to data from sources outside of Microsoft Excel. Microsoft Excel provides a Driver Manager and a set of drivers for popular database formats. Additional ODBC drivers are available from third-party sources.


calculated field

A field in a PivotTable report or PivotChart report that uses a formula you create. Calculated fields can perform calculations by using the contents of other fields in the PivotTable report or PivotChart report.


calculated item

An item within a PivotTable field or PivotChart field that uses a formula you create. Calculated items can perform calculations by using the contents of other items within the same field of the PivotTable report or PivotChart report.


page break preview

A view that displays the areas of the worksheet that will be printed and the location of the page breaks. The area to be printed — the print area, if you have defined one, or the area of the worksheet that you are using — is displayed in white. Automatic page breaks appear as dashed lines, and manual page breaks appear as solid lines. You can modify a worksheet and manipulate the page breaks while in page break preview.


merged cell

A single cell that is created by combining two or more selected cells. The cell reference for a merged cell is the upper-left cell in the original selected range.


workspace file

A file that saves display information about the currently open workbooks, so that you can later resume work with the same window configurations and display settings. The workspace file saves the size, position, and arrangement of workbook windows; the print area; screen magnification; and many of the calculation and display options that you can set for a workbook or worksheet. A workspace file doesn't contain the workbooks themselves. When you open the workspace file, the workbooks are reopened in the saved window and display configuration.


conditional format

A format, such as cell shading or font color, that Microsoft Excel automatically applies to cells if a specified condition is true.


refresh

To update the contents of a PivotTable report or PivotChart report to reflect changes to the underlying source data. If the report is based on external data, refreshing runs the underlying query to retrieve new or changed data. If the report is based on an offline cube file, this file is re-created from the original OLAP database.


level bar

In an outlined worksheet, the bar that extends from the first row or column in a group to the last row or column in the group. The row level bar  [image]  and the column level bar  [image]  appear only when you are viewing the detail data of the outline.


Collapse Dialog button

	Temporarily reduces the size of the dialog box so that you can select a cell or range on the worksheet. To redisplay the entire dialog box, click Expand Dialog  [image]  next to the box where you're entering the cell or range reference.


Expand Dialog button

	Redisplays the entire dialog box after you click Collapse Dialog  [image]  to reduce the size of a dialog box.


control

A graphic object, such as a text box, list box, option button, or command button, that you place on a worksheet, chart sheet, or form to display or enter data, perform an action, or make the sheet or form easier to read.


virus

A computer program or macro that "infects" computer files by inserting copies of itself into those files. When the file is loaded into memory, the virus can infect still other files. Viruses often have harmful side effects.


shared workbook

A workbook that has been set up to allow multiple users on a network to view and make changes at the same time. Each user who saves the workbook sees the changes made by other users. You must have Microsoft Excel 97or later to modify a shared workbook.


change history

In a shared workbook, information that is maintained about changes made in past editing sessions. The information includes the name of the person who made each change, when the change was made, and what data was changed. You can view the information directly on the worksheet or on a separate History worksheet.


History worksheet

A separate worksheet that lists information about changes that were made and saved in a shared workbook, including the name of the person who made the change, when and where it was made, what data was deleted or replaced, and how conflicts were resolved. The column labels on the History worksheet have filter arrows that you can use to find specific information.


read-only

An option that you can set so that a file can be read but not changed. You can open and view a read-only workbook, but you cannot save changes to the workbook file. If you edit the read-only workbook, you can save your changes only if you give the workbook a new name or save a copy in another location.


Microsoft Visual Basic Editor

An environment in which you can edit macros that you've recorded and write new macros and Visual Basic for Applications programs. The Visual Basic Editor command is available on the Macro submenu of the Tools menu.


hyperlink

Colored and underlined text or a graphic that represents a link to a location in a file on a network, a local disk, or the Internet. When you click the hyperlink, the location that is specified by the hyperlink opens.


address

The path to an object, file, Web page, or other destination. An address can be a URL (address to an Internet site) or a UNC network path (address to a file on a local area network). An address can also contain more specific address information, such as a Microsoft Excel cell range in the file that the main address points to. When you click a hyperlink, Microsoft Excel uses the address to go to the specified destination.


Web browser

Software that interprets HTML files, formats them into Web pages, and displays them to the user. The Web browser enables the user to follow hyperlinks, transfer files, and execute some programs. Some Web browsers can also permit users to send and receive e-mail, read newsgroups, and play sound or video files that are embedded in Web documents. Microsoft Internet Explorer and Netscape Navigator are Web browsers.


File Transfer Protocol (FTP)

A communication protocol that makes it possible for a user to transfer files between remote locations on a network. This protocol also allows users to use FTP commands to work with files, such as listing files and folders, on a remote location.


home page

The main page of a World Wide Web site. A home page is created by a Web site owner and usually has links to other pages, both within and outside the site. There are many different home pages on the Web, and one Web site can contain many home pages. The Microsoft home page, for example (http://www.microsoft.com/), also contains a Products home page, which in turn contains other home pages such as the Windows 95 home page and the Microsoft Office home page.


Hypertext Markup Language (HTML)

The markup language that is used for documents on the World Wide Web. You use a Web browser (such as Microsoft Internet Explorer) to view these documents. HTML includes tags for elements, such as text and graphics, that indicate how browsers should display the elements and how browsers should respond to user actions such as clicking hyperlinks.


Hypertext Transfer Protocol (HTTP)

The behind-the-scenes Internet protocol that delivers information by way of the World Wide Web. The protocol enables a user to use a client program to enter a URL (or click a hyperlink) and retrieve text, graphics, sound, and other digital information from a Web server. URL addresses of HTTP resources begin with http://.


Internet

A worldwide network of thousands of smaller computer networks and millions of commercial, educational, government, and personal computers. The Internet is like an electronic city with virtual libraries, storefronts, business offices, art galleries, and so on.


intranet

A network within an organization that uses Internet technologies (such as HTTP or FTP protocols). You can use an intranet to navigate between documents, pages, or objects by using hyperlinks.


search page

An organized way to find and go to other Internet sites. Many search pages provide the capability of searching by topic or by keyword. Others simply offer a well-organized list of hyperlinks to selected Internet sites.


start page

The first page that you see when you start a World Wide Web browser or use the Web toolbar to browse documents. You can set this location to any Web site that you want or to a document on your hard drive. A start page can contain hyperlinks to other documents on your computer, on a network, or on the Internet.


Uniform Resource Locator (URL)

An address to a specific Internet resource, such as a World Wide Web page or an FTP site. A URL expresses the type of resource (such as FTP or HTTP) to be accessed, the specific site where the information is stored, and where the information is located on the site. The first part of a URL identifies the server type or transfer protocol, followed by a colon and double forward slashes. For example, http://www.someones.homepage/default.html or ftp://ftp.server.somewhere/ftp.file.


World Wide Web

A system for navigating the Internet by using hyperlinks. When you use a Web browser, the Web appears as a collection of text, pictures, sounds, and digital movies.


Web

A system for navigating through documents that are connected by hyperlinks. Examples of Webs include a collection of workbooks and other Office documents that are connected by hyperlinks and located on a network share, a company intranet, and the Internet.


Microsoft Internet Explorer

A Web browser — software that interprets HTML files, formats them into Web pages, and displays them to the user. You can download Microsoft Internet Explorer from the Microsoft Web site, http://www.microsoft.com/


Gopher

An interface through which you can gain access to resources on the Internet. Gopher servers contain menus that list categories of information to choose from, performing the same function as hyperlinks in Web documents. URL addresses of Gopher resources begin with gopher://.


print titles

Row or column labels that are printed at the top of or on the left side of every page on a printed worksheet. To set print titles, click Page Setup on the File menu, and then click the Sheet tab.


Binder

A Microsoft Office program that you can use to organize related documents. You can check spelling, number pages consecutively across all documents in the binder, and print the documents.


data validation

A Microsoft Excel feature that you can use to define restrictions on what data can or should be entered in a cell, and to display messages that prompt users for correct entries and notify users about incorrect entries.


protect

To make settings for a worksheet or workbook that prevent users from viewing or gaining access to the specified worksheet or workbook elements.


macro

A program you write or record that stores a series of Microsoft Excel commands that you can later use as a single command. Macros can automate complex tasks and reduce the number of steps required to complete tasks that you perform frequently. Macros are recorded in Microsoft Visual Basic for Applications programming language. You can also write macros directly by using the Visual Basic Editor.


bookmark

A location or selection of text in a Microsoft Word document that you name for reference purposes. Bookmarks identify a section of your document so you can refer to it or link to it later. For example, use a bookmark to identify a location in a file that you want to link to from another location by using a hyperlink, or use bookmarks to create and number cross references.


public folder

A folder on a public forum that you and others can use to share a wide range of files and information, such as project and work information, discussions about general subjects, and classified ads. Public folders can have forms to post information, and views to find and organize information. The level of access that's granted to a particular user determines whether that user can view and use a public folder.

Public folders are stored on Microsoft Exchange Server computers.


Group button

In a PivotTable report or PivotChart report, groups items by category to create a single item from multiple items; for example, you can group days, weeks, months, or other time periods into quarters for analysis or printing.


Ungroup button

In a PivotTable report or PivotChart report, separates a group of items into the individual items that make up the group; for example, it separates quarters (of years) into the individual dates.


ODBC driver

A dynamic-link library (DLL) file that Microsoft Query and Microsoft Excel can use to connect to a particular database. An ODBC driver is a data source driver that conforms to the Open Database Connectivity standard. Each database program, such as Microsoft Access or dBASE, or database management system, such as SQL Server, requires a different driver. ODBC drivers make Microsoft Query flexible, so that you can connect to new databases as they become available by installing new drivers.


report template

A Microsoft Excel template that includes one or more queries, PivotTable reports, or PivotChart reports that are based on external data. When you save a report template, Microsoft Excel doesn't store the queried data in the template; instead, it refreshes the data each time the report template is opened. A report template has an .xlt file name extension.


refresh

To update data from an external data source. Each time you refresh data, you see the most recent version of the information in the database, including any changes that were made to the data.


join line

In Microsoft Query, a line that connects fields between two tables and shows Microsoft Query how the data is related. The type of join indicates which records are selected for the query's result set.


field

A category of information, such as last name or order amount, that is stored in a table. When Microsoft Query displays a result set in its Data pane, a field is represented as a column.


record

A collection of information about a particular person, place, event, or thing. When Microsoft Query displays a result set in its Data pane, a record is represented as a row.


inner join

A connection between fields in two tables that selects only the records that have the same value in the joined fields. When values are the same in both fields, Microsoft Query combines the two matching records from each table and displays them as one record in the result set. If a record from one table doesn't have a matching record in the other table, neither record appears in the result set.


outer join

A connection between fields in two tables that selects all the records from one table whether or not there are matching records in the other table. When values in the two tables are the same, Microsoft Query combines the matching records and then displays them as one record in the query result set. When a record from the table that's contributing all of its records can't be matched with a record from the other table, the record still appears in the result set. However, the record has empty cells whenever there is no matching record from the other table.


table

A collection of data about a particular subject that is stored in records (rows) and fields (columns).


result set

The set of records that results when you run a query. You can see the result set of a query in Microsoft Query, or you can return a result set to a Microsoft Excel worksheet for further analysis. Microsoft Query displays the result set in row-and-column format in its Data pane.


parameter query

A type of query that, when you run it, prompts for values to use to select the records for the result set, so that the same query can be used to retrieve different result sets. You can enter your own custom text for the prompt that Microsoft Query displays when the query is run, to describe the parameter it requests. For example, you can create a parameter query that selects records by city. When you run the query, you can display a custom prompt, "Type the name of the city," and the query then selects only the records for the city entered by the user.


Web query

A query that retrieves data that is stored on your intranet or the Internet.


criteria

One or more conditions that you specify to limit which records are included in the result set of a query. For example, the following criterion selects records for which the Order Amount value is greater than 30,000:

Order Amount > 30000


totals

One of the five calculation types Microsoft Query defines for you: Sum, Avg, Count, Min, and Max.


locked field or record

The condition of a record, field, or other object that can be viewed but not changed from Microsoft Query.


database

A collection of data that is related to a particular subject or purpose. Within a database, information about a particular entity, such as an employee or order, is categorized into tables, records, and fields.

Database programs, such as Microsoft Access, dBASE, and SQL Server, make it possible to store large volumes of data and then sort and retrieve the data later.


column heading

In Microsoft Query, the gray area at the top of each Data pane column that contains the field name, or if you changed it, another descriptive name for the field. Click the column heading to select an entire column. To increase or decrease the width of a column, drag the line to the right of the column heading. To adjust the column width quickly to the width of the largest value in the column, double-click the right border of the column heading.


row heading

In Microsoft Query, the gray area to the left of each row. Click the row heading to select an entire row. To increase or decrease the height of all the rows in the result set, drag the line below a row heading.


expression

A combination of operators, field names, functions, literals, and constants that evaluates to a single value. In Microsoft Query, you can use an expression to specify criteria (for example, Order Amount>10000) or to perform a calculation on field values (for example, Price*Quantity).


keyword

A word or phrase that identifies important topics in a workbook, presentation, or other Microsoft Office document. You can use keywords to index files that you created in Microsoft Excel, Microsoft Access, Microsoft Word, Microsoft PowerPoint, and Microsoft Outlook. To assign keywords, use the Properties command on the File menu.


primary key

One or more fields that uniquely identify each record in a table. In the same way that a license plate number identifies a car, the primary key uniquely identifies a record.


startup switch

An option that you can use to change what happens when you start Microsoft Excel from a shortcut or a command line. For example, you can use a startup switch to specify the default working folder or to prevent Excel from displaying the default blank workbook.


identifier

A field name used in a Microsoft Query expression. For example, Order Amount is the identifier (field name) for a field that contains order amounts. You can use an expression (such as Price * Quantity) in place of an identifier.


working folder

The open folder that's displayed by default in the Open or Save As dialog box (File menu). When you first use either command in the current session of Microsoft Excel, the working folder is the folder that's specified in the Default file location box (Tools menu, Options command, General tab). If you open another folder when you open or save a workbook, that folder becomes the working folder during the current session.


drop-down list box

A control on a menu, toolbar, or dialog box that displays a list of options when you click the small arrow next to the list box. For example, the Font box on the Formatting toolbar is a drop-down list box. You can type an option in the box or select an item from the list.


ActiveX control

A control — such as a check box , a list box, or a command button — that you create with the Control Toolbox and that offers options to users or runs macros or scripts that automate a task. When you insert ActiveX controls in custom programs, such as forms and dialog boxes, you can write a macro that is associated with the control. You can make the control "active" by writing macros in Microsoft Visual Basic for Applications or scripts in Microsoft Script Editor that customize the behavior of the control. For more information about setting properties for each control and writing macros in Visual Basic or Microsoft Script Editor, see Help for Microsoft Script Editor or Help for Visual Basic.


design mode

The time during which you build a program in Microsoft Visual Basic for Applications by adding controls, setting control or form properties, and so on, on worksheets. During design mode, you can add and edit the properties and macros that are associated with ActiveX controls. In contrast, during run time, you interact with the program as a user would, but you cannot change the program.


Dynamic Data Exchange (DDE)

An established protocol for exchanging data between Windows-based programs.


index

A database component that speeds up searching for data. When a table has an index, data in the table can be found by looking it up in the index.


cube

A data structure that contains On-Line Analytical Processing (OLAP) data. The data in a cube consists of dimensions and data fields. Dimensions organize the types of data into hierarchies with levels of detail, and data fields measure the quantities that are being tracked in the database. For example, a cube could have a geographic dimension that has the levels Country, Region, and City; a product dimension that has the levels Product Category and Product Name; and a data field named Sales Amount, which has values for the intersection of each geographic and product level.


End mode

An alternate method of moving within and between adjacent blocks of values on a worksheet. To use End mode, press END and then press an arrow key.


dimension

In an On-Line Analytical Processing (OLAP) data cube, a structure that organizes a type or category of data into levels of detail. For example, a geographic dimension could have the levels Country, Region, and City, and a time dimension could have the levels Year, Quarter, Month, and Day.

In a Microsoft Excel PivotTable report that is based on OLAP data, dimensions become row, column, or page fields. In a PivotChart report, dimensions become series, category, and page fields. Each dimension becomes a set of fields in which you can display greater levels of detail.


level

A part of an On-Line Analytical Processing (OLAP) dimension. Within a dimension, data is organized into lower and higher levels of detail. For example, a geographic dimension could have the levels Country, Region, and City; and a time dimension could have the levels Year, Quarter, Month, and Day. In a PivotTable or PivotChart report that is based on OLAP data, an item at a particular level corresponds to a member, in OLAP terminology.


On-Line Analytical Processing (OLAP)

A database technology that has been optimized for querying and reporting, instead of processing transactions. OLAP data is organized hierarchically and stored in cubes instead of tables. Microsoft SQL Server OLAP Services is an example of a product that provides OLAP data services.


offline cube file

A file on your hard disk or a network share that contains On-Line Analytical Processing (OLAP) data and provides source data for a PivotTable report or PivotChart report. From a report in Microsoft Excel, you can create an offline cube file that contains a copy of part of the data in an OLAP database on a network server. For reports that are based on source data from relational databases, such as Microsoft SQL Server, you can also create an offline cube file from within Microsoft Query. Offline cube files allow you to continue working with a report when you are not connected to the network or when the original OLAP server is unavailable.


filter

To display only the rows in a list that satisfy the conditions you specify. You use the AutoFilter command to display rows that equal one or more specific values, calculated values, or conditions.


data form

A dialog box that displays one complete record at a time. You can use data forms to add, change, locate, and delete records.


Digital signature

An electronic, encryption-based, secure stamp of authentication on a macro. The digital signature confirms that the macro originated from the developer who signed it and that the macro has not been altered, for example, to introduce a virus. To digitally sign a macro and identify it as your work, you need to obtain and install a digital certificate. When you open a file or load an add-in that contains a digitally signed macro, a digital signature appears on your computer as a digital certificate that names the macro's source, plus additional information about the identity and integrity of that source.


certifying authority

Someone who uses tools such as Microsoft Certificate Server to provide digital certificates that software developers can use to sign their macros. You can then authenticate the signed macros when you open a file containing the macros. A certifying authority can be an authorized administrator or group within a company, or a commercial certification authority, such as VeriSign, Inc.


vertexes

Black, square, draggable points that appear at the ends and intersections of lines or curves in certain AutoShapes, such as freeforms, scribbles, and curves, when you click Edit Points on the Draw menu (Drawing toolbar).


PivotChart report

An interactive chart that provides a graphical analysis of data from existing lists, databases, and PivotTable reports. After you create a PivotChart report, you can view different levels of detail or reorganize the layout of the chart by dragging its fields and items or by displaying and hiding items in the drop-down lists for its fields.


data access page

A Web page, published from Microsoft Access, that has a connection to a database. By using a data access page, you can view, add, edit, and manipulate the data that's stored in the database. A data access page may also include data from other sources, such as Microsoft Excel.


Component Object Model (COM) add-in

A supplemental program that extends the capabilities of a Microsoft Office program by adding custom commands and specialized features. COM add-ins, which use the filename extension .dll or .exe, can be implemented in any Microsoft programming product (such as Microsoft Visual Basic, Microsoft Visual C++, and Microsoft Visual J++) or any third-party programming product that can create COM DLLs (dynamic link libraries) and executables. These add-ins usually have their own setup programs and are loaded automatically.


multiple-level category labels

When the category data on your worksheet is hierarchical (that is, consists of more than one heading level), Microsoft Excel automatically maintains this hierarchy in your chart by including each level in the category axis labels.


non-OLAP source data

Underlying data for a PivotTable report or a PivotChart report that comes from a source other than an On-Line Analytical Processing (OLAP) database. Types of non-OLAP source data include relational databases, such as Microsoft SQL Server and Microsoft Access, lists on Microsoft Excel worksheets, and text file databases. The commands and options that are available in PivotTable reports and PivotChart reports differ depending on whether the reports are based on OLAP or non-OLAP data.


data source driver

A dynamic-link library (DLL) file that is used to connect to a particular database. Each database program, such as Microsoft Access, or database management system, such as Microsoft SQL Server, requires a different driver. Data source drivers can be ODBC (Open Database Connectivity), OLE-DB, or OLE-DB for OLAP (On-Line Analytical Processing) drivers.


toolbar

To display a toolbar, point to Toolbars on the View menu, and then click the toolbar that you want. If the toolbar you want is not listed on the Toolbars submenu, click Customize, and then select the check box for the toolbar on the Toolbars tab.

After the toolbar is displayed, if the button you want doesn't appear, click More Buttons  [image]  on that toolbar. For Help on an option, press SHIFT+F1, and then click the option.


PivotTable list on a Web page

A control that you can create by using a Microsoft Office Web Component in a design program such as data access page Design view in Microsoft Access. You can also create a PivotTable list by using Microsoft Excel to save a PivotTable report as a Web page. A PivotTable list provides interactive capabilities in the Web browser that are similar to those that Excel provides for PivotTable reports.


PivotChart series field

A field that is assigned a series orientation in a PivotChart report. In a chart, series are represented in the legend.


PivotChart category field

A field that is assigned a category orientation in a PivotChart report. In a chart, categories usually appear on the x-axis, or horizontal axis, of the chart.


drop area

The area in a PivotTable report or PivotChart report where you can drop fields from the field list on the PivotTable toolbar. In both types of reports, there are specific drop areas for page fields and data fields. PivotTable reports also contain drop areas for column fields and row fields, and PivotChart reports also contain drop areas for category fields and series fields.


base address

The relative path that Microsoft Excel uses for the destination address when you insert a hyperlink. This can be an Internet address (URL), a path to a folder on your hard drive, or a path to a folder on a network.


associated PivotTable report

The report that supplies the source data to the PivotChart report. A PivotTable report is an interactive table that summarizes and analyzes data from existing lists and tables. An associated PivotTable report is created automatically when you create a new PivotChart report by using the PivotTable and PivotChart Wizard. When you use the Chart Wizard to create a PivotChart report, the associated PivotTable report is the one you use to start the wizard.

The PivotChart report and its associated PivotTable report share the same data, and when you change the view or layout of one report, the other also changes. If you delete the associated PivotTable report, the PivotChart report becomes static so that you can no longer change its layout and view.


linked object

Information (the object) that is created in one file (the source file) and inserted into another file (the destination file) while maintaining a connection between the two files. The linked object in the destination file can be updated when the source file is updated. A linked object does not become part of the destination file.


Microsoft Office Web Components

Components that you can use to put interactive controls — spreadsheets, PivotTable lists, and charts — on the Web. To view and work with any of the Office Web Component controls, users must have the Office Web Components installed. They can do this by installing Microsoft Office 2000 or, if their company has an Office 2000 site license, by downloading the Office Web Components from their corporate intranet.


OLAP provider

A set of software that provides access to a particular type of On-Line Analytical Processing (OLAP) database. This software can include a data source driver and other client software that is necessary to connect to a database. Third-party OLAP providers may or may not be compatible with Microsoft Excel features, such as the Offline Cube Wizard, depending on whether the provider is Microsoft Office-compatible and includes support for these features.


cube definition

Information, stored by the OLAP Cube Wizard in an .oqy file, that defines how to construct an OLAP (On-Line Analytical Processing) cube from data that's retrieved from a relational database. A cube definition allows the cube to be created in memory whenever you open a report that's based on the .oqy file. It also allows you to use the wizard to make changes to the structure of a cube or offline cube file.


interactive functionality

Functionality that allows users of your Web page to make changes to the page within their Web browsers. You can save Microsoft Excel data with spreadsheet functionality, PivotTable functionality, or chart functionality. Each provides a different way to change the data and layout of data that's published or saved as a Web page.


data access page Design view

A window in Microsoft Access in which you design data access pages. A data access page is a Web page that has a connection to a database. By using a data access page, you can view, add, edit, and manipulate the data that is stored in the database. A data access page may also include data from other sources, such as Microsoft Excel.

To open a data access page in Design view in Microsoft Access, go to the Database window, click Pages under Objects, click the page that you want to open, and then click Design on the Database window toolbar.

If the page is already open in Access, you can switch to Design view by clicking View on the toolbar.


R-squared value

The R-squared value, also known as the coefficient of determination, is an indicator that ranges in value from 0 to 1 and reveals how closely the estimated values for the trendline correspond to your actual data. A trendline is most reliable when its R-squared value is at or near 1.


Microsoft Excel automatically names external data ranges for you. If you want to change the name, type the new name for the external data range in the Name box.


Specifies password options for your external data range.


Saves the underlying query for the external data as part of the worksheet so that you can refresh the data. Clear the Save query definition check box to prevent further refreshing of the data.

Clearing the Save query definition box permanently deletes the query definition from the worksheet, but it does not delete query files. If you saved the underlying query when you created it in the Query Wizard or if you saved it in Microsoft Query, the query file (*.dqy) is still saved on your computer, and you can use it again to retrieve external data.


Retains the password if your data source requires a password to connect to it. Microsoft Excel then prompts for the password only the first time the external data range is refreshed. Clear the Save password check box if you want to require that the password be entered each time the external data range is refreshed.


Specifies data refresh options for your external data range.


Runs the query in the background, so that you can continue working in Microsoft Excel. Clear the Enable background refresh check box to run the query and wait until it is complete. If you choose to run the query and wait until it is complete, you can't use Microsoft Excel until the query is finished.


Refreshes the external data range when you open the workbook that contains this query definition. The Save query definition check box must be selected to refresh the data.


Removes the external data returned to your worksheet before you save. Retains the query definition so that data is refreshed to your worksheet when you open the workbook again.


Specifies formatting and layout options for the external data range being brought into Microsoft Excel.


Uses field names from the external data as column labels for the external data range in Microsoft Excel. Clear the Include field names check box if you want to enter your own column labels in Excel.

If you use your own column labels in Excel rather than the field names from the external data, type the labels in the row above the external data range. Then, when you refresh the external data range, Excel won't remove the labels you typed.


Uses row numbers in the external data range for the data being brought into Microsoft Excel. By default, row numbers from the external data are not included in the result set.

To display the row numbers for an existing result set, select the Include row numbers check box, and click Refresh Data  [image]  on the External Data toolbar to refresh the external data range. Row numbers are displayed in the leftmost column of the external data range.


Click the option you want under If the number of rows in the data range changes upon refresh to control whether new cells or entire rows are inserted, or to replace existing data when you refresh and the size of an external data range changes.


Click this check box if you want Microsoft Excel to copy formulas in columns to the right of the external data range to new rows of data added when you refresh the data. If the external data range contains the results of a database query (*.dqy), any formulas entered within the data range are also filled down. When you select this option and the refreshed data range is smaller than the previous external data range, adjacent formulas in rows that are no longer used for the data range are removed from the worksheet.


Select to refresh external data at specific intervals, and then enter the number of minutes you want between refreshes in the minutes box.


Select if you want column widths to adjust to fit data when you refresh the external data range. Clear this check box if you don't want column widths to change.


Select if you want changes that you make in Microsoft Excel to the sort order, filtering, and column order to be retained when you refresh the external data range. Clear this check box if you don't want to preserve this information.


Select to retain cell formatting that you apply in Microsoft Excel when you refresh the external data range. Clear this check box if you don't want to retain cell formatting.


New Query

Creates a new query. Displays the Choose Data Source dialog box, where you either choose the data source you want to use for the new query or select an existing query to modify.


Open Query

Opens an existing query. Displays the Open Query dialog box, from which you open an existing query for viewing or editing. The Open Query dialog box is also displayed when you choose the Open button in the Execute SQL dialog box. From the dialog box, you can open an SQL file whose SQL statement you want to view, edit, or run.


Save File

Saves a query, replacing any previous version with the current version. If you haven't saved the query before, Microsoft Query displays the Save As dialog box.


View SQL

Displays the corresponding SQL SELECT statement for the query in the query window so that you can view or edit the statement. See the SQL documentation or your database administrator for details on the syntax your data source supports.


Show/Hide Tables

Displays or hides the Table pane.


Show/Hide Criteria

Displays or hides the Criteria pane. Microsoft Query doesn't display the Criteria pane automatically when you create a query. The Criteria pane appears the first time you specify criteria by clicking Add Criteria on the Criteria menu or by clicking the Show/Hide Criteria button.


Add Tables

Displays the Add Tables dialog box, which you can use to add one or more tables to the Table pane in your query. The Table pane must be displayed to see a table's field list. Click Add Tables to display the Table pane if you can't see a table you've added.


Criteria Equals

Specifies a criterion that selects only those records containing the same value as the active cell. The cell you select in the Query result set becomes the value for the criterion in the Criteria pane.


Cycle Through Totals

Calculates values, depending on the type of data stored in the field. To change the type of calculation, double-click the field heading in the Data pane, and select the type of total you want displayed for the selected field in the Edit Column dialog box.


Sort Ascending

Sorts records in ascending order, from the beginning of the alphabet, the lowest number, or the earliest date, by using the selected field. To sort on multiple fields, select the next field you want to sort on, and hold down CTRL and click a sort button for each additional sort.


Sort Descending

Sorts records in descending order, from the end of the alphabet, the highest number, or the latest date, by using the selected field. To sort on multiple fields, select the next field you want to sort on, and hold down CTRL and click a sort button for each additional sort.


Query Now

Runs the query and displays the most current result set in the Data pane. When Automatic Query is on, Microsoft Query runs the query each time you add a field, specify criteria, or otherwise change the query design. When Automatic Query is off, you can run the query only when you're ready by clicking Query Now.


Automatic Query

Turns Automatic Query off or on. Controls whether the query is run every time you change it, such as when you add fields or specify new criteria that records must meet. By default, Automatic Query is on.


Exit/Return Data

Quits Microsoft Query and closes any open Query windows. If you started Microsoft Query from another program, the Exit command is replaced by a command that you use to return data from Microsoft Query to the original program. The name of the command varies depending on the program from which you started Microsoft Query. If you made any changes to a query's design and haven't saved the query, Microsoft Query prompts you to save your changes. If you choose the Yes button but haven't previously named the query, the Save As dialog box is displayed.


Office Assistant

The Office Assistant provides Help topics and tips to help you accomplish your tasks.


Closes this dialog box and lets the query continue running.


Displays a list of queries currently running.


Stops a query that is running in the background.


Displays the selected query's elapsed running time as the data is being updated.


Opens the workbook as read-only. Changes you make to this workbook cannot be saved, unless you save the workbook with a different name.


Displays the workbook name and the name of the person who protected the workbook with a password.


Type the password to change the workbook. Passwords are case sensitive. If you want to view the workbook without making changes, click Read-Only without typing the password.


Displays the External Data Range Properties dialog box, where you can specify password options and data refresh options for your external data range.


Displays the Parameters dialog box, where you can view and change parameter values for parameter queries that are saved with your query file.


Returns the result set from your external data query to a new worksheet in the active workbook.


Returns the result set from your external data query to an existing worksheet you specify in the active workbook. Select the cell on the worksheet, or type a cell reference in the Existing worksheet box to specify the upper-left cell of the range on the worksheet where you want the external data range to be placed. The Collapse Dialog button at the right end of this box temporarily moves the dialog box so that you enter the range by selecting cells on the worksheet. When you finish, you can click the button again to display the entire dialog box.


Returns the result set from your external data query to the PivotTable Wizard, where you can format and analyze your data in a PivotTable report. This option is not available for parameter queries.


Select the When check box to review changes for the interval of elapsed time you specify in the When box. If you click Since Date, type the date you want in the When box. Click Not Yet Reviewed to select the changes that you have not yet reviewed by using Accept or Reject Changes on the Track Changes submenu of the Tools menu.


Select the Who check box to review changes in the workbook made by the person or persons selected in the Who box.


Select the Where check box to review changes only for a specific range of cells. Hold down CTRL and click to select nonadjacent cells you want to review. The Collapse Dialog button at the right end of this box temporarily moves the dialog box so that you enter the range by selecting cells on the worksheet. When you finish, you can click the button again to display the entire dialog box.


Accepts the change in the changed cell.


Rejects the change, and returns the value to the original value in the cell. Removes the highlight (if displayed) from the changed cell.


Accepts all remaining changes. If multiple changes have been saved for a cell, the changed values are listed in the Select a value for cell box. Click Accept All to accept the most recent changes made to cells that you are reviewing.


Rejects all remaining changes. Returns the values of changed cells to the original values. If multiple changes have been saved for a cell, the changed values are listed in the Select a value for cell box. Click Reject All to return to the original values (displayed at the top of the Select a value for cell box) of the cells that you are reviewing.


Displays the number of the change currently being viewed and the total number of changes to review.


Displays the name of the person who made the change, the date and time the change was made, and other information about the change. Information about other changes that will be affected if you reject the change is also displayed. Use the scroll bar on the right to review the entire contents of the box.


Type a value from 0 (zero) to 409, which represents the row height in points, to change the height of the selected cells. If the row height is 0, the row is hidden.


Notifies you that the workbook is available to modify and save changes to.


Opens the workbook so that you can make changes and save. If you made changes to the read-only version of the workbook, you will be asked to discard your changes and open the newest version of the workbook, or save changes to a different name and compare workbook versions with the newest version of the available workbook.


Saves a backup copy each time you save the workbook.


Choose options to restrict access to workbooks and protect workbooks from changes.


Type a password in the Password to open box to prevent others from opening a workbook without the password. A password is case sensitive and can contain up to 15 characters, including letters, numbers, and symbols. If you lose the password, you cannot open the workbook.


Type a password in the Password to modify box to prevent another user from opening, making changes in, and saving the workbook without a password. If someone opens the workbook as read-only and changes it, it must be saved with a different name. A password is case sensitive and can contain up to 15 characters, including letters, numbers, and symbols. If you lose the password, you cannot open the workbook.


Recommends that others open a workbook as read-only. If someone opens the workbook as read-only and changes it, it must be saved with a different name.


Specifies how large or small you want your document to appear as a percentage of its normal size.


Type a percentage to reduce or enlarge the display of your document.


Click the magnification or percentage of normal size you want to view your document in.


Reduces or enlarges the selection to fit within the current window size.


Click Custom to enlarge or reduce a worksheet or chart sheet by a specific percentage so that you can navigate, position objects, or view the sheet, and then type the percentage in the Custom box.


Lists the scenarios that are defined on the active worksheet.


Displays values on the worksheet for the selected scenario.


Adds a new scenario and displays the Add Scenario dialog box for entering values in each changing cell of the scenario.


Deletes the selected scenario.


Changes the scenario name, the references for the changing cells, or the comments for the selected scenario.


Merges the scenarios from a worksheet you select from an open workbook.


Creates a Scenario summary report or a Scenario PivotTable report as a new sheet tab in your workbook.


Lists the cells for which values are saved in the currently selected scenario.


Displays the name of the user who created or edited the selected scenario, the date it was created or last edited, and other comments.


Changes or adds a new scenario name.


Enter the cell references of cells that contain the values you want to change. The Collapse Dialog button at the right end of this box temporarily moves the dialog box so that you enter the range by selecting cells in the worksheet. When you finish, you can click the button again to display the entire dialog box.


Type or modify text in the Comment box to identify the scenario. Microsoft Excel automatically includes the user name and date of creation or change.


Select nonadjacent changing cells by using CTRL+click. You can select up to 32 nonadjacent changing cells.


Select the Prevent changes check box to protect scenarios from changes. Select the Hide check box to hide scenarios.


Select the Prevent changes check box to protect scenarios from changes. You also must protect the sheet by pointing to Protection on the Tools menu, and then clicking Protect Sheet. You must clear the Prevent changes check box before you can edit or delete the scenario.


Select the Hide check box to hide scenarios. You also must protect the sheet by pointing to Protection on the Tools menu, and then clicking Protect Sheet.


Merges all scenarios from the selected worksheet in the selected open workbook.


Click the name of the workbook in the Book box to identify the workbook you want to merge scenarios from.


Click the name of the worksheet in the Sheet box to identify the worksheet you want to merge scenarios from.


Displays the number of scenarios on the worksheet selected in the Sheet box.


Creates a report that lists your scenarios with their input values and result cells. Use this type of report only when your model has one set of changing cells provided by a single user.


Creates a report that gives you an instant what-if analysis of your scenarios. Use this type of report when your model has multiple sets of changing cells provided by more than one user.


Click the Scenario summary or Scenario PivotTable option to indicate the type of summary report you want to create.


Type references to specify cells with formulas that perform calculations on the values saved in the scenarios you're summarizing. Separate multiple references with commas. Result cells are required if you select the Scenario PivotTable report type.


Enter or edit the values of a changing cell in the box next to the reference for the changing cell. Only the first five changing cells are displayed.


Minimize

Reduces an application or workbook window to an icon. To restore the window to its previous size and location, click the Maximize button or double-click the title bar.


Maximize

Enlarges a program or workbook window to fill the screen. To restore the window to its previous size and location, click the Minimize button or double-click the title bar.


Restore

Restores a window to its previous size and location.


Close

Quits the program, or closes the workbook. Prompts you to save any unsaved changes before closing.


Chart area

The entire chart and all its elements.


Worksheet area

The entire worksheet and all its elements, including cells, gridlines, row and column headings, scroll bars, and sheet tabs.


Formula bar

A bar near the top of the window that displays the constant value or formula used in the active cell. To enter or edit values or formulas, select a cell, type the data, and then press ENTER. You can also double-click a cell to edit data directly in the cell.


Scroll bar

The shaded bars along the right side and bottom of a window. To scroll to another part of the file, drag the box or click the arrows in the scroll bar.


Print Preview window

Displays each page as it will look when printed. The status bar at the bottom of the screen shows the current page number and the total number of pages in the selected sheet.


Status bar

The bar near the bottom of the screen that displays information about a selected command or an operation in progress. The right side of the status bar shows whether keys such as CAPS LOCK, SCROLL LOCK, or NUM LOCK are turned on. Click Status Bar on the View menu to display or hide the status bar.


Split box

The small box at the top of the vertical scroll bar and at the right end of the horizontal scroll bar. To view two parts of a worksheet simultaneously, drag the split box in the direction you want the split to appear. To split the window along row or column gridlines, drag the split box onto the worksheet. To remove a split, double-click the split.


Title bar

Drag the window title bar to move a window or dialog box. To maximize a window or restore it to its previous size and location, double-click the title bar.


Macro area

The entire macro sheet and all its elements.


Window sizing border

The border around a window. Drag the window border to change the shape and size of a window. To size the window in two directions at once, drag a corner of the border.


Tab split box

The small box between the sheet tabs and the horizontal scroll bar. Drag the tab split box to the right or left to display additional sheet tabs or increase the size of the horizontal scroll bar. To return to the default display of sheet tabs, double-click the box.


Edit cell contents directly in cell

When you double-click the cell that contains the data you want to edit, you can edit the cell contents directly in the cell. To enter your changes into the cell, press ENTER. To cancel your changes, press ESC.


Tab scrolling buttons

The arrow buttons to the left of the sheet tabs. To scroll between sheet tabs if the workbook has more tabs than are currently displayed, click an arrow for the direction you want to scroll; to select a sheet, click its tab. To scroll several tabs at a time, press SHIFT while you click one of the middle tab scrolling buttons. To display a menu of sheets in the workbook, click a tab scrolling button with the right mouse button.


Sheet tab

A tab near the bottom of a workbook window that displays the name of a sheet. Click the sheet tab to make a sheet active. To display a shortcut menu, click a tab with the right mouse button. To scroll through the sheet tabs, use the tab scrolling buttons to the left of the tabs.


Name box

The box at the left end of the formula bar that identifies the selected cell, chart item, or drawing object. Type the name in the Name box, and then press ENTER to quickly name a selected cell or range. To move to and select a previously named cell, click its name in the Name box.


Row heading

The numbered gray area to the left of each row. Click the row heading to select an entire row. If you click the row heading with the right mouse button, a shortcut menu appears. To increase or decrease the height of a row, drag the line below the row heading.


Column heading

The lettered or numbered gray area at the top of each column. Click the column heading to select an entire column. If you click the column heading with the right mouse button, a shortcut menu appears. To increase or decrease the width of a column, drag the line to the right of the column heading. If you are using R1C1 reference style, your column headings will have numbers instead of letters.


Select All button

The gray rectangle in the upper-left corner of a worksheet where the row and column headings meet.

Click  [image]  to select all cells on a worksheet.


Fill handle

The black square in the lower-right corner of the active cell or selection. When the pointer is on the fill handle, the pointer changes from an arrow to a crosshair. Drag the fill handle down or to the right to fill cells with data based on the current selection. Drag it up or to the left to clear the contents of selected cells. You can insert or delete rows and columns by pressing SHIFT while dragging the fill handle.


PivotTable buttons

A shaded button in a PivotTable report that contains the name of a summarized field of data from a database, list, or table. Drag buttons between rows and columns to change the way data is summarized. Click the arrow on a button to select which data to display for the field. To customize the way data is summarized, double-click a button.


AutoFilter arrows

An arrow next to a column title in a filtered table or list. Click the arrow, and then click the items you want to display in the column. To remove the arrow, point to Filter on the Data menu, and then click AutoFilter.


Help is available for each item in this group. Click  [image] at the top of the dialog box, and then click the item you want information about.


Selects all comments on the active worksheet.


Selects all cells whose values do not start with an equal sign or contain a formula. The check boxes below this option define the type of constant you want to go to.


Selects all cells that contain formulas. The check boxes below this option define the type of formula you want to go to.


Selects all blank cells through the last cell on the worksheet that contains data or formatting.


Selects a rectangular cell range around the active cell. Microsoft Excel selects a range within the boundary of any combination of blank rows and blank columns.


Selects an entire array, if the active cell is contained in an array.


Selects cells whose contents are different from the comparison cell in each row. For each row, the comparison cell is in the same column as the active cell.


Selects cells whose contents are different from the comparison cell in each column. For each column, the comparison cell is in the same row as the active cell.


Selects cells that are referenced by the formula in the active cell.


Selects cells with formulas that refer to the active cell.


Selects the last cell on the worksheet that contains data or formatting.


Selects the visible cells on a worksheet so that changes you make affect only the visible cells, not cells in hidden rows or columns.


Selects all graphic objects, including charts and buttons on the worksheet and in text boxes.


Selects cells with number values. This option is only available if you click Constants or Formulas.


Selects cells with text. This option is only available if you click Constants or Formulas.


Selects cells with the logical values TRUE or FALSE. This option is available only if you click Constants or Formulas.


Selects cells with error values. This option is available only if you click Constants or Formulas.


Selects only cells directly referred to by formulas in the selection (precedents), or selects only cells with formulas that refer directly to the active cell (dependents). This option is available only after you click Precedents or Dependents.


After you click Precedents, selects all cells directly or indirectly referred to by cells in the selection (precedents). If you click Dependents, selects all cells that directly or indirectly refer to the active cell (dependents). This is useful for selecting the entire network of cells that affect a particular cell on a complex worksheet, or for tracking the logic of a model one step at a time.


Selects only cells with data validation rules applied. Click All to select all cells on the worksheet that have data validation applied. Click Same to select cells that have the same validation as the currently selected cell.


Selects only cells with conditional formats applied. Click All to select all cells on the worksheet that have conditional formats. Click Same to select cells that have the same conditional formats as the currently selected cell.


Click All to select all cells on the worksheet that have data validation or conditional formats applied, depending on the option you chose above. Click Same to select cells that have the same validation or conditional formats as the currently selected cell.


Determines whether the series is filled across selected rows or down selected columns. The contents of the first cell or cells in each row or column of the selection are used as the starting values for the series.


Click the type of series you want to fill.


Creates a linear series or linear best-fit trend.

If the Trend box is cleared, a linear series is calculated by adding the value in the Step value box to each cell value in turn.

If the Trend box is selected, the value in the Step value box is ignored, and a linear trend is calculated based on the selected values. The selected original values are replaced with values that fit the trend.


Creates a growth series or geometric growth trend.

If the Trend box is cleared, a series is calculated by multiplying the value in the Step value box by each cell value in turn.

If the Trend box is selected, the value in the Step value box is ignored, and a geometric growth trend is calculated based on the selected values. The selected original values are replaced with values that fit the trend.


Fills a series with dates. The type of date series that is incremented depends on the option selected under Date unit.


Fills blank cells in a selection with a series based on data included in the selection. Selecting this option produces the same results as dragging the fill handle to fill a series. Any value in the Step value box and any selected Date unit option are ignored.


Specifies whether a series of dates will increase by days, weekdays, months, or years. Available only when creating a date series.


Enter a positive or negative number to indicate the amount by which you want a series to increase or decrease.


Enter a positive or negative number to indicate the value at which you want the series to end. If the selection is filled before the series reaches the stop value, the series stops at that point. If the selection is larger than needed to fill the series, the remaining cells of the selection are left blank. You do not need a value in the Stop value box to fill a series.


Calculates a best-fit line (for linear series) or geometric curve (for growth series). The step values for the trend are calculated from the existing values at the top or left of the selection. Any value in the Step value box is ignored if the Trend check box is selected.


Changes the size of the data marker. The Sample box displays the marker line size you select.


Specify display options for how you want the inserted image to appear when it is pasted to the destination object.


Stretches the inserted image.


Stacks the inserted image.


Stacks and scales the inserted image proportional to the size of the destination object.


Tiles the inserted image.


Scales the inserted image proportional to the destination object.


Applies the inserted image to the end of the destination object.


Applies the inserted image to the sides of the destination object.


Applies the inserted image to the front of the destination object.


Select the axis you want to plot the selected series on.


Plots the selected data series along the primary axis.


Plots the selected data series along the secondary axis. This option displays a second axis if one hasn't already been added to the chart.


Shows how your chart will look with the selected options.


Drag the cells on the worksheet to select the values you want for the x axis.


Displays the current chart before the options you select are applied.


Select the cell on the worksheet that contains the series name for the selected series in the chart.


Drag the cells on the worksheet to select the values you want for the y axis.


Click the error bar display option you want for the selected data series.


Displays plus and minus X error bars.


Displays plus X error bars.


Displays minus X error bars.


Removes X error bars from the selected data series.


Specify the amount or variation of error you want for the error bars displayed on the selected data series.


Uses a fixed value as the error amount.


Uses a percentage of each data point as the error amount.


Uses a specific number of standard deviations from the mean of plotted values for the error amount.


Uses the standard error of the plotted values as the error amount for each data point.


Type a value in the Plus (+) box or the Minus (-) box or both to use a custom value as the error amount for each data point.


Displays plus and minus Y error bars.


Displays plus Y error bars.


Displays minus Y error bars.


Removes Y error bars from the selected data series.


Select the 3-D shape you want the selected data series to display.


Adds or removes data labels to or from data points of the selected series.


Removes data labels from all data points of the selected series.


Displays the value of each data point in the selected series.


Displays the percentage of the whole for all data points in pie and doughnut charts.


Displays the category label assigned to all data points. For area charts, this option displays the series name.


In pie and doughnut charts, displays both the percentage of the whole and the category labels for each section of the chart.


Displays the sizes for each bubble in a bubble chart, based on the values of the third data series.


Places legend keys, with the assigned format and color, next to the data labels in the chart.


Click a series name in the Series order box, and then click the Move Up button or Move Down button to change the order of the data series in a chart.


Shows how your chart will look when you change the series order of the selected series.


Extends drop lines from each marker to the x axis for a line chart or an area chart.


Extends high-low lines from the highest value to the lowest value in each category. This option is used primarily for stock charts and is available only for 2-D line charts.


Extends rectangular up-down bars for open-high-low-close charts. In charts that track stock prices, up-down bars extend from the opening price to the closing price on a given day. This option is available only for line charts.


Type a value between -100 and 100 in the Overlap box to specify how much you want the markers within a category to overlap each other. The larger the value, the greater the overlap; the smaller the value, the greater the gap or spacing.


Type a value between 0 (zero) and 500 in the Gap width box to specify the amount of space you want between categories of data markers. The larger the value, the greater the distance between categories.


Displays lines that connect data markers for data series of the same chart type as the selected data series.


Assigns a different color or style to each data marker in the selected data series. Mostly used for charts with only one data series.


Type a number in the Angle of first slice box to specify the angle at which you want the first pie or doughnut slice to start.


Type a value between 10 and 90 in the Doughnut hole size box to specify the size of the hole in a doughnut chart. The greater the value, the larger the hole and the narrower the doughnut rings.


Adds category labels to a chart.


Displays negative bubbles in a bubble chart, if bubble values are negative.


Specify Area of bubbles or Width of bubbles to indicate the size and proportion of bubbles for the chart display.


Type a value between 0 (zero) and 300 in the Scale bubble size box to specify the size of the selected bubble in a bubble chart. The greater the value, the larger the bubble in proportion to other bubbles.


Type a value in the Chart depth box to specify the depth of a 3-D chart relative to its width.


Type a number in the Gap depth box to specify the distance between the data markers in 3-D charts.


Shows how your chart will look with the options you select.


Select an option in the Split series by box to specify how you want to separate the second data plot (or bar of pie or pie of pie) in the bar of pie or pie of pie chart.

Position separates the second plot using the final data series; use Value to separate the second plot with values you enter in the Second plot contains all values less than box. Use Percent Value to separate the second plot by the percentage of the pie you enter in the Second plot contains all values less than % box. Drag slices of the pie that you want to use as a second plot if you want to customize the chart.


Type a value between 0 (zero) and 500 in the Gap width box to specify the amount of space you want between categories of data markers. The larger the value, the greater the distance between categories.


In pie charts, displays a line from the pie slice to its label.


Select this check box if you don't want to see the Welcome to Page Break Preview dialog box again.


Move page breaks by dragging them left, right, up, or down. Microsoft Excel automatically scales the worksheet to fit the columns and rows to the page.


Lets you specify a custom sort order, such as Low, Medium, High or Jan, Feb, Mar, and so forth, for the column selected in the Sort by box. You can also specify a case-sensitive sort and sort either from top to bottom or from left to right.


If you’re sorting rows, select the first column to sort by. If you’re sorting columns, select the first row to sort by.


Click Ascending to sort the lowest number, the beginning of the alphabet, or the earliest date first in the sorted list.

Click Descending to sort the highest number, the end of the alphabet, or the latest date first in the sorted list. Blank cells are always sorted last.


Use this box if you’re sorting by more than one column or row. After the list is sorted by the column or row in the Sort By box, the list is sorted by additional columns or rows in sequence.


Click Header row to exclude the first row from the sort if your list has column labels in the uppermost row.

Click No header row to include the first row in the sort if the list doesn't have column labels in the uppermost row.


Select the custom sort order you want.


Click Case sensitive to sort on capitalization. This option is not available when you sort items in a PivotTable report.


Click Sort top to bottom to sort rows by the values in one or more columns. In PivotTable reports, you can sort by only one column.

Click Sort left to right to sort columns by the values in one or more rows. In PivotTable reports, you can sort by only one row.


Select the custom sort order you want.


Click Case sensitive to sort on capitalization. This option is not available when you sort items in a PivotTable report.


Click Sort top to bottom to sort rows by a single column.

Click Sort left to right to sort columns by a single row.


Sort by furigani
Click Use Furigana to sort items by using their Furigana. If this is selected, all character strings, including Kanji, will be sorted by their Furigana.

Click Do Not Use Furigana to sort items without using their Furigana. If this is selected, Kanji will be sorted in their code order.


Click Expand the selection to enlarge the selection to include adjacent data.

Click Continue with the current selection to sort only the current selection.


Reverses the most recent actions made during the spelling check.


Enter the correct word in the Change to box, or select a word in the Suggestions box. The new word replaces the word not found in the main dictionary or open custom dictionary.

To delete the indicated word instead of changing its spelling, delete the word in the Change to box; the Change button changes to Delete. Click Delete to delete the word on your worksheet.


Lists suggested replacement words from the main dictionary and open custom dictionary when you click Suggest or if you have selected the Always suggest check box.


Adds the word that appears beside Not in dictionary to the custom dictionary you select. Microsoft Excel uses the selected custom dictionary in addition to the main dictionary when checking spelling.


Ignores words in uppercase letters when you're checking spelling.


Shows suggested spellings for misspelled words found when you're checking spelling.


Leaves the current instance of the word displayed beside Not in dictionary unchanged on your worksheet.


Leaves all instances of the word displayed beside Not in dictionary unchanged on your worksheet.


Changes the current instance of the word displayed beside Not in dictionary to the word in the Change to box.

To delete the indicated word instead of changing its spelling, delete the word in the Change to box; the Change button changes to Delete. Click Delete to delete the word on your worksheet.

If Microsoft Excel detects a duplicate word such as "the the" on your worksheet, use Delete to delete the duplicate word.


Changes all instances of the word displayed beside Not in dictionary to the word in the Change to box.

To delete all instances of the indicated word instead of changing its spelling, delete the word in the Change to box; the Change All button changes to Delete All. Click Delete All to delete all instances of the word on your worksheet.


Adds the word in the Not in dictionary box to the dictionary selected in the Add words to box.


Displays a list of proposed alternatives for a misspelled word.


Adds a word to the AutoCorrect list so that AutoCorrect can correct it automatically as you type.


Displays a possible error, such as a misspelled word, a duplicate word, or incorrect capitalization.


Displays the contents of the cell that contains the misspelled word.


Select the language you want to use to check spelling.


Type a number from 0 (zero) through 255 in the Standard column width box to change the width for all columns that you have not previously adjusted on the active worksheet. This number represents the number of characters that can be displayed in a cell in the standard font.


Select a style in the Style name box to apply the style to the selected cells or redefine a style's formats.


Click Modify to change the selected style in the Style name box.


Change the style listed in the Style name box by selecting and clearing the check boxes under Style includes, and then click Add to update a style.


Deletes the current style. The Normal built-in style cannot be deleted.


Click Merge to copy styles from one open workbook to another.


Select the check boxes of format elements you want to include in a style.


Describes the format of the style element selected.


Removes all subtotals from the current list.


Select a label from the At each change in box to specify the column that contains the items or groups by which you want to subtotal values in other columns. If you want to subtotal grouped items, sort the list using this column as the primary sort column before you add subtotals.


Select the summary function you want to use to subtotal your values.


Select one or more check boxes under Add subtotal to to specify the columns that contain values you want to subtotal. Subtotals for these columns will be based on differences in items in the column you selected in the At each change in box.


Replaces all subtotals in the list with the new subtotals.


Inserts page breaks automatically after each group of subtotaled data.


Inserts the subtotal and grand total rows below the detail data.


Type a name for the calculated field or item you want to create, or select a named field or item from the box to edit.


Type the formula for the calculated field or calculated item. The formula syntax is specific to PivotTable and PivotChart reports. For more information, refer to Microsoft Excel Help.


If you want to use data from an existing field in your formula, click the field in the Fields box, and then click Insert Field.


If you want to use data from an item in an existing field in your calculated item, click the field in the Fields box that contains the item, click the item in the Items box, and then click Insert Item. You can insert only items from the same field as the calculated item you’re creating or editing.


For calculated fields, adds the selected field to the formula. For calculated items, selects the field for which you want to add items to the formula. This must be the same field as the one containing the calculated item.


Adds a selected item to the formula for the calculated item. You can insert only items from the same field as the calculated items you’re creating or editing.


Inserts the calculated field or item into your report.


Removes the selected calculated field or calculated item from your report.


Displays the current calculation or solve order of all calculated items in the report. Click a formula in the box, and then click Move Up or Move Down to change the position of a formula in the solve order. Continue until all the formulas are in the order you want them calculated.


Moves the selected formula under Solve order higher in the order of calculation. If a PivotTable report value is affected by two or more calculated items, the value is set by the last formula in the solve order.


Moves the selected formula under Solve order lower in the order of calculation. If a PivotTable report value is affected by two or more calculated items, the value is set by the last formula in the solve order.


Click a calculated item formula in the box, and then click Delete to delete the formula. If you delete the last formula for a calculated item, the entire calculated item is deleted as well. To see a list of formulas for calculated fields and items in your report before you click Delete, return to the PivotTable report and click a cell. Point to Formulas (PivotTable or PivotChart menu, PivotTable toolbar), and then click List Formulas. A list of calculated item and field formulas will be displayed on a separate sheet in the workbook that contains your report.


Type a new name to change the name of the selected data field. This does not change the field name in the source data.


Click a function to change the function used to summarize data in the selected field. This option is not available for reports based on source data from OLAP databases or for reports with calculated fields.


Click an option to specify a custom calculation for your selected field. In reports based on source data from OLAP databases, the custom calculation is performed in Microsoft Excel on the summary values that have been precalculated on the OLAP server.


Click a field to use a field in your source data as the base field or comparison field in your custom calculation.


Click an item to specify the item in your base field or comparison field to be used in the custom calculation. Click Previous if you want each calculation to use the value of the item preceding the current item in the base field. Click Next if you want each calculation to use the value of the item following the current item in the base field.


Deletes the selected field from the report. This does not affect the source data.


Formats the numeric items in the selected field.


Creates a custom calculation for the selected data field. Custom calculations can be useful when you want to compare one data field with another data field in your report. For example, you can display the sales data of a particular salesperson's sales as a percentage of all sales data in the report.


Displays the name of the selected field exactly as it appears in the source data.


Microsoft Excel automatically determines the starting date from the source data when you group dates in a report. If you want to start grouping at a different date, type the date in mm/dd/yy date format in the Starting at box.


Microsoft Excel automatically determines the ending date from the source data when you group dates in a report. If you want to stop grouping at a different date, type the date in mm/dd/yy date format in the Ending at box.


Click a time period in the By box to group your data by certain time periods. Microsoft Excel automatically determines a time period based on the date field in your source data.


Enter a number in the Number of days box to specify the number of days you want in a time period. For example, type 7 in the Number of days box to group items by weeks. The Number of days option is available only when Days is the only selection in the By box.


Click the field that has the detail data you want to show for the item you selected.


Type a new name in the Name box to change the name of the selected field. This does not change the field name in the source data. For reports based on source data from OLAP databases, the field returns to its original name when you show a higher level of detail and then redisplay the renamed field.


Moves the selected field to another location in the PivotTable report, and changes the layout of the existing PivotTable report.


Click one or more options under Subtotals to specify subtotals for the selected field. Subtotals are placed in separate rows in a PivotTable report. Subtotals are not displayed in PivotChart reports.

In reports based on source data from OLAP databases, the Custom option and the summary function list box are not available.


Click Automatic to subtotal each item in a selected outer row or column field. Click Custom to subtotal each item in a selected inner row or column field. For page fields, the subtotals you select are not displayed until you move the field to the row or column area.


Click Custom and then click the summary functions you want to use to subtotal each item in the selected inner row or column field. You can use more than one type of subtotal in a selected field. For page fields, the subtotals you select are not displayed until you move the field to the row or column area.

This option is not available in reports based on source data from OLAP databases.


Click None to hide or omit subtotals for the selected field.


Click the items in the Hide items box to hide items in the selected page field of your report. At least one item in the field must be visible in your report.


Click to delete the selected field from the report. This does not delete the field from the source data.


Select the Show items with no data check box to display items in the row, column, or page field that have no data. For example, if there were no sales in April, select this check box to include the April item for the field. This option is not available in reports based on source data from OLAP databases.


Click Advanced to change additional viewing, sorting, and page field properties of your report.


Sets indented format, display, and print options for outer row fields.


Click Top or Bottom in the Show box, and enter the number of items you want to display. In the Using field box, click the field that contains the data that you want to use to determine the top or bottom items.


Controls display of items in a field, based on the data you want to show or hide.


Click Manual to display all items in a field that were previously hidden by using Automatic under AutoShow options.


Click Automatic to automatically display a subset of field data based on selection of Top or Bottom in the Show box and the number of items you specify. In reports based on source data from OLAP databases, your Automatic setting remains in effect only if you do not select different items for display in the drop-down list box for the field.


Click Top or Bottom from the Show box, and enter the number of items you want to display the top or bottom subset of data for in the selected field.


Click the data field that has the values you want to use to sort items in the active field.


Controls sort order for items in the field, based on the selected field and options you specify under AutoSort options.


Returns items in the selected field of the report to the default sort order if you previously specified a different sort order under AutoSort options. If you don't want to sort the field automatically when you refresh or change the layout, click Manual under AutoSort options, and then click OK twice.


Click Ascending to sort the items in a column field from left to right with the lowest number, first letter of the alphabet, or earliest date first. In a row field, Ascending sorts the items from top to bottom.

Click Descending to sort the items with the highest number, the end of the alphabet, or latest date first.


Select to lock the selected page field so that it cannot be dragged to another part of the report. When you drag a page field to another area, the field automatically retrieves data for all items at once.

This option is not available for row and column fields or for reports based on source data from OLAP databases.


Retrieves the external data for all page field items at once so that the report is refreshed less frequently and calculation is faster. This option is not available for row and column fields or for reports based on source data from OLAP databases.


Retrieves the data for each page field item when you display the item so that less Microsoft Excel memory is required. This option is not available for row and column fields or for reports based on source data from OLAP databases.


Sets properties for a page field. Querying for each page field item requires less Microsoft Excel memory; the external data that serves as the source for a page field item is retrieved for the report only when the item is displayed. These options are not available for row and column fields or for reports based on source data from OLAP databases.


Displays the field in nonindented, or cross-tabulated, format.


Displays the field in indented format, similar to traditional banded or formatted database reports.


Select to display subtotals at the top of each group of subtotaled items. Clear this check box to display the subtotals at the bottom of each group. To change where subtotals are displayed, the field or PivotTable report must be displayed in indented format. You can change the display of subtotals only for outer row fields, not for the innermost (rightmost) row field.


Select to insert blank lines after each item in the field. You can insert blank lines for all but the innermost (rightmost) row field. The blank lines appear after each item, or they appear after the total row for the item if you're displaying totals at the bottom for the field.


Select to turn on automatic page breaks after each item in the fields. You can turn on automatic page breaks for all but the innermost (rightmost) row field. Any page breaks you move and any manual page breaks you set will remain in place.


Microsoft Excel automatically determines the starting number from the source data when you group numbers in a field. If you want to start grouping with a different number, type the number in the Starting at box.


Microsoft Excel automatically determines the ending number from the source data when you group numbers in a field. If you want to stop grouping at a different number, type the number in the Ending at box.


Microsoft Excel automatically determines the number of items in each group when you group numbers in a field. Type a number in the By box to change the number of items in each group.


Click a page field to create separate copies of the PivotTable report on new worksheets; each worksheet will show one of the different page field items.


Type a new name to change the name of the report. In a PivotChart report, this box contains the name of the associated PivotTable report, and changing it renames the PivotTable report, not the PivotChart report.


Displays grand totals for columns in a PivotTable report. In a PivotChart report, the grand totals are displayed in the associated PivotTable report.


Displays grand totals for rows in a PivotTable report. In a PivotChart report, the grand totals are displayed in the associated PivotTable report.


Applies the default Microsoft Excel autoformat to your PivotTable report. Use the Format Report command on the PivotTable toolbar to apply a different autoformat to your PivotTable report. This option is not available in PivotChart reports.


Includes hidden page field items in PivotTable report subtotals. In a PivotChart report, the subtotals are affected in the associated PivotTable report. This option is not available in reports based on source data from OLAP databases.


Select to merge cells for all outer row and column labels in the PivotTable report. This option is not available in PivotChart reports.


Select the For error values, show check box to display a value in place of an error; then type a value to display. This option is not available in PivotChart reports.


Select the For empty cells, show check box to display a value in place of blank cells; then type a value to display. This option is not available in PivotChart reports.


Retains any formatting you apply to PivotTable report data whenever you refresh the report or change its layout. This option is not available in PivotChart reports.


Select the order in which you want page fields to appear. The default page field layout is Down, then over. This option is not available in PivotChart reports.


Select the number of page fields you want to include in a row or column before starting another row or column of page fields. This option is not available in PivotChart reports.


Saves a copy of the internal data for the report in the workbook file so that you do not have to refresh the report before you can work with it when you open the workbook file.

If you do not select this option, your workbook file will be much smaller. However, you must either select the Refresh on open check box or click Refresh Data on the PivotTable toolbar when you open the workbook before you can work with the report. If you do not save this data, it will also be discarded from other reports in the workbook that are based on this PivotTable report or the PivotTable report associated with the current PivotChart report. This option is ignored in report template files.


Clear the check box to prevent showing detail when you double-click a cell in the data area of a PivotTable report. In a PivotChart report, this option affects only the associated PivotTable report. This option is not available for reports based on source data from OLAP databases.


Select to save memory when you refresh your report from an external data source. This option is not available for reports based on source data from Microsoft Excel lists or from OLAP databases.


Updates PivotTable report and PivotChart report data from the source data whenever you open the workbook.


If you use an external database that requires a password as your data source for the PivotTable or PivotChart report, select the Save password check box to store the password as part of the report. When you update your report, you do not need to reenter the password.


Clear to wait for the data to be retrieved when you run the query to retrieve the external data for the report. When this check box is selected, Microsoft Excel runs the query in the background while you continue your work. This option is not available for reports based on source data from OLAP databases.


Sets options for PivotTable report and PivotChart report data obtained from an external data source. These options are available only if your report is based on external data.


Sets options for formatting and displaying PivotTable and PivotChart reports.


Select to use the field and item labels in the PivotTable report as row and column print titles. If you change the report layout so that the field and item labels are in different rows and columns, the new label rows and columns are automatically used as the print titles.

Before you select this check box, click Page Setup on the File menu, click the Sheet tab, and clear the Rows to repeat to top and Columns to repeat at left check boxes, and make sure the current report is the only one in the print area.


Select to automatically refresh the PivotTable or PivotChart report from the external source data, and then enter the number of minutes to wait between refreshes in the minutes box.


Select to print outer row field item labels at the top of each printed page. Item labels are repeated for all row fields to the left of the field for which a page break separates a group of items. Clear this check box to print the item labels on only the first printed pages where they appear.


Mark totals with *
Displays an asterisk (*) after every subtotal and grand total in PivotTable reports that are based on OLAP source data to indicate that these values include any hidden items as well as the displayed items. Clear this check box if you do not want to see the asterisks.


Select a cell in the specific row, column, or data field you want to sort.


Sorts the lowest number, the beginning of the alphabet, or the earliest date first in the selected row, column, or data field.


Sorts the highest number, the end of the alphabet, or the latest date first in the selected row, column, or data field.


Displays the type of sort, based on the active cell. If the active cell under Sort by is a field button for a row or column field, the Labels option is automatically selected. The Labels option sorts by the item labels for the field. If the active cell is an item in a row or column field, the Values option is automatically selected. The Values option sorts a field by values in the data area.


Specifies a custom sort order for the row, column, or data field specified in the Sort by box. You can also choose a case-sensitive sort or change the sort orientation from top to bottom to left to right.


Describes the sort that will be performed for the options you have selected.


Click an option below to specify the source you want to create your PivotTable or PivotChart report from.


Shows the type of source data and report you have selected.


Creates a PivotTable or PivotChart report from data organized in labeled rows and columns on a Microsoft Excel worksheet.


Creates a PivotTable or PivotChart report from data stored in a file or database outside the current workbook or Microsoft Excel.


Creates one PivotTable or PivotChart report from multiple Microsoft Excel worksheet ranges.


Creates a PivotTable or PivotChart report from another PivotTable report in the same workbook.


Click an option below to specify what type of report you want to create.


Creates a PivotTable report.


Creates a PivotChart report and an associated PivotTable report that shares the same data and reflects all changes to the PivotChart report. A PivotChart report must have an associated PivotTable report in the same workbook.


Specify data for your PivotTable or PivotChart report. Type the range in the Range box, or select the data on the worksheet. The Collapse Dialog button at the right end of this box temporarily moves the dialog box so that you enter the range by selecting cells on the worksheet. When you finish, you can click the button again to display the entire dialog box.

Click the worksheet tabs to select from other worksheets. If the range is from another workbook, type the workbook name and sheet name in the Range box by using this syntax:

([workbookname]sheetname!range)


Click Browse to select a different workbook that contains the list or data range you want to use.


If no data fields have been retrieved, click Get Data to create a PivotTable or PivotChart report with data from an external database by using Microsoft Query. If data fields have been retrieved, click Get Data to select different external data to be used for the report.


Specify the range for each consolidation source you want in your PivotTable or PivotChart report. Type the sheet name and range reference in the Range box. The Collapse Dialog button at the right end of this box temporarily moves the dialog box so that you enter the range by selecting cells on the worksheet. When you finish, you can click the button again to display the entire dialog box.

If the range is from another workbook, type the workbook name and sheet name in the Range box, using this syntax:

([workbookname]sheetname!range)

Click Add to enter the reference in the All ranges box. Repeat this procedure for each range you want to consolidate in your PivotTable or PivotChart report.


Adds the reference in the Range box to the list of references in the All ranges box.


Deletes the reference selected in the All ranges box. This does not affect the source data.


Lists all the worksheet ranges that will be consolidated or combined in your PivotTable or PivotChart report.


Click a number to specify the number of page fields you want displayed in your PivotTable or PivotChart report.


Assigns item labels that each page field will use to identify your data ranges. Select a range in the All ranges box, and then type or select an item label in the Field box. You can use any text you want for the item labels. Repeat this procedure for each range and page field that you want to use to identify the range.


Creates only one page field for a PivotTable or PivotChart report that you create from multiple Microsoft Excel consolidation ranges. With a single page field, you can view and combine all of your consolidated ranges with a drop-down list.


Customizes page fields for a PivotTable or PivotChart report that you create from multiple Microsoft Excel consolidation ranges. You can assign separate names to your ranges in as many as four page fields.


When you create a PivotTable or PivotChart report from multiple consolidation ranges, you can use page fields to display data for one item independent of other items in a field. When you select an item in a page field, the data shown in the PivotTable or PivotChart report changes.


Specify an existing PivotTable report to use as the data source for your new PivotTable or PivotChart report. Only PivotTable reports in the active workbook are shown in the box. If your workbook contains PivotTable reports that have one or more page fields set to query external data for each item separately, these reports are not included in the list.


Drag field names into the Row, Column, Data, or Page area to design the layout of your PivotTable or PivotChart report. You can drag fields onto any area you want. After you drag a field, in reports based on source data other than OLAP databases, you can double-click the field button to customize how the field data is summarized.


Shows how you drag the field buttons to lay out the PivotTable or PivotChart report.


Displays Microsoft Excel Help for the PivotTable and PivotChart Wizard Layout dialog box.


Specify the location of your PivotTable report. If you are creating a PivotChart report, an associated PivotTable report will be created in the location you specify. This PivotTable report must be in the same workbook as the PivotChart report. If you specify a location in another workbook, the PivotChart report will also be created in that workbook.

To set advanced options, click Options.


Creates a new worksheet in the same workbook for the PivotTable report.


Select the cell on the worksheet, or type a cell reference in the Existing worksheet box, to specify the upper-left cell of the range on the worksheet where you want the PivotTable report to be placed. The Collapse Dialog button at the right end of this box temporarily moves the dialog box so that you enter the range by selecting cells on the worksheet. When you finish, you can click the button again to display the entire dialog box.


Click Finish to create your PivotTable or PivotChart report. Click Options to set advanced options for your report.


Sets advanced formatting, layout, memory management, and external data options for your PivotTable or PivotChart report.


Microsoft Excel automatically creates an associated PivotTable report when you create a new PivotChart report. Both reports share the same data; when you change the view or layout of one report, the view or layout of the other report also changes. If you delete the associated PivotTable report, the PivotChart report becomes static, so you can no longer change its layout and view.


Click to lay out the PivotTable or PivotChart report in a dialog box rather than using on-sheet layout with certain external database sources, including large databases. For example, data retrieval is likely to be slow if you use on-sheet layout for a report based on a cube created by using the OLAP Cube Wizard in Microsoft Query.

You can also use this dialog box to change the page field settings to create page fields that retrieve data for each item separately. Page field options are available only for reports based on external non-OLAP source data.


Click Options to specify which elements of the autoformat you want to apply.


Select a table format from the samples. Click OK to format a table automatically with the selected autoformat. Click None to remove an autoformat from the selected table on your worksheet.


Shows how your table will look with the selected autoformat from the Table format box.


Clear the check boxes for the format types you don't want to use in the autoformat.


Enter the input cell reference for a one-variable data table when input values are in a row. For a two-variable data table, enter references in both this box and the Column input cell box.


Enter the input cell reference for a one-variable data table when input values are in a column. For a two-variable data table, enter references in both this box and the Row input cell box.


Displays all rows that have data in this column that meet the criteria you specify.


Select Top or Bottom to display the rows with high or low values for this column.


Select the number of items or the percentage of the whole list that you want to display.


Select Items to display the rows with the high or low  values for this column, or select Percent to display the rows with values that make up the high or low percentage of the whole list for this column.


Displays items you can select to show or hide in the field. In reports based on source data from OLAP databases, click the plus sign (+) or minus sign (–) for an item to display different levels of detail. Double check marks indicate that some or all of the lower-level items are displayed.


If items in your text file are separated by tabs, colons, semicolons, or other characters, select Delimited. If all of the items in your text file are the same length, select Fixed width.


Enter the row number to specify the first row of the data you want to import.


Click a format in the File origin box to specify the text file format.


Select the delimiter that your data contains.


Separates your tab-delimited data into columns.


Separates your semicolon-delimited data into columns.


Separates your comma-delimited data into columns.


Separates your space-delimited data into columns.


Separates your data into columns using the custom delimiter your data contains.


Click Treat consecutive delimiters as one if your data contains a delimiter of more than a one-character between data fields or contains multiple custom delimiters.


Select the delimiter your data contains. If the character you want is not listed, select the Other check box, and then type one or more characters in the box containing the insertion point. These options are not available if your data type is Fixed width.


Under Data preview, lines with arrows indicate that a break line for a column or field delimiter has been found. Click at the desired position to create an additional break line. Double-click on the line to delete an existing break line. Click and drag a break line to move it to another position in the text.


Select the column under Data preview. Then under Column data format, click the data format that you want to apply to the selected column of converted text. Once you select a data format option for the selected column, the column heading under Data preview will display the applied format. If you select Date, select a date format in the Date box.

To exclude a column of data when you import the text file, select the column under Data preview, and select Do not import column (skip).


Shows how your text will look when separated into columns on the worksheet.


Specifies the type of decimal and thousands separators to display in a text file. When the file is opened in Microsoft Excel, the separators displayed will match those specified for your country in Regional Settings (Windows Control Panel).


Click to display separators that match the settings for separators in Regional Settings (Windows Control Panel).


Select the decimal separator used in the text file. For example, if the separator in the file is a comma, select "," to display 9,35 as 9.35. If the separator is a period, select "." to display 9.35 as 9,35.


Select the thousands separator used in the text file. For example, if the separator in the file is a period, select "." to display 1.985 as 1,985. If the separator is a comma, select "," to display 1,985 as 1.985.


Resets the separators to those specified in Regional Settings (Windows Control Panel).


Displays numerical separators so that they match those specified in Regional Settings (Windows Control Panel) when you open a text file in Microsoft Excel.


Double-click the window name in the list to display a hidden window.


ActiveX controls

Controls you add with the Control Toolbox. ActiveX controls are embedded OLE objects. Don’t confuse ActiveX controls with Microsoft Excel controls (controls you add with the Forms toolbar).


coordinate pair

A pair of values representing the x- and y-coordinates of a point that are stored in a one-based two-dimensional array that can contain coordinates for many points.

The following example creates a one-based array that contains the coordinate pairs 50, 150, 100, 200, and 150, 250. Note that when you dimension the array, the size of the first dimension is the number of points you want to include, and the size of the second dimension is two (the first position within the dimension is for the x-coordinate, the second is for the y-coordinate).

Dim cpArray(1 to 3, 1 to 2)

cpArray(1, 1) = 50	' The x coordinate of the first point.

cpArray(1, 2) = 150	' The y coordinate of the first point.

cpArray(2, 1) = 100	' The x coordinate of the second point.

cpArray(2, 2) = 200	' The y coordinate of the second point.

cpArray(3, 1) = 150	' The x coordinate of the third point.

cpArray(3, 2) = 250	' The y coordinate of the third point.


cube

A data structure containing Online Analytical Processing (OLAP) data. The data in a cube consists of dimensions and data fields. Dimensions organize the types of data into hierarchies with levels of detail, and data fields measure the quantities being tracked in the database. For example, a cube could have a geographic dimension that has levels Country, Region, and City; a product dimension that has levels Product Category and Product Name; and a data field Sales Amount, which has values for the intersection of each geographic and product level.


default properties and methods

Many objects have a default property or method. Visual Basic applies the default property or method to a given object to resolve an expression that wouldn’t otherwise be valid. You can write statements that use default properties or methods more concisely by omitting the default keywords. For example, the Item property is the default property for most collections in Microsoft Excel, so the following two statements are identical:

ActiveWorkbook.Worksheets.Item(1).Cells.Item(1, 1).Value = 5

ActiveWorkbook.Worksheets(1).Cells(1, 1).Value = 5


default shape

An invisible shape that contains the initial properties for newly created shapes.


design and run modes

In design mode, you can design custom dialog boxes and controls and write code. Events do not fire and event procedures do not automatically run in design mode.

In run mode, you interact with your application the way a user would: events occur, and event procedures run. You cannot edit code in run mode.


early and late binding

When you create an object variable in one application that refers to an object supplied by another application, Visual Basic must verify that the object exists and that any properties or methods used with the object are specified correctly. This verification process is known as binding. Binding can occur at run time (late binding) or at compile time (early binding). Late bound code is slower than early bound code. To make your code early bound, and therefore more efficient, you must set a reference to the type library that contains the objects you want to refer to, and you must declare your object variables as specific types.


level

In an Online Analytical Processing (OLAP) dimension, data is organized into lower and higher levels of detail. For example, a geographic dimension could have levels Country, Region, and City; and a time dimension could have levels Year, Quarter, Month, and Day. In a PivotTable or PivotChart report that's based on source data from an OLAP database, an item at a particular level corresponds to a member, in OLAP terminology.


Microsoft Excel controls

Controls you add with the Forms toolbar. Don’t confuse Microsoft Excel controls with ActiveX controls (controls you add with the Control Toolbox).


OLAP provider

A set of software that provides access to a particular type of Online Analytical Processing (OLAP) data source. This software can include a data source driver and other client software that’s necessary to connect to a database. Third-party OLAP providers may or may not be compatible with Microsoft Query features, depending on whether the provider is Microsoft Office-compatible and includes support for these features.


offline cube file

A file on your hard disk or a network share that contains Online Analytical Processing (OLAP) data and provides source data for a Microsoft Excel PivotTable or PivotChart report. You can create an offline cube file from data retrieved from a relational database, such as Microsoft SQL Server. Using offline cube files, you can continue working with a report when you’re disconnected from the network or the original database server is unavailable.


Online Analytical Processing (OLAP)

A database technology optimized for querying and reporting, instead of processing transactions. OLAP data is organized hierarchically and stored in cubes instead of tables.


point

A unit of measurement equal to 1/72 inch.


RGB value

Value returned by the RGB function; specifies a color as a combination of red, green, and blue values. The RGB function has the following syntax:

RGB(red, green, blue)

The arguments specify the red, green, and blue components of the color as integers from 0 to 255.


standard PivotTable report selection format

A string expression used to specify part of a PivotTable report. The easiest way to understand the required syntax is to turn on the macro recorder, select cells in the PivotTable report, and then study the recorded code.

You can refer to a particular cell only if the PivotTable selection string contains the names of all the items used to identify individual cells in the selection. The number of items in that string should be equal to number of fields in the view for a cell in a normal data area. If the cell is used in calculating a subtotal or grand total, the number of items in the string would be fewer (including 0 (zero) for the intersection of the column and row grand totals).

The item names in the string can appear in any order. If an item name is ambiguous because it appears in another field as well, it must be qualified by "Field[Item]." If an item name contains symbols and spaces, or if it doesn’t start with an alphabetic character, it should be enclosed in single quotation marks. If an item name contains embedded single quotation marks, each of these marks must be converted to two single quotation marks. Quotation marks aren’t required for spaces if the name is unambiguous, and they’re not required for unqualified names that begin with numbers.


text frame

The area within a shape that can contain text.


x-, y-, and z-axes

The three mutually perpendicular lines that are used to locate a point in a Cartesian coordinate system. Note that in the Microsoft Office drawing layer, the x-axis runs horizontally across your document; the y-axis runs vertically; and the z-axis, which exists only in three-dimensional documents, runs perpendicular to the plane of your document (appearing to project out toward you).


Turns on both workbook sharing and the change history so that you can highlight subsequently made changes. If the workbook is already shared and you clear this check box, the workbook is removed from shared use and the change history is turned off so that changes to the workbook can no longer be highlighted. Make sure the Highlight changes on screen check box is selected to highlight changed cells.


Select the Who check box to highlight changes in the workbook made by the person or persons selected in the Who box.


Highlights changes to the worksheet. To show details about changes, rest the pointer over a highlighted cell. The row number for the row that contains a highlighted cell will also be highlighted.


Select the When check box to display changes for the interval of elapsed time you specify in the When box. Click All, Since I Last Saved, Not Yet Reviewed, or Since Date to change the unit of the time for which you want to display changes. If you click Since Date, type the date you want in the When box. If you click Not Yet Reviewed, you can highlight the changes that you have not yet reviewed by using Accept or Reject Changes on the Track Changes submenu of the Tools command.


Select the Where check box to highlight changes only for a specific range of cells. Hold down CTRL and click to select nonadjacent cells you want to highlight changes for. The Collapse Dialog button at the right end of this box temporarily moves the dialog box so that you enter the range by selecting cells on the worksheet. When you finish, you can click the button again to display the entire dialog box.


Displays the changes on a separate History worksheet that you use to filter the information to find the changes you want. This check box is available only after the workbook has been saved as a shared workbook.


Adds a new view of the workbook that includes column widths, row heights, display options, window size and position on the screen, window splits or frozen panes, the sheet that is active, and the cells that are selected. You can also optionally save hidden rows, hidden columns, filter settings, and print settings.


Deletes the view selected in the Views box.


Lists the views you've defined for the active worksheet.


Displays the view selected in the View list.


Type a password to prevent unauthorized users from removing workbook protection. A password is case-sensitive, can be up to 255 characters long, and can contain any combination of letters, numbers, and symbols.


Protects the structure of a workbook so that sheets can't be deleted, moved, hidden, unhidden, or renamed, and new sheets can't be inserted.


Protects a workbook's windows from being moved, resized, hidden, unhidden, or closed.


Select to divide the data from preformatted sections that you import into columns, by using the deliminters delimiting characters in the data to determine how to distribute the data in the columns. Clear this check box to place each row of data from preformatted sections in a single cell.


Select to import data without extra blank cells from multiple delimiting characters. For example, the series first,,,second results in the word "first" in one cell and "second" in the next cell, instead of "first" in one cell, three blank cells, and then "second" in the fifth cell. This check box is available only when you select the Import <PRE> blocks into columns check box.


Select to use your setting for Treat consecutive delimiters as one for all preformatted sections on the Web page. Clear this check box to use your setting for the first preformatted section only or if you want Microsoft Excel to determine the best settings. This check box is available only when you select the Import <PRE> blocks into columns check box.


Click an option to determine how preformatted sections are interpreted when data is retrieved from a Web page.


Select to make sure that numbers on a Web page that appear similar to dates (such as part number 01-01-23) appear as numbers and that dates appear as dates in Microsoft Excel when you run the Web query.


Enter the address for the Web page that contains data you want to retrieve. If you want Microsoft Excel to automatically fill in the address for you, click the Browse Web button.

If the Web site uses frames, make sure you enter the address of the Web page that contains the data, not the address of a frame or frames page. If you aren't sure what address to use, consult the owner of the Web site.


Starts your browser so that you can locate data on your intranet, the Internet, or the World Wide Web. After your browser locates the data you want to use for a Web query, Microsoft Excel automatically fills in the address for you.


Click an option to specify what part of the Web page you want to retrieve data from.


Retrieves an entire Web page, including text, tables, and other data.


Retrieves all tables and preformatted sections of a Web page. Use this option when the data you want is formatted with <PRE> tags, displayed in a table, or contains data you don't want to return to Microsoft Excel, such as pictures or animations.


Retrieves only the tables or preformatted sections you specify by entering table or section numbers or names.


Enter items in quotation marks, separated by commas — for example, "5","10","17" or "Table 1","Table 2". You can specify the tables and preformatted sections by counting them or by entering their names if the Web page names them.

Items are retrieved in the order that they appear on the Web page, not in the order you specify.


Saves a Web query in an .iqy file so that you can retrieve the same data in other workbooks or share the query with other users. If you don't save a Web query file, the query is saved as part of your Microsoft Excel workbook and you can run the query only from that workbook.


Click to select other retrieval options for preformatted sections and dates. For example, you can separate text into columns and select how to handle characters that define, or delimit, the text for each column.


Discards the Web page formatting, including fonts and colors, and imports the data into Microsoft Excel as plain text.


Keeps the Web page formatting, but without advanced formatting features such as hyperlinks and merged cells. This formatting is the type that Microsoft Excel can reproduce most closely.


Retrieves all of the Web page HTML formatting, including advanced formatting features such as hyperlinks and merged cells.


Click an option to specify the formatting from the Web page you want to keep.


Double-click a sheet name in the list to display a sheet in the active workbook.


Disconnects the selected user from the shared workbook. Click Remove to remove a user whose network connection is broken or who is no longer changing the workbook but has left a connection to the workbook open. Use caution: When removed with this option, someone who is currently changing a shared workbook will lose work in the shared workbook that has not been saved. A disconnected user can use Save As on the File menu to save the shared workbook with a new name, and if the change history was maintained in the original shared workbook, the user can merge the changes back into the original shared workbook.


Shows the names of users who are currently working on the workbook and the date and time they opened it.


Allows other users on your network to change the displayed workbook at the same time and to merge copies subsequently made of this workbook. Selecting this box will save the workbook as a shared workbook.


Provides you with updates of changes made and saved by other users whenever you save the workbook.


Provides you with updates of changes made and saved by other users at the interval you enter in the minutes box.


Changes from other users are updated to the workbook at the interval you specify, but your changes aren't saved at the time of the update.


Changes you make are saved, and changes from other users are updated to the workbook at the interval you specify.


Specifies how you want to review conflicting changes when you save the shared workbook.


Displays the Resolve Conflicts dialog box so that you can review each conflicting change and decide which changes to keep when saving the workbook.


Replaces any conflicting changes with your own changes each time you save. Clicking The changes being saved win prevents the Resolve Conflicts dialog box from displaying when you save a shared workbook.


Specifies personal printing and filtering options for the shared workbook. If you select one or both of the options below, your choices are independently saved with your copy of the shared workbook.


Saves personal print settings you have specified in the shared workbook. Print settings include page breaks, print areas, any settings you make in page break preview, and any settings in the Page Setup dialog box (File menu).


Saves any settings you make by using the commands on the Filter submenu of the Data menu, including filtering that you use the AutoFilter command for.


Specifies how often you want to see changes from other users.


Specifies whether to maintain the change history when you share the workbook. If you maintain the change history, you can review highlighted changes and merge changes from multiple copies of the same workbook for the interval you specify.


Maintains information on changes made to the workbook based on elapsed time. In the days box to the right of the Keep change history for box, enter the number of days you want to maintain the change history.


Turns off the change history. You can no longer merge changes from multiple copies of the same workbook or review highlighted changes.