To create a note, type the text you want in the Text Note box. To edit a note, click the note in the Notes In Sheet box, and then make the changes you want in the Text Note box. To start a new line in the Text Note box, press ENTER.


Lists the cell reference and partial note text for each note on the worksheet. If a cell contains a sound note, an asterisk (*) appears next to the cell reference.


Note command (Insert menu)

Attaches text comments or sound comments to a cell.


Displays the reference for the selected cell. To change the cell to which you want to attach the note selected in the Notes In Sheet box, type the cell reference in the Cell box.


Attaches a sound note to the cell specified in the Cell box. You must have the necessary hardware and software installed in your computer to record or play back a sound note.


To record a sound note, click Record. The Record button is unavailable if you do not have the necessary hardware and software installed to record sounds. If the selected cell has a sound note attached to it, the Record button changes to Erase so that you can remove the sound note.


To play a sound note in a selected cell, click Play.


To use a previously recorded sound note or an existing sound file, click Import.


To attach the selected text note or sound note to the cell specified in the Cell box, click Add. To attach the same note to another cell, click the cell on the worksheet, and then click Add.


To remove a note, select the note in the Notes In Sheet box, and then click Delete.


Add-ins command (Tools menu)

Specifies which add-ins are available automatically when you start Microsoft Excel. You can load or unload add-ins that come with Microsoft Excel as well as add-in programs that you create.


To load or unload an add-in program in Microsoft Excel, select or clear the check box next to the name of the add-in program in the Add-ins Available box.


To locate an add-in you want to load but that does not appear in the Add-ins Available box, click Browse. If an add-in that comes with Microsoft Excel is not on your computer, you can install the add-in. For more information, click  [image].


Error Bars command (Insert menu)

Adds error bars to and modifies existing error bars for data series in area, bar, column, line, and xy (scatter) charts. You cannot add error bars to 3-D, radar, pie, or doughnut charts.


To specify the type of Y error bars you want displayed, click an option under Display. Clicking None removes error bars.


To display plus and minus Y error bars, click Both.


To display plus Y error bars, click Plus.


To display minus Y error bars, click Minus.


To remove Y error bars, click None.


To specify how you want the error amount for the Y error bars to be calculated, click an option under Error Amount.


To use a fixed value as the Y error amount for all data points, click Fixed Value, and then type a value in the Fixed Value box.


To use a percentage of each data point as the Y error amount, click Percentage, and then type a number in the Percentage box.


To use the number of standard deviations from the mean of plotted values for the Y error amount, click Standard Deviation(s), and then enter a value in the Standard Deviation(s) box.


To use the standard error of the plotted values as the Y error amount for each data point, click Standard Error.


To use a custom value as the Y error amount for each data point, click Custom, and then type a value in the + box or the – box, or both.


To specify which type of X error bars you want displayed, click an option under Display. Clicking None removes error bars.


To display plus and minus X error bars, click Both.


To display plus X error bars, click Plus.


To display minus X error bars, click Minus.


To remove X error bars, click None.


To specify how you want the error amount for the X error bars to be calculated, click an option under Error Amount.


To use a fixed value as the X error amount, click Fixed Value.


To use a percentage of each data point as the X error amount, click Percentage.


To use a specific number of standard deviations from the mean of plotted values for the X error amount, click Standard Deviation(s).


To use the standard error of the plotted values as the X error amount for each data point, click Standard Error.


To use a custom value as the X error amount for each data point, click Custom, and then type a value in the + box or the – box, or both.


Trendline command (Insert menu)

Adds trendlines to, or changes the trendline type for, data series in area, bar, column, line, and xy (scatter) charts.


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


To insert a linear trendline, click Linear. This option creates a trendline using the linear equation y=mx+b.


To insert a logarithmic trendline, click Logarithmic. This option creates the trendline using the logarithmic equation y=clnx+b.


To insert a polynomial or curvilinear trendline, click Polynomial. This option creates the trendline using the polynomial equation  [image].


To insert a power trendline, click Power. This option creates a trendline using the power equation  [image].


To insert an exponential trendline, click Exponential. This option creates a trendline using the exponential equation  [image].


To insert a moving average trendline, click Moving Average. The number of points in a moving average trendline equals the total number of points in the series minus the number you specify for the period.


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


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


To specify how you want the trendline name to be created, click an option under Trendline Name. The name assigned to the trendline is displayed in the legend.


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


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


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


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


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


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


To display a trendline's regression equation in the trendline label in the chart, select the Display Equation On Chart check box.


To display a trendline's R-squared value in the trendline label in the chart, select the Display R-squared Value On Chart check box. The R-squared value that is displayed is not an adjusted value.


Trace Error command (Tools menu, Auditing submenu)

To draw tracer arrows from the cells that supply values to an active cell that contains an error value, click Trace Errors. Red arrows show the paths from cells that might have generated error values. To select the cell at the other end of an arrow, double-click the arrow.


Trace Precedents command (Tools menu, Auditing submenu)

Draws arrows to the cells that supply values directly to the formula in the active cell.


Trace Dependents command (Tools menu, Auditing submenu)

Draws an arrow from the active cell to the first formula that uses the values from the active cell.


Remove All Arrows command (Tools menu, Auditing submenu)

Removes all tracer arrows from the worksheet.


Auditing command (Tools menu)

Displays or removes colored tracer arrows that show the path of data and errors in a formula.


Show Auditing Toolbar command (Tools menu, Auditing submenu)

Finds cells that have a relationship to a formula, displays formulas affected by changes in a cell, and tracks down the sources of error values.


Trace Precedents button (Auditing toolbar)

Draws tracer arrows from the cells that supply values directly to the formula in the active cell (precedents). To trace the cells that supply values indirectly to the formula in the active cell, click the button again.


Trace Dependents button (Auditing toolbar)

Draws a tracer arrow to the active cell from the first formulas that uses the values from the active cell (dependents). To add additional levels of indirect dependents, click the button again.


Trace Error button (Auditing toolbar)

Draws tracer arrows from the cells that supply values to an active cell that contains an error value.


Remove All Arrows button (Auditing toolbar)

Removes all tracer arrows from the worksheet.


Remove Precedent Arrows button (Auditing toolbar)

Removes tracer arrows from one level of precedents on the active worksheet. To remove the next level of arrows, click the button again.


Remove Dependent Arrows button (Auditing toolbar)

Removes tracer arrows from one level of dependents on the active worksheet.


Attach Note button (Auditing toolbar)

Attaches text or audio comments to a cell.


Show Info Window button (Auditing toolbar)

Displays details about the selected cell.


New Data command (Insert menu)

Adds selected data series or data points to a chart.


To specify the range of cells you want to add to your spreadsheet, drag to select the new data, including the row and column labels. Or you can type the range in the Range box.


To change the order of the data series in a chart, click a series name in the Series Order box, and then click either the Move Up or Move Down button.


To move the selected data series up in the series order, click Move Up.


To move the selected data series down in the series order, click Move Down.


To see how your data series are arranged, view the display of your chart in the dialog box.


Page Setup command (File menu)

Controls the appearance of printed sheets, including margins, headers and footers, and printing options.


Page Break command (Insert menu)

Inserts a page break above and to the left of a selected cell.


To specify a worksheet range to print, click the Print Area box, and then drag through the worksheet areas that you want to print.


To specify the orientation for the printed page, click an option under Orientation.


To specify a paper or envelope size, click Letter, Legal, or other size options.


To enlarge or reduce the size of the printed worksheet, specify an option under Scaling.


To specify print quality for the active sheet, click the resolution you want. Resolution is the number of dots per inch (DPI) that will appear on the printed page. The higher the number, the better the quality.


To start numbering pages at "1" (if it is the first page in the print job), or at the next sequential number (if it is not the first page in the print job), enter Auto.

To specify a starting page number, enter the number.


To center the data on the page within the margins, select the Vertically check box, the Horizontally check box, or both.


To print horizontal and vertical cell gridlines on worksheets, select the Gridlines check box.


To print cell notes for the active worksheet, select the Notes check box.

To print notes with their cell references, select both the Notes check box and the Row And Column Headings check box.


To control the order in which data is numbered and printed when it does not fit on one page, click Down, Then Across or Across, Then Down.


If you formatted data with colors but are printing on a black-and-white printer, select this option. If you are using a color printer, selecting this option might reduce printing time.


To reduce printing time, click the Draft Quality check box. In Draft Quality, Microsoft Excel does not print gridlines and most graphics.


To print the same column or row title on pages in a selected worksheet, select an option under Print Titles. Then on the worksheet, select the column or row you want to print on every page as titles, or enter a cell reference or a defined name.


To print row numbers and column letters in the A1 reference style, or numbered rows and columns in the R1C1 reference style, select the Row And Column Headings check box.


To use a built-in header, click a header in the Header box.


To use a built-in footer, click a footer in the Footer box.


To display or print the footer in the bottom-left corner of the worksheet, enter the text you want in the Left Section box.

To display or print the footer centered at the bottom of the worksheet, enter the text you want in the Center Section box.

To display or print the footer in the bottom-right corner of the worksheet, enter the text you want in the Right Section box.


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 as a field that Microsoft Excel updates automatically when you add or delete worksheets.


Total Pages button

Inserts the total number of pages in the active worksheet and adjusts the page numbers automatically when you add or delete worksheets. 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.


Filename button

Inserts the filename of the active workbook.


Sheet Name button

Inserts the name of the active worksheet.


To display or print the header in the upper-left corner of the worksheet, enter the text you want in the Left Section box.

To display or print the header centered at the top of the worksheet, enter the text you want in the Center Section box.

To display or print the header in the upper-right corner of the worksheet, enter the text in the Right Section box.


Background command (Format menu, Sheet submenu)

Inserts a tiled graphic image in the worksheet background.


Show Document command (Window menu)

Switches from the Info window back to the active document.


To add a word to the AutoCorrect list so that Excel can correct it automatically as you type, click AutoCorrect.


To specify how and when you want to save documents, including adding a password or opening the document as read-only, click Options.


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


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


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


 To reduce or enlarge 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.


To reduce the worksheet or selection when you print so that it fits on the specified number of pages, select the Fit To check box, and then enter a number in the Pages Wide By box..


To select options, such as what to print and how many copies to print, click Print.


To display each page as it will look when printed, click Print Preview.


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


To specify printing options, such as gridlines, notes, or row and column headings, select one or more options under Print.


Text To Columns command (Data menu)

Starts the Convert Text To Columns Wizard to help you specify how you want lines in a text file to be divided into cells on a worksheet.


To specify the key you press to activate the Microsoft Excel menu bar or online Help for Lotus 1-2-3 users, enter the key in the Microsoft Excel Menu Or Help Key box. To specify other transition options, select the option you want under Sheet Options.


To activate the Microsoft Excel menu bar when you press the Microsoft Excel Menu Or Help key, select the Microsoft Excel Menus check box.


To activate Help for Lotus 1-2-3 when you press the Microsoft Excel Menu Or Help key, select the Lotus 1-2-3 Help check box.


To activate an alternate set of keys for worksheet navigation, formula entry, label entry, and other actions, select the Transition Navigation Keys check box.


To open Lotus 1-2-3 files without losing or changing information, select the Transition Formula Evaluation check box. With this option selected, Microsoft Excel evaluates text strings as 0, Boolean expressions as 0 or 1, and database criteria according to the rules used in Lotus 1-2-3.


To convert formulas entered in Lotus 1-2-3 release 2.2 syntax to Microsoft Excel syntax and make names defined in Microsoft Excel behave like names defined in Lotus 1-2-3, select the Transition Formula Entry check box.


To select a color from the palette of available standard colors, click the color to the right of Standard Colors.


To select from the eight colors that Microsoft Excel uses to fill charts, click the color to the right of Chart Fills.


To select from the eight colors that Microsoft Excel uses for chart lines, click the color to the right of Chart Lines.


To select from the 24 additional colors you can use throughout a workbook, click a color to the right of Other Colors.


To copy a color palette to the active workbook from another workbook, click the name of the other workbook in the Copy Colors From box.


To reset the color palette to its original 56 colors, click Reset.


To create custom colors by editing any of the original 56 colors on the color palette, click Modify.


Consolidate command (Data menu)

Summarizes the data from one or more source areas and displays it in a table.


To specify the function that Microsoft Excel uses to consolidate data, select a worksheet function in the Function box.


To specify each range from which you want to consolidate data, add the source areas in the Reference box.

For more information, click [image].


Lists all of the source area references that you have selected for the consolidation.


To specify which labels to use when you consolidate by category, select either Top Row or Left Column or both check boxes. If you are consolidating by category, the source areas must include identical labels for similar data.


To update the destination area data automatically when the data in any of the source areas changes, select the Create Links To Source Data check box.


To select a file that contains a source area for consolidation, click Browse.


To include the source area displayed in the Reference box, click Add.


To remove the source area displayed in the Reference box, click Delete.


If items in your text file are separated by tabs, colons, semicolons, or other characters, select the Delimited check box. If all of the items in your text file are the same length, select the Fixed Width check box.


To specify the first row of the data you want to import, enter the row number.


To specify the text file format, click a format in the File Origin box.


To specify the character used to separate items in your text file, select the check box for the delimiter you want. 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.


To have Microsoft Excel interpret two delimiter characters with nothing between them as a single delimiter, select the Treat Consecutive Delimiters As One check box. For example, select this option if you want toplace "Jones,, Tom" in two columns rather than three.


To specify the character used to enclose strings of text, click the character you want in the Text Qualifier box. For example, if you select comma as the delimiter and single quotation mark as the text qualifier, "Johnson, 'Manager, Sales' " will be placed into two columns rather than three.


To specify the data format Microsoft Excel should assign to each column of converted text, select the column heading in the dialog box and then select the check box for the option you want. To exclude a column of data, select the Do Not Import Column (Skip) check box.


On This Sheet (Insert menu, Chart submenu)

Starts the ChartWizard, which guides you through the steps required to create a new chart based on the selected worksheet data. To set the location and size of the chart on your worksheet, position the cross hair where you want it, click, and then drag. To specify that the chart be a perfect square, hold down SHIFT as you drag.


To specify the data you want to plot, click in the Range box, and then select the data on your worksheet. If you selected the data before activating the ChartWizard, the range already appears in this box.


To specify a chart type, double-click the type you want.


To specify a format for the chart type, double-click the format you want.


To see how the options you select will affect your chart, view the sample chart.


To specify that your data series are in rows, select the Rows check box.


To specify that your data series are in columns, select the Columns check box.


To specify the number of columns to be used for category (x) axis labels, enter a number in this box.

To specify the number of rows to be used for category (x) axis labels, enter a number in this box.


To specify the number of columns at the left of your selected data to be used for legend text, enter a number in this box.

To specify the number of rows at the top of your selected data to be used for legend text, enter a number in this box.


To create a chart with a legend, click Yes.


To create a chart without a legend, click No.


To add a title to the chart, type a title in the Chart Title box.


To add titles to axes, type the titles in the boxes under Axis Titles.


To add a title to the category (x) axis, type the title in the Category (X) box.


To add a title to the value (y) axis, type the title in the Value (Y) box.

To add a title to the value (z) axis, type the title in the Value (Z) box.


To add a title to a second (y) axis, type the title in the Second Y box.

To add a title to a series (y) axis, type the title in the Series (Y) box.


Titles command (Insert menu)

Adds titles to your chart.


To attach text to the chart elements, select the check boxes for the options you want under Attach Text To.


To attach or link text in the worksheet to titles in the chart, select the Chart Title check box.


To attach or link text in the worksheet to the value (y) axis, select the Value (Y) Axis check box.


To attach or link text in the worksheet to the category (x) axis, select the Category (X) Axis check box.


To attach or link text in the worksheet to the second value (y) axis, select the Second Value (Y) Axis check box.


To attach or link text in the worksheet to the second category (x) axis, select the Second Category (X) Axis check box.


To attach or link text in the worksheet to the value (z) axis, select the Value (Z) Axis check box.


To attach or link text in the worksheet to the series (y) axis, select the Series (Y) Axis check box.


Data Labels command (Insert menu)

Adds data labels to a data series, to a data point, or to all of the data points in a chart.


To add or delete data labels to or from data points, data series, or all data points in a chart, select the options you want under Data Labels.


To delete data labels from selected data points, click None.


To display the value of the selected data points, click Show Value.


To display the percentage of the whole for the selected data points in pie and doughnut charts, click Show Percent.


To display the category assigned to the selected data points, click Show Label. For area charts, this option displays a list of series names.


In pie and doughnut charts, to display both the percentage of the whole and category or series names, click Show Label And Percent.


To link data in data labels directly from the worksheet, select the Automatic Text check box. Use this option to relink data labels to their source data after the labels have been edited.


To place the legend key — with the assigned format and color — next to the data label, select the Show Legend Key Next To Label check box.


Legend command (Insert menu)

Adds a legend to the right of the plot area and resizes the plot area to accommodate the legend.


Gridlines command (Insert menu)

Controls whether major and minor gridlines are displayed in the active chart.


To have gridlines appear on the category (x) axis, select the check boxes for the options you want under Category (X) Axis.


To display major gridlines on the category (x) axis, select the Major Gridlines check box.


To display minor gridlines on the category (x) axis, select the Minor Gridlines check box.


To have gridlines appear on the value (y) axis, select the check boxes for the options you want under Value (Y) Axis.


To display major gridlines on the value (y) axis, select the Major Gridlines check box.


To display minor gridlines on the value (y) axis, select the Minor Gridlines check box.


To have gridlines appear on the series (y) axis, select the check boxes for the options you want under Series (Y) Axis.


To display major gridlines on the series (y) axis, select the Major Gridlines check box.


To display minor gridlines on the series (y) axis, select the Minor Gridlines check box.


To have gridlines appear on the value (z) axis, select the check boxes for the options you want under Value (Z) Axis.


To display major gridlines on the value (z) axis, select the Major Gridlines check box.


To display minor gridlines on the value (z) axis, select the Minor Gridlines check box.


To give the walls and gridlines for 3-D bar charts, 3-D area charts, and 3-D column charts a two-dimensional appearance, select the 2-D Walls And Gridlines check box.


Axes command (Insert menu)

Controls whether primary and secondary axes are visible on the active chart.


To display primary axes, select the check boxes for the options you want under Primary Axis.


To display the category (x) axis, select the Category (X) Axis check box.


To display the value (y) axis, select the Value (Y) Axis check box.


To display the series (y) axis, select the Series (Y) Axis check box.


To display the value (z) axis, select the Value (Z) Axis check box.


To display a secondary axis, select the check boxes for the options you want under Secondary Axis.


To display a secondary category (x) axis, select the Category (X) Axis check box.


To display a secondary value (y) axis, select the Value (Y) Axis check box.


Chart Type button (Chart toolbar)

Displays a palette of 14 chart types. Click a chart type to create an embedded chart or to change the type of the active chart.


Default Chart button (Chart toolbar)

Changes the active chart or the selected embedded chart to the default chart format.


ChartWizard button (Standard toolbar)

Starts the ChartWizard, which guides you through the steps for creating an embedded chart on a worksheet or modifying an existing chart.


Horizontal Gridlines button (Chart toolbar)

Shows or hides horizontal gridlines in charts.


Legend button (Chart toolbar)

Adds a legend to the right of the plot area and resizes the plot area to accommodate the legend. If the chart already has a legend, clicking the Legend button removes it.


Protect Workbook command (Tools menu, Protection submenu)

Protects a workbook's structure and windows. You can prevent changes to the structure of a workbook so that sheets can't be deleted, moved, hidden, unhidden, or renamed, and new sheets can't be inserted. You can also protect windows from being moved or resized.

When the active document is protected, the command name changes to Unprotect Workbook.


Unprotect Workbook command (Tools menu, Protection submenu)

Removes protection from the active workbook. If you assigned a password when you protected the workbook, you have to type that password to remove protection.


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


To protect the structure of a workbook so that sheets can't be deleted, moved, hidden, unhidden, or renamed, and new sheets can't be inserted, select the Structure check box.


To protect a workbook's windows from being moved, resized, hidden, unhidden, or closed, select the Windows check box.


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


To prevent changes to cells on worksheets or on Microsoft Excel 4.0 macro sheets, or to prevent changes to items in charts, select the Contents check box.


To prevent others from deleting, moving, editing, or resizing graphic objects on a worksheet, chart sheet, or Microsoft Excel 4.0 macro sheet, select the Objects check box.


To prevent changes to the definitions of scenarios on a worksheet, select the Scenarios check box.


Protect Sheet command (Tools menu, Protection submenu)

Prevents changes to cells on worksheets or Microsoft Excel 4.0 macro sheets, items in a chart or on a dialog sheet, graphic objects on a worksheet or chart sheet, or code in a Visual Basic module.


Unprotect Sheet command (Tools menu, Protection submenu)

Removes protection from the selected sheet. If you assigned a password when you protected the sheet, you have to type that password to remove protection.


To prevent selected cells from being changed, moved, resized, or deleted, select the Locked check box.

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


To prevent selected objects from being changed, moved, resized, or deleted, select the Locked check box.

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


To prevent the selected text box from being changed, moved, resized, or deleted, select the Lock Text check box.

Locking text boxes has no effect unless the sheet is protected.


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, which is in the folder in which you installed Microsoft Excel.


active sheet

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


array

Used to build single formulas that produce multiple results or that operate on a group of arguments arranged in rows and columns. There are two types of arrays in Microsoft Excel — 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 using the Clipboard.


pane

Panes allow you to view different areas of a large worksheet simultaneously. You can split a window into two panes either horizontally or vertically. With a vertical split, the panes scroll together vertically, but they scroll independently horizontally. With a horizontal split, the panes scroll together horizontally, but they scroll independently vertically. If you split the window both vertically and horizontally, you can display four panes.


view

You can save different display and print settings for a worksheet as a named view. You can create several different views of the same worksheet without having to save separate versions.


constraints

Limitations placed on a Solver problem. Constraints can be applied to changing cells, the target cell, or other cells directly or indirectly related to your problem. You can define two constraints for each changing cell you specify, and up to 100 additional constraints per Solver problem. The operators in the following table are available to apply to each constraint.

Operator	Meaning
<=	Less than or equal to
>=	Greater than or equal to
=	Equal to
int	Integer


regression analysis

A form of statistical analysis 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 computed from 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 position the pointer over the fill handle, the pointer changes to a black cross. Drag the fill handle to copy contents to adjacent cells or to create a series. Dragging the fill handle using the right mouse button displays a shortcut menu.


constant

A cell value that doesn't start with an equal sign. For example, the date, the value 210, and text are all constants. A formula, or a value resulting from a formula, is not a constant.


worksheet

Also called a spreadsheet. The worksheet is the primary document you use in Microsoft Excel to store and manipulate data. A worksheet consists of cells organized into columns and rows and is always part of a workbook.


module

A sheet in a workbook that contains sets of instructions (macros) for accomplishing specific tasks.


formula

A sequence of values, cell references, names, functions, or operators that's contained in a cell and produces a new value from existing values. A formula always begins with an equal sign (=).


alternate startup folder

A folder you specify in addition to Xlstart that contains workbooks or other files you want to open automatically when you start Microsoft Excel. Templates placed in this folder are added to the New dialog box, which is displayed when you click the New command on the File menu.


template

A workbook you create and then use as the basis for other similar workbooks. You can create templates for workbooks, worksheets, chart sheets, macro sheets, modules, and dialog sheets.


autotemplate

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


add-in

Files that can be installed to add commands and functions to Microsoft Excel.


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.


data table

A table consisting of formulas with results created by varying the value of either one or two input cells.


input cell

A cell in which input values from a data table are substituted.


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 either contiguous or noncontiguous.


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 move the active sheet rather than making a different cell active.


data region

A range of cells containing data and bounded by empty cells.


activate

To activate a chart sheet, worksheet, or other sheet, select the tab for the sheet in the workbook. Only one workbook sheet can be active at a time. When a sheet is active, its tab changes to differentiate it from other sheets in the workbook. The sheet you activate determines which menu bar and toolbars are displayed.

To activate an embedded chart, double-click it.


data marker

A bar, area, dot, slice, or other symbol in a chart that represents a single data point or value originating 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. 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. They can be formatted and moved, but not sized.


data series

A group of related data points plotted in a chart that originate from single worksheet rows or columns. Each data series in a chart is distinguished by a unique color or pattern. You can plot one or more data series in a chart. Pie charts have only one data series.


data points

Individual values plotted in a chart that originate from single cells on a worksheet. Data points are represented by bars, columns, lines, pie or doughnut slices, dots, and various other shapes. These shapes are called data markers. Data markers of the same color constitute a data series.


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. They can be selected and formatted. When you select any corner of the walls or floor, you can rotate the chart by dragging. You can also display the chart by using a different view.


trendline

A graphical representation of trends in data series. Trendlines are used for the study of problems of prediction, also called regression analysis. You can add trendlines to data series in 2-D area, bar, column, line, and xy (scatter) charts. Trendlines can be formatted.


trendline label

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


error bars

Graphical 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, and xy (scatter) charts. XY charts can also display x error bars. Error bars can be selected and formatted as a group.


legend

A box containing legend entries and keys that help to identify the data series (or categories) in a chart. The legend keys, to the left of each entry, show the patterns and colors assigned to the data series (or categories) in the chart.


gridlines

Lines you can add to your chart that extend from the tick marks on an axis across the plot area. Gridlines come in various forms — horizontal, vertical, major, minor, and combinations of these. They make it easier to view and evaluate data in a chart.


tick marks and tick-mark labels

Small lines that intersect an axis like divisions on a ruler. Tick marks are part of the axis and can be formatted with it. Tick-mark labels identify the categories, values, or series in the chart. They come from and are automatically linked to cells in your worksheet selection. They can be formatted  the same way as other chart text.


chart type group

A group of data series that are formatted as one chart type and displayed on the same axis. For example, a chart showing columns overlaid by lines contains two groups of data series — a column chart group and a line chart group. Every chart type group included in an active chart appears as a command at the bottom of the Format menu.


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 (y) axis, which is usually vertical, and categories are plotted along the category (x) axis, which is usually horizontal.


text box

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


group

In an outline or PivotTable, 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 cell reference

In a formula, specifies the exact address of a cell, regardless of the position of the cell containing the formula. An absolute reference takes the form $A$1, $B$1, and so on.


relative cell reference

In a formula, specifies the address of another cell in relation to the cell containing the formula. A relative reference takes the form A1, B1, and so on.


password

A password prevents access by unauthorized users to a protected cell, graphic object, sheet, workbook, folder, or file. A password can contain any combination of letters, numbers, spaces, and symbols. As you type the password, Microsoft Excel displays an asterisk (*) for each character you type. Passwords are case sensitive.


list

A labeled series of worksheet rows that contain similar sets of data, such as an invoice database or a set of client names and phone numbers. A list can be used as a database, where rows are records and columns are fields.

"List" can also refer to a contiguous range of data on a worksheet. A list has the same type of data in each column, such as text in one column and numbers in the next column. Working with lists is easier if your lists have column headings.


custom sort order

A nonalphabetic, nonnumeric sort order — such as Sunday, Monday, Tuesday; or Low, Medium, High. You can use one of the built-in custom sort orders or 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 used to find data by querying by example. Comparison criteria can be a series of characters you want matched, such as "Northwind Traders," or an expression, such as ">300."


comparison operator

A sign used in comparison criteria to compare two values. The six standard comparison operators are shown below.

Operator	Meaning
=	Equal to
>	Greater than
<	Less than
>=	Greater than or equal to
<=	Less than or equal to
<>	Not equal to


criteria range

A cell range containing a set of search conditions that you 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.


summary data

For automatic subtotals and worksheet outlines, all the rows or columns that summarize detail data. Summary data is usually 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 stored in a data source.


pivot area

The worksheet area into which you drag PivotTable fields to change them from one field orientation to another. For example, you can change a row field to a column orientation by dragging it with the mouse to the pivot area for columns.

The term "pivot area" also applies to the graphic representation of a PivotTable in Step 3 of the PivotTable Wizard.


PivotTable data area label

In a PivotTable, the cell that identifies the source field for the data area and the function used to calculate the values of cells. For example, a data label for a data area calculated using the default summary function in the Sales field reads "Sum of Sales."


PivotTable row field

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


PivotTable column field

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


custom calculation

A method of summarizing the values in selected cells in the data area of a PivotTable 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 row grand total.


summary function

A type of calculation that you direct Microsoft Excel to use when combining source data in a PivotTable or a consolidation table, or when inserting automatic subtotals in a list or database. Examples of summary functions include Sum, Count, and Average.


nonadjacent selections

A selection of two or more cells or ranges that don't touch each other. When plotting nonadjacent selections in a chart, be sure that the selections form a rectangular shape.


PivotTable data

In a PivotTable, the summarized data calculated from the data fields of a source list or table.


PivotTable page field

A field that's assigned to a page orientation in a PivotTable. Items in a page field are displayed one at a time in a PivotTable.


PivotTable

An interactive worksheet table that enables you to summarize and analyze data from existing lists and tables. Use the PivotTable Wizard to specify the list or table you want to use and to define how you want to arrange the data in the PivotTable. After you create a PivotTable, you can reorganize the data by dragging the fields and items.


source areas

The cell ranges from which the Consolidate command draws data to summarize in a specified destination area. Source areas can be on the active worksheet, on other worksheets in the same workbook, in inactive or closed workbooks, or on Lotus 1-2-3 worksheets.


destination area

The range of cells you select to hold the summarized data when using the Consolidate command. The destination area can be on the same worksheet as the source data, or it can be on a different worksheet.


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 used in the active cell. To display or hide the formula bar, click Formula Bar on the View menu.


dependents

Cells containing formulas that refer to the active cell.


precedents

Cells that are referred to by the formula in the active cell.


data source

A data source includes the data a user wants to access and the information needed to get to that data. Examples of data sources are:

•	A directory containing a set of dBASE files you want to access.

•	A SQL Server database, the server on which it resides, and the network used to access that server.


shortcut menu

A menu that shows a list of commands relevant to a particular item. You can display a shortcut menu for rows, columns, cells, worksheet buttons and text boxes, toolbars, charts and chart items, objects, PivotTables, and workbook tabs.

Click the right mouse button to display a shortcut menu, or press SHIFT+F10.


scenario

A named set of input values you can substitute in a worksheet model.


source data for PivotTables

The list or table used to create a PivotTable. 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.


PivotTable data area

The part of a PivotTable that contains summary data. Values in each cell of the data area represent a summary of data from the source records or rows.


PivotTable detail item

An item associated with an inner row or column field in a PivotTable.


PivotTable subtotal

A row or column that displays the total of detail items in a PivotTable field, using a summary function you choose.


PivotTable data field

A field in a source list or table that contains data you want summarized in a PivotTable. 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.


PivotTable field item

A subcategory of a PivotTable field. Field items in a PivotTable are derived from unique items in a database field or from unique cells in a list column. In a PivotTable, field items appear as row, column, or page labels.


PivotTable grand totals

Total values for all cells in a row or all cells in a column of a PivotTable. Values in a grand total row or column are calculated using the same summary function used in the data area of the PivotTable.


PivotTable block totals

Custom subtotals for the innermost column items or row items in a PivotTable. Block totals are inserted above the grand totals for columns or to the left of the grand totals for rows.


PivotTable field

A category of data that's derived from a field in a source list or table. For example, the Year field in a source list or database becomes the Year field in a PivotTable. Items from the source list or table — such as 1995, 1996, and so on — become subcategories in the PivotTable.


field button

Buttons in Step 3 of the PivotTable Wizard and also in a finished PivotTable on the worksheet that display field names from the PivotTable source data. Drag these buttons to row or column orientation to show items in the data field as row or column labels. Field buttons can also be dragged to 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.


outline

Worksheet data in which rows and columns of detail data are grouped so that you can create summary reports. You can hide the detail data and display only the rows and columns containing summary data such as totals and averages. A worksheet can contain only one outline. The outline can summarize either an entire worksheet or a selected portion of it.


outline symbols

Symbols in an outlined worksheet. You can use the  [image],  [image], and  [image] outline symbols to show or hide detailed data. To show or hide the symbols, click Options on the Tools menu, click the View tab, and then select the Outline Symbols check box.


copy area

The source cells for a copy-and-paste operation. After you copy cells, a moving border appears around them, indicating that they've been copied.

When you copy cells, references to 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 values that appears in the destination area. Microsoft Excel creates the consolidation table by applying the summary function you selected to the source area values you chose.


style

A collection of formats — such as font size, patterns, and alignment — that you can define and save as a group.


autoformat

A collection of formats — such as font size, patterns, and alignment — that you can 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 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 cell reference

A cell reference, such as A1, that tells Microsoft Excel how to find another cell by starting from the cell that contains the formula. Using a relative reference is like giving someone directions that explain where to go from where the person is starting out — for example, "go up two blocks and over one block."


goal seeking

A method of finding the input value a formula needs to return a given result. When goal seeking, Microsoft Excel varies the value in a cell you specify until a formula that's dependent on that cell returns the result you want. Use Goal Seek when you want to find a specific value for a particular cell by adjusting the value of only one other cell. To find the optimum value for a particular cell by adjusting the value of more than one cell, or to apply limitations to one or more values involved in the calculation, use Microsoft Excel Solver.


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. Data tables provide both a shortcut for calculating multiple variations in one operation and a way to view and compare the results on your worksheet.


section

Any combination of a sheet, view, and scenario you choose when creating a report. A report can contain several sections.


print area

If a worksheet includes a print area, only the print area will be printed. You create a print area using the Set Print Area command (File menu, Print Area submenu).


legend key

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


selection handles

Small black 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.


Delete command (Edit menu)

Removes selected cells, rows, or columns from a worksheet. The surrounding cells shift to fill the space.


To specify how cells shift to fill the space left by deleted cells, or to delete the entire row or column, select an option under Delete.


Paste Special command (Edit menu for charts)

Controls how the data series (that is, a series of values) is organized and plotted when pasted from a worksheet.


To specify how you want to add the selected data to the chart, select an option under Add Cells As.


To add selected data to the chart as a new data series, click New Series.


To add selected data to the chart as new data points in existing data series, click New Point(s).


To create the data series from the contents of each row or column in the copied selection, click Rows or Columns.


To create the data series from the contents of each row in the copied selection, click Rows.


To create the data series from the contents of each column in the copied selection, click Columns.


To use the first row or column of your selection as chart data series, select the Series Names In First Rows/Columns check box.


To use the first row or column of your selection as chart categories, select the Categories (X Labels) In First Row/Column check box.


To replace the existing chart categories with the categories you are pasting, select the Replace Existing Categories check box.


Paste Special command (Edit menu)

Pastes the values, formats, formulas, or notes of the copied cells into the selected cells. Paste Special also controls how data copied from another application is pasted.


To specify which attribute of the copied data you want to paste, select an option under Paste.


To paste all cell attributes, click All.

Note   Using the Paste command on the Edit menu has the same effect.


To paste only the formulas as entered in the formula bar, click Formulas.


To paste only the values as displayed in the cells, click Values.


To paste only cell formats, click Formats.


To paste only cell notes, click Notes.


To specify which mathematical operation, if any, you want to apply to the copied data, select an option under Operation.


To completely replace the cells in the paste area with the cells from the copy area, click None.


To add copied formulas or values to those in the paste area, click Add.


To subtract copied formulas or values from those in the paste area, click Subtract.


To multiply copied formulas or values by those in the paste area, click Multiply.


To divide copied formulas or values into those of the paste area, click Divide.


To avoid replacing values in your paste area with blank cells from the copy area, select the Skip Blanks check box.


When you paste, select the Transpose check box to change columns of copied data to rows, and vice versa.


To link the pasted data to its source document, click Paste Link.


Find command (Edit menu)

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


To specify what to search for, enter it in the Find What box.


In the Search box, select the direction by which you want to search. To reverse the search direction, hold down SHIFT while you click Find Next.


In the Look In box, select the worksheet attribute you want to search.


To distinguish between uppercase and lowercase characters, select the Match Case check box.


To search for an exact and complete match of characters specified in the Find What box, select the Find Entire Cells Only check box.


To find only whole words and not characters inside words, select the Find Whole Words Only check box. For example, select this check box to find "act", but not "acting".


To find words with a certain pattern of letters, select the Use Pattern Matching check box. For example, use "s?t" to search for "sat", "set", and so on. Other complex search criteria are available. For more information, click  [image].


To find the next occurrence of the characters specified in the Find What box, click Find Next. To find the previous occurrence, hold down SHIFT while you click Find Next.


To find and replace characters in selected cells or on the entire worksheet, click Replace.


Replace command (Edit menu)

Replaces characters in selected cells or on the active sheet.


To replace the characters in the Find What box, enter the replacement characters in the Replace With box. To delete the characters in the Find What box, leave the Replace With box blank.


In the Look In box, click the portion of the module you want to search.


To replace the searched characters in the active cell with the new characters, click Replace.


To find and replace every occurrence of the characters in the Find What box with the characters in the Replace With box, click Replace All.


Paste Values button (Edit category)

Pastes only the values from the cells that you have copied onto the Clipboard.


Cells (Insert menu)

Inserts a row, column, or range of blank cells equivalent in size and shape to the selected range.


Cut Cells (Insert menu)

Inserts the cells you defined with the Cut command.


Copied Cells (Insert menu)

Inserts the cells you defined with the Copy command.


To specify the direction you want to shift the surrounding cells, rows, or columns to make room for the inserted cells, select an option under Insert.


Rows (Insert menu)

Inserts a new blank row above the selected cell or row.


Columns (Insert menu)

Inserts a new blank column to the left of the selected cell or column.


Spelling button (Standard toolbar)

Checks the spelling of text in selected worksheets and charts, including text in text boxes, buttons, headers and footers, cell notes, and the formula bar.


Insert and Insert Cut or Copied Cells commands (Shortcut menu)

Inserts a row, column, or range of blank cells equivalent in size and shape to the selected range, or inserts the cells you defined with the Copy or Cut command.


Insert Paste Row command (Shortcut menu)

Inserts copied data in complete rows in a filtered list.


Spelling command (Tools menu)

Checks the spelling of text in selected worksheets and charts, including text in text boxes, buttons, headers and footers, cell notes, and the formula bar.


To replace a word not found in the dictionary, type the word you want in the Change To box or select it in the Suggestions box.


To add words that are correctly spelled but not found in the main dictionary, enter them in the Add Words To box. Microsoft Excel adds words to the dictionary CUSTOM.DIC unless you specify another dictionary.


To leave the selected word unchanged, click Ignore.


To leave the selected word unchanged throughout the sheet, click Ignore All.


To change the selected word to the word in the Change To box, click Change.


To change the selected word throughout the selected range or sheets to the word in the Change To box, click Change All.


To add the selected word to the dictionary in the Add Words To box, click Add.


To display a list of suggested words, click Suggest.


To display a list of suggested words whenever Microsoft Excel encounters a word that is not in the dictionary, select the Always Suggest check box.


To skip words that contain only capital letters, select the Ignore UPPERCASE check box.


To undo the last spelling change, click Undo Last.


To control how you enter, edit, copy, and move data, select options under Settings.


To keep objects with cells that you cut, copy, filter, or sort, select the Cut, Copy, And Sort Objects With Cells check box.


Insert button (Edit category)

Inserts a row, column, or range of blank cells equivalent in size and shape to the selected range, or inserts the cells you defined with the Copy or Cut command.


Insert Column button (Edit category)

Inserts a new blank column to the left of the selected cell or column.


Insert Row button (Edit category)

Inserts a new blank row above the selected cell or row.


Delete button (Edit category)

Removes selected cells, rows, or columns from a worksheet. The surrounding cells shift to fill the space.


Delete Column button (Edit category)

Removes selected columns from a worksheet. The surrounding columns shift to fill the space.


Delete Row button (Edit category)

Removes selected rows from a worksheet. The surrounding rows shift to fill the space.


Undo and Redo commands (Edit menu)

Reverses certain commands or deletes the last entry you typed.

•	The name of the Undo command reflects the command or action to be undone; for example, Undo Cut; Undo Typing.

•	The command name changes to Can't Undo if you cannot undo the previous action.

•	Immediately after you undo an action, this command name changes to Redo, allowing you to restore what you reversed.


Undo button (Standard toolbar)

Reverses certain commands or deletes the last entry you typed.


Repeat command (Edit menu)

Repeats your last command or action, if possible, including any dialog box settings.


Repeat button (Standard toolbar)

Repeats your last command or action, if possible, including any dialog box settings.


All command (Edit menu for worksheets, Clear submenu)

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


Formats command (Edit menu for worksheets, Clear submenu)

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


Clear Formats button (Edit category)

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

If a chart is active, the Clear Formats button removes the formatting from the selected chart item.


Contents command (Edit menu for worksheets, Clear submenu)

Removes the cell contents (data and formulas) from selected cells without affecting cell formats or notes.


Clear Contents button (Edit category)

Removes the cell contents from selected cells without affecting cell formats or notes.


Notes command (Edit menu for worksheets, Clear submenu)

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


All command (Edit menu for charts, Clear submenu)

Removes the selected chart item and its formatting.


Series/Trendline/Error Bars command (Edit menu for charts, Clear submenu)

Removes the selected data series (or points), trendline, or error bars.


Formats command (Edit menu for charts, Clear submenu)

Removes the formatting from any selected chart item; the data is not affected.


Go To command (Edit menu)

Scrolls through the worksheet and selects the cell or range you specify.


To select a named range on the active worksheet, or one of the last four references from which you chose the Go To command, click the name or reference in the Go To box.


To specify a reference or named range you want to move to, type it in the Reference box.


To move to cells with special characteristics, click Special.


To select all cells that contain a note, click Notes.


To select all cells whose values do not start with an equal sign, click Constants.


To select all cells that contain formulas, click Formulas and then select the check boxes for the specific type of formula result you want.


To select cells with formulas that produce numbers, select the Numbers check box. This option is available only after you click Formulas.


To select cells with formulas that produce text, select the Text check box. This option is available only after you click Formulas.


To select cells with formulas that produce the logical values TRUE or FALSE, select the Logicals check box. This option is available only after you click Formulas.


To select cells with formulas that produce error values, select the Errors check box. This option is available only after you click Formulas.


To select all blank cells, click Blanks.


To select a rectangular cell range around the active cell, click Current Region. The range selected is bounded by any combination of blank rows and blank columns.


To select the entire array, if any, to which the active cell belongs, click Current Array.


To select cells whose contents are different from the comparison cell in each row, click Row Differences. For each row, the comparison cell is in the same column as the active cell.


To select cells whose contents are different from the comparison cell in each column, click Column Differences. For each column, the comparison cell is in the same row as the active cell.


To select cells that are referred to by the formula in the active cell, click Precedents.


To select cells with formulas that refer to the active cell, click Dependents.


To select only cells directly referred to by formulas in the selection (precedents), or to select only cells with formulas that refer directly to the active cell (dependents), click Direct Only. This option is available only after you click Precedents or Dependents.


To select all cells directly or indirectly referred to by cells in the selection (precedents), or to select all cells that directly or indirectly refer to the active cell (dependents), click All Levels. This is useful for selecting the entire network of cells that affect a particular cell in a complex worksheet, or for tracking the logic of a model one step at a time. This option is available only after you click Precedents or Dependents.


To select the last cell in the worksheet that contains data or formatting, click Last Cell.


To select the visible cells on a worksheet so that changes you make affect only the visible cells and not the hidden rows or columns, such as in an outline, click Visible Cells.


To select all graphic objects, including buttons and text boxes, click Objects.


AutoFilter button (Data category)

Displays only those rows that match the value in the active cell and inserts AutoFilter arrows to the right of each column label.


To select comparison operators and values for a custom AutoFilter, select the operators in the boxes on the left, and type or select the values in the boxes on the right.


To specify two criteria for a custom AutoFilter, click:

•	The And option to combine two criteria.

•	The Or option to use either of two different criteria.


To specify the value you want to use with the comparison operator, type or select the value. For more information, click  [image].


AutoFilter command (Data menu, Filter submenu)

The quickest way to select only those items you want to display in a list.


Show All command (Data menu, Filter submenu)

Displays all of the rows in a filtered list.


Advanced Filter command (Data menu, Filter submenu)

Filters data in a list so that only the rows that meet a specified criteria range are displayed.


 To hide rows that do not meet the specified criteria, or to copy the filtered data to another location on the worksheet, click one of the options under Action.


To specify the range of cells you want to filter, enter the range in the List Range box.


To specify the range of cells that contains your criteria, enter the range in the Criteria Range box.


To copy the rows that meet your criteria, specify a range of cells in the Copy To box.


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


To filter a column by a unique value, click the AutoFilter arrow, and then select the value.


To display all rows that contain whatever upper or lower intervals you specify, select the top or bottom range and numeric interval, then select items or percent.


To specify how you want the chart to be scaled when printed, select the options you want under Printed Chart Size.


To expand the chart to fit the full width and height of the page margins, click Use Full Page. 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.


To expand the chart to the nearest page margin before printing, click Scale To Fit Page. The chart expands in both dimensions (width and height) proportionally until one dimension fills the space between the margins.


To scale the chart sheet on your screen to a size you've specified, click Custom.


To specify the printing quality of charts, select the options you want under Printing Quality.


To suppress the printing of graphics and cell gridlines, select the Draft Quality check box. This option reduces printing time; it also increases memory efficiency for plotters. Select this option when low memory causes printing problems.


To print your chart data series in black and white (patterns replace colors), select the Print In Black And White check box. On a color printer, other areas of the chart (for example, the plot area) are still printed in color. When the Print In Black And White check box is cleared, colors are printed as shades of gray on a black-and-white printer and as colors on a color printer.


Selected Chart Item command (Format menu)

Formats the selected chart item. The name of the command and the available formatting options vary depending on the chart item you've selected. For example, if you've selected a legend, the command is called Selected Legend.


To reposition the selected legend, click the option you want under Type.


To center the legend beneath the chart, click Bottom.


To position the legend in the upper-right corner of the chart, click Corner.


To center the legend above the chart, click Top.


To position the legend to the right of the chart, centered vertically, click Right.


To position the legend to the left of the chart, centered vertically, click Left.


To specify how worksheet values are to be plotted in the active chart, select the options you want under Active Chart. To specify that these options be the default settings for subsequent (new) charts, create a custom autoformat chart with these settings, and then designate it as the default chart.


To specify how empty worksheet cells are to be plotted in line charts, select the options you want under Empty Cells Plotted As. By default, blank worksheet cells are plotted only in line charts, not in other types of chart.


To leave gaps in the line for empty worksheet cells, making the line segmented, click Not Plotted (Leave Gaps).


To treat blank worksheet cells as zeros, click Zero.


To have Microsoft Excel interpolate data points that represent empty worksheet cells and fill in the gaps with connecting lines, click Interpolated.


To have Microsoft Excel automatically update the chart to reflect which cells are visible on the worksheet, select the Plot Visible Cells Only check box. To display the original worksheet range used to plot the chart, clear this check box.


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


To specify the default chart format on which new charts are to be based, select the options you want under Default Chart Format. The original default chart format, called Built-In, is a column chart. If you want new charts to be based on the default format that was used in Microsoft Excel version 4.0, click MS Excel 4.0.


To base the formatting of new charts on the formatting of the active chart, click Use The Current Chart, and then type a name for the chart in the Format Name box. The format of the active chart is then listed in the Default Chart Format box.


To specify a new default chart format, click a chart format in the Default Chart Format box. The original default chart format, called Built-In, is a column chart.


3-D View command (Format menu)

Controls the angle at which you view 3-D charts. A sample chart displayed in the dialog box shows the current settings.


To increase the elevation of the view in increments of 5 degrees, click the up arrow above the Elevation box. 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 to 80 degrees. For 3-D bar charts, the view ranges from 0 to 44 degrees.


To decrease the elevation of the view in increments of 5 degrees, click the down arrow above the Elevation box. 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).


To specify the height from which you want to view the chart, type a value in the Elevation box. 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).


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


To increase the Perspective setting in increments of 5 degrees, thereby increasing the depth of the chart, click the top arrow above the Perspective box. The perspective value specifies the ratio of the front of the chart to the back of the chart; it ranges from 0 to 100 degrees. This option is unavailable for 3-D bar charts or when the Right Angle Axes check box is selected.


To decrease the Perspective setting in increments of 5 degrees, thereby decreasing the depth of the chart, click the bottom arrow above the Perspective box. The perspective value specifies the ratio of the front of the chart to the back of the chart; it ranges from 0 to 100 degrees. This option is unavailable for 3-D bar charts and when the Right Angle Axes check box is selected.


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


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


To rotate the plot area to the left around the z-axis (vertical axis) in increments of 10 degrees, click the left-hand arrow to the right of the Rotation box. The rotation is measured in degrees from 0 to 360. For 3-D bar charts, the rotation ranges from 0 to 44 degrees.


To rotate the plot area to the right around the z-axis (vertical axis) in increments of 10 degrees, click the right-hand arrow to the right of the Rotation box. The rotation is measured in degrees, from 0 to 360. For 3-D bar charts, the rotation ranges from 0 to 44 degrees.


To scale a 3-D chart so that it's closer in size to the 2-D version, select the Auto Scaling check box. 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.


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


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, type a value in the Height box. The height is measured as a percentage of the x-axis length. For example, a value of 200% makes the chart height twice the length of the x-axis.


To apply the current settings to the active chart without closing the dialog box (so that you can see the effects of your changes in the sample chart), click Apply.


To reset all of the settings in the dialog box to the original default settings without closing the dialog box (so that you can see the effects of your changes in the sample chart), click Default.


Selected Axis command (Format menu)

Formats the pattern, scale, font, number, and alignment of the selected axis and axis label.


To apply a style, color, and weight to the selected axis line and its tick marks, select the options you want under Axis.


To apply the default settings to the selected axis, select the Automatic check box.


To make the selected axis invisible, select the None check box. Note that to make gridlines invisible, you must use the Gridlines command on the Insert menu.


To create a custom format for the style, color, and weight of the selected axis, select the Custom check box, and then select the options you want under the check box.


To change the line style of the selected axis, click an option in the Style box.


To change the color of the selected axis, click a color in the Color box.


To change the weight (thickness) of the selected axis, click an option in the Weight box.


To specify how major or minor tick marks (hash marks) are to be displayed for the selected axis, select the options you want under Tick Mark Type. You can specify whether the tick marks appear on the chart side of the axis, on the other side of the axis, or across the axis; or you can hide the tick marks altogether.


To specify how major tick marks are to be displayed for the selected axis, select the option you want under Major.


To hide major tick marks (hash marks) for the selected axis, select the None check box.


To display major tick marks on the chart side (inside) of the selected axis, select the Inside check box.


To display major tick marks on the outside of the selected axis, select the Outside check box.


To display major tick marks across the selected axis, select the Cross check box.


To specify how minor tick marks are to be displayed for the selected axis, select the option you want under Minor.


To hide minor tick marks (hash marks) for the selected axis, select the None check box.


To display minor tick marks on the chart side (inside) of the selected axis, select the Inside check box.


To display minor tick marks on the outside of the selected axis, select the Outside check box.


To display minor tick marks across the selected axis, select the Cross check box.


To specify whether you want tick-mark labels to appear at the low end of the selected axis, at the high end of the axis, or next to the axis, or to hide tick-mark labels altogether, select the option you want under Tick-Mark Labels.


To hide tick-mark labels for the selected axis, select the None check box.


To display tick-mark labels at the low end of the selected axis, select the Low check box.


To display tick-mark labels at the high end of the selected axis, select the High check box.


To display tick-mark labels next to the selected axis, select the Next To Axis check box.


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


To reverse the foreground and background colors for a data series when the value it represents is negative, select the Invert If Negative check box. This option applies to data series in bar, column, area, and pie charts.


To smooth out the angularity in the lines of a line chart or an xy (scatter) chart, select the Smoothed Line check box.


To specify how pictures are to be used to represent data markers, click the options you want under Picture Format.


To stretch the picture to fill the size of the data marker, click Stretch.


To stack pictures at their normal size to fit data markers, click Stack.


To stack and scale a predetermined number of pictures for each data marker, click Stack And Scale.


To specify the number of units per picture you want to use for each data marker, type a number in the Units/Picture box.


To link values from the chart to the worksheet data, select the Linked To Source check box. Changing data labels breaks the link. Rechecking this box restores broken links.


To specify the category number 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 frequency at which you want categories on the category (x) axis to be labeled, type a number in the Number Of Categories Between Tick-Mark Labels box. Type 1 to label every category, type 2 to label every other category, type 3 to label every third category, and so on.


To specify the number of categories you want between each pair of tick marks on the category (x) axis, type a number in the Number Of Categories Between Tick Marks 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, select the Value (Y) Axis Crosses Between Categories check box. If this check box is selected, data points are plotted between tick marks; if this check box is cleared, points are plotted at the tick-mark positions.


To reverse the order in which you want the categories on the category (x) axis to be displayed, select the Categories In Reverse Order check box.


To have the value (y) axis cross the category (x) axis after the last category on the x axis, select the Value (Y) Axis Crosses At Maximum Category check box. This option overrides the Value (Y) Axis Crosses At Category Number value.


To display the lowest value (rounded) from all data series as the smallest data value on the value axis, select the Auto Minimum check box.


To specify the smallest data value you want to appear on the value axis, type a value in the Minimum box.


To display the highest value (rounded) from all data series as the highest data value on the value axis, select the Auto Maximum check box.


To specify the highest data value you want to appear on the value axis, type a value in the Maximum box.


To have Microsoft Excel determine the interval of major tick marks and major gridlines (if they are displayed) on the value axis, select the Auto Major Unit check box.


To specify the interval of major tick marks and major gridlines (if they are displayed) on the value axis, type a value in the Major Unit box.


To have Microsoft Excel determine the interval of minor tick marks and minor gridlines (if they are displayed) on the value axis, select the Auto Minor Unit check box.


To specify the value at which you want the category (x) axis to cross the value (y) axis, type a value in the Category (X) Axis Crosses At box. 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).


To specify the value at which you want the value (x) axis to cross the value (y) axis for xy (scatter) charts, type a value in the Value (X) Axis Crosses At box. 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).


To recalculate the Minimum, Maximum, Major Unit, and Minor Unit values as powers of 10 for the value axis, based on the range of data plotted in the chart, select the Logarithmic Scale check box. No zeros or negative data values are permitted on logarithmic charts, and the values in the Major Unit and Minor Unit boxes must be at least 10.


To invert the chart and display the lowest scale value at the top of the chart and the highest scale value at the bottom of the chart, select the Values In Reverse Order check box.


To have the category (x) axis cross the value (y) axis at the highest value, select the Category (X) Axis Crosses At Maximum Value check box. This option overrides the Category (X) Axis Crosses At value.


To display the lowest value (rounded) from all data series as the smallest data value on the value axis, select the Auto Minimum check box.


To specify the smallest data value you want to appear on the value axis, type a value in the Minimum box.


To display the highest value (rounded) from all data series as the highest data value on the value axis, select the Auto Maximum check box.


To specify the highest data value you want to appear on the value axis, type a value in the Maximum box.


To automatically calculate the increment between major tick marks and major gridlines (if they are displayed) on the value axis, select the Auto Major Unit check box.


To specify the increment between major tick marks and major gridlines (if they are displayed) on the value axis, type a value in the Major Unit box.


To automatically calculate the increment between minor tick marks and minor gridlines (if they are displayed) on the value axis, select the Auto Minor Unit check box.


To specify the value at which you want the floor of a 3-D plotted chart to cross the value (z) axis, type a value in the Floor (XY Plane) Crosses At box. Selecting the Auto check box causes the floor (xy plane) to cross at 0 (zero) or at the number in the value-axis range closest to 0 (zero).


To recalculate the Minimum, Maximum, Major Unit, and Minor Unit values as powers of 10 for the value axis, based on the range of data plotted in the chart, select the Logarithmic Scale check box. No zeros or negative data values are permitted on logarithmic charts, and the values in the Major Unit and Minor Unit boxes must be at least 10.


To invert the chart and display the lowest scale value at the top of the chart and the highest scale value at the bottom of the chart, select the Values In Reverse Order check box.


To display the floor of a 3-D plotted chart at the lowest value on the chart, select the Floor (XY Plane) Crosses At Minimum Value check box. This option overrides the Floor (XY Plane) Crosses At value.


Data Series command (Format menu)

Modifies the selected data series. You can use this command to add data labels and error bars, format data markers, and rename data series.


To specify the type and style of data markers in line, radar, and xy (scatter) charts, select the options you want under Marker.


To apply the default formatting to a data marker, click Automatic.


To remove data markers from a line, click None.


To apply custom formatting to data markers, click Custom, and then click the Style, Foreground, and Background options you want.


To change the style of the data marker, click an option in the Style box.


To change the foreground color of the data marker, click a color in the Foreground box.


To change the background color of the data marker, click a color in the Background box.


To smooth out lines in line and xy (scatter) charts, select the Smoothed Line check box.


To change the chart style, click the subtype you want.


To see how your chart will look with the selected option applied, view the sample chart.


To specify how much you want the markers within a cluster to overlap each other, type a value between -100 and 100 in the Overlap box. The larger the value, the greater the overlap; the smaller the value, the greater the gap, or spacing.


To specify the amount of space you want between clusters of data markers, type a value between 0 and 500 in the Gap Width box. The larger the value, the greater the distance between clusters.


To connect the tops of data markers for each series with lines, select the Series Lines check box. This option is available only for stacked bar and stacked column charts.


To assign a different color or style to each data marker in charts with only one data series, select the Vary Colors By Point check box.


To assign a different color or style to each slice in charts with only one data series, select the Vary Colors By Slice check box.


To extend drop lines from each marker to the x-axis for a line chart or an area chart, select the Drop Lines check box.


To extend high-low lines from the highest value to the lowest value in each category, select the High-Low lines check box. This option is used primarily for stock charts and is available only for 2-D line charts.


To extend rectangular up-down bars for open-high-low-close charts, select the Up-Down Bars check box. On 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.


To add category labels to a chart, select the Category Labels check box.


To specify the angle at which you want the first pie or doughnut slice to start, type a number in the Angle Of First Slice box.


To specify the size of the hole in a doughnut chart, type a value between 10 and 90 in the Doughnut Hole Size box. The greater the value, the larger the hole and the narrower the doughnut rings.


To specify the distance between the data markers in 3-D charts, type a number in the Gap Depth box.


To specify the depth of a 3-D chart relative to its width, type a value in the Chart Depth box.


To see how your chart will look with the selected options applied, see the sample chart.


To change the chart type of a data series, a chart type group, or the entire chart, click Chart Type.


To plot the selected data series or chart type group along the primary axis, click Primary Axis.


To plot the selected data series or chart type group along the secondary axis, click Secondary Axis. This option displays a second axis if one hasn't already been added to the chart.


To specify the line type and thickness of the border, click the style you want in the Style box.


To specify the appearance of the line, click the style you want in the Style box.


To specify a color for the chart item, click the color you want in the Color palette.


To specify a pattern and a color for the chart item, click the boxes you want in the Pattern palette.


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 Minor Unit box.


To specify the increment you want between minor tick marks and minor gridlines (if they are displayed) on the value (z) axis, type a value in the Minor Unit box.


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


To specify the appearance you want for the chart area, select the options you want under Area.


To specify the appearance and style you want for the data markers, select the options you want under Marker.


To specify the intervals at which you want series on the series (y) axis to be labeled, type a number in the Number Of Series Between Tick-Mark Labels box.


To specify the number of series you want between each pair of tick marks on the series (y) axis, type a number in the Number Of Series Between Tick Marks box.


To specify the value at which you want the value (y) axis to cross the value (x) axis in an xy (scatter) chart, type a value in the Value (Y) Axis Crosses At box. Selecting the Auto check box causes the value (y) axis to cross the value (x) axis at 0 (zero) or at the number in the value-axis range closest to 0 (zero).


To have the value (y) axis cross the value (x) axis at the highest value, select the Value (Y) Axis Crosses At Maximum Value check box. This option overrides the Value (Y) Axis Crosses At value.


To display the value (z) axis between categories, select the Value (Z) Axis Crosses Between Categories check box. This option is available for 3-D line charts and 3-D area charts only.


To reverse the order in which you want the series on the series (y) axis to be displayed, select the Series In Reverse Order check box.


Align Left button (Formatting toolbar)

Aligns the selected text and numbers to the left.


Center button (Formatting toolbar)

Centers the selected text and numbers.


Align Right button (Formatting toolbar)

Aligns the selected text and numbers to the right.


Center Across Columns button (Formatting toolbar)

Centers the selected text or numbers across columns.


To wrap multiple lines of text within a cell, select the Wrap Text check box.


Borders button (Formatting toolbar)

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


Color button (Formatting toolbar)

Shades the selected cell or range with a solid background color. To apply the last selected color, click the button. To specify another color, click the arrow next to the button and select a color from the palette. To apply different background colors to several selections, drag the palette off the toolbar, and then select the colors.


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


Format Painter button (Standard toolbar)

Copies formats between cells or ranges. Select the cells whose format you want to copy, click the button, and then select the cells that you want to apply the formatting to.

Note   If you double-click the button, you can continue to paste the formatting to several locations. Click the button again when you are finished.


Font Color button (Formatting toolbar)

Changes the color of the selected text. To apply the last selected color, click the button. To specify another color, click the arrow next to the button and select a color from the palette.


To change the orientation of text in the selected cells, select an option under Orientation.


To change the appearance of the selected text, select the options you want on the Font tab.


Links command (Edit menu)

Lists the source documents for the active workbook, and provides options to change the links in linked documents.


Lists the source documents for the active workbook, and provides options to change the links in linked documents.


Lists the names of source documents.


Shows the type of link for internal links.


Describes the type of source document, such as a worksheet or Word document.


To indicate whether you want to update your worksheet automatically or manually, click Automatic or Manual.


To update the active dependent document with information from the selected source documents, click Update Now.


To open the selected source document, click Open Source.


To indicate a file to which you want to redirect the selected link, click Change Source.


To have Microsoft Excel automatically calculate worksheets when you change data or formulas or when you enter new formulas, click Automatic.

To have Microsoft Excel automatically calculate all data except data in tables, click Automatic Except Tables.

To have Microsoft Excel manually calculate the active worksheet only when you press F9, click Manual. To have Microsoft Excel turn off calculation when you save a workbook, clear the Recalculate Before Save check box.


Function command (Insert menu)

Opens the Function Wizard dialog box so that you can insert selected functions into the formula bar.


Name command (Insert menu)

Displays the commands used to create names, insert existing names into the formula bar, search formulas for references, and replace references with names.


Define command (Insert menu, Name submenu)

Creates a name for a cell, range, or constant or computed value that you can use to refer to the cell, range, or value.


To select from the list of all names defined in the workbook, click the name in the Names In Workbook box.


Displays the reference for the selected cell or range.


To add the selected entry in the Name In Workbook and Refers To boxes to the list of names defined for the workbook, click Add.


To delete the name selected in the Names In Workbook box, click Delete.


Paste command (Insert menu, Name submenu)

Inserts the selected name into the formula bar. If the formula bar is active and you begin a formula by typing an equal sign (=), clicking Paste pastes the selected name at the insertion point. If the formula bar is not active, double-clicking a name in the Paste Name box pastes an equal sign (=) followed by the selected name into the formula bar.


To paste a name from the list of all names defined on the active worksheet or macro sheet into the formula bar, double-click the name in the Paste Name box.


To paste all names defined in your worksheet, starting at the active cell, click Paste List.

On a worksheet, the list of names is an area two columns wide. The left column lists names; the right column lists cell references to which the names refer. On a macro sheet, the list of names is five columns wide and includes a name column, a reference column, a column for the type of macro (0=none, 1=function, 2=command), a column for assigned shortcut keys, and a column for the category.


Create command (Insert menu, Name submenu)

Creates names by using labels in a selected range.


To create names that use labels in a selected range, select the check boxes that use text in the top or bottom row, the left or right column, or any combination of a selected range.


Apply command (Insert menu, Name submenu)

Searches formulas in the selected cells and replaces references with names defined for them, if they exist.


To select the names you want to use in place of references, click the names in the Apply Names box, which lists all names defined in a workbook.


To replace references with names, regardless of the reference types of the names or references, select the Ignore Relative/Absolute check box. 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.


To use the names of row and column ranges that refer to the cells if the exact names for the cells can't be found, select the Use Row And Column Names check box


To set column and row naming and naming order options, click Options.


To replace the reference with the row-oriented name without including the column name, select the Omit Column Name If Same Column check box.


To replace the reference with the column-oriented name without including the row name, select the Omit Row Name If Same Row check box.


To determine which range name is listed first when a cell reference is replaced by both a row-oriented and a column-oriented range name, click Row Column when you want the row name to appear first. If you want the column name to appear first, click Column Row.


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


To calculate all dependent formulas except data tables, select the Automatic Except Tables check box. To calculate data tables, click Calc Now on the Calculation tab.


To calculate open workbooks only when you click the Calc Now button on the Calculation tab, click Manual. When you click Manual, Microsoft Excel automatically selects the Recalculate Before Save check box.


Recalculates data before the worksheet is saved.


To limit iteration for goal seeking or for resolving circular references, select the Iteration check box. 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.


To change the maximum number of iterations used in calculations, enter the number in the Maximum Iterations box.


To change the maximum amount of change allowed between iterations before calculations are concluded, enter the number in the Maximum Change box.


To calculate all open worksheets, including data tables, and to update all open chart documents, click Calc Now (F9).


To calculate only the active worksheet, update only the charts on the worksheet, and open charts linked to the worksheet, click Calc Sheet.


Determines whether remote references are updated, the precision level in calculations is displayed, the 1904 date system is used, and externally linked values are saved.


To calculate formulas that include references to other applications, select the Update Remote References check box.


To change stored values in cells from full precision (15 digits) to whatever format is displayed, select the Precision As Displayed check box.


To change the starting date from which all dates are calculated from January 1, 1900, to January 2, 1904, select the 1904 Date System check box.


To save copies of values contained in an external document linked to a Microsoft Excel worksheet, select the Save External Link Values check box.

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 this check box can reduce the disk space and time needed to open the worksheet.


Function Wizard button (Standard toolbar)

Displays a list of functions and their formats and allows you to set values for arguments.


AutoSum button (Standard toolbar)

Adds numbers automatically with the SUM function. Microsoft Excel suggests the range of cells to be added. If the suggested range is incorrect, drag through the range you want, and then press ENTER.


Paste Formats button (Edit category)

Pastes into the current selection the formats of the cells you have copied.


Outline Border button (Formatting category)

Adds a border around the outermost edges of the selected cells.


Bottom Double Border button (Formatting category)

Adds a double border along the bottom edge of the selected cells.


Dark Shading button (Formatting category)

Applies a dark shading pattern to selected cells and graphic objects, but not to their borders.


Light Shading button (Formatting category)

Applies a light shading pattern to selected cells and graphic objects, but not to their borders.


AutoFormat button (Formatting category)

Applies the last selected autoformat to a cell range or a PivotTable. If you hold down SHIFT while you click the button, you can step through the autoformats (as listed in the AutoFormat dialog box) until you return to the autoformat you started with.


Cycle Font Color button (Text Formatting category)

Changes the color of the selected text each time you click the button. If you hold down SHIFT while clicking the button, the previous color is displayed.


Vertical Text button (Text Formatting category)

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


Rotate Text Up button (Text Formatting category)

Turns the selected text on its side so that you read it from bottom to top.


Rotate Text Down button (Text Formatting category)

Turns the selected text on its side so that you read it from top to bottom.


Cells, Object, or Selected Object command (Format menu)

Applies formats to the selected cells or objects. The options available depend on the object selected. This command is not available if the sheet is protected.


To specify a number format, select an option in the Category box. After you click a category, you can select from the options displayed.


To specify the number of digits displayed to the right of the decimal point, enter a number.


To include a separator between thousands, select the Use 1000 Separator check box.


To specify how negative numbers are displayed, select an option in the Negative Numbers box.


To display a currency symbol with your numbers, select the Use $ check box.


To specify how dates, times, fractions, or custom formats are displayed, select an option in the Type box.


Shows how your number will look with the selected formatting.


To align the selected text horizontally, select an option under Horizontal.


To align text to the left, align numbers to the right, and center logical and error values, click General.


To align the selected text to the left, click Left.


To center the selected text, click Center.


To align the selected text to the right, click Right.


To repeat the contents of the selected cell until the cell is full, click Fill


To align the selected text to the left and the right, click Justify. You must have more than one line of wrapped text to see the justification.


To center a cell entry across the selected cells, click Center Across Selection.


To align the selected text vertically within the cell, click Top, Center, or Bottom. To distribute the selected text within the height of the cell, click Justify.


To set the font, font style, size, and effects to the Normal style, select the Normal Font check box.


To add a border around the specified edges of selected cells, select an option under Border, and then select an option under Style.


To change the background color of the selection, select a color.


AutoFormat command (Format menu)

Applies a built-in combination of formats, called an autoformat, to a cell range or a PivotTable. If a single cell is selected, Microsoft Excel automatically selects the range surrounded by blank cells and applies the autoformat to that range. If the selection is part of a PivotTable, the entire table, except for the page fields, is selected and formatted. This command is not available if the sheet is protected.


To specify the line style for a border, select an option under Style.


To shade cells with background colors and patterns, select a color and pattern under Cell Shading.


To omit format categories from the autoformat, clear the check boxes for the format types you don't want to use.


To apply a style to the selected cells, or redefine a style's formats, select the style in the Style Name box.


To include formats in a style, select the check boxes.


To add a style, change the style listed in the Style Name box by selecting and clearing the check boxes under Style Includes, and then click Add.


To copy styles from one open workbook to another, click Merge.


To specify the workbook from which you want to copy styles, select a workbook in the Merge Styles From box. You must have that workbook open.


To change the height of the selected cells, type a value from 0 to 409.5, representing the row height in points. If the row height is 0, the row is hidden.


To change the width of the selected cells, type a value from 0 through 255. This number represents the number of characters that can be displayed in a cell using the standard font. If the column width is 0, the column is hidden.


AutoFit Selection command (Format menu)

Adjusts the column width to the minimum necessary to display the contents of the selected cells. If you change the cell contents later, you must fit the selection again. This command is not available if the sheet is protected.


To restore the selected columns to the standard width, click OK.

To change the width for all columns that you have not previously adjusted in the active worksheet, type a number from 0 through 255 in the Standard Width box. This number represents the number of characters that can be displayed in a cell in the standard font.


Height command (Format menu)

Changes the height of the selected rows. You need to select only one cell in a row to change the height for the entire row. This command is not available if the sheet is protected.


AutoFit command (Format menu)

Restores each row in the selection to its standard height. The standard height for each row varies according to font size. This command is not available if the sheet is protected.


Width command (Format menu)

Changes the width of the selected columns. You need to select only one cell in a column to change the width for the entire column. This command is not available if the sheet is protected.


Standard Width command (Format menu)

Changes the standard width of columns on a worksheet. This command is not available if the sheet is protected.


To change the border of the selected object, select from the options under Border.


To apply the default settings for the selected object, click Automatic.


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


To customize the formats of the selected object, click Custom.


To change the color of the selected object, select an option in the Color box.


To change the weight of the selected line or border, select an option in the Weight box.


To add a shadow to the bottom and right side of the selected object, select the Shadow check box.


To round the corners of the selected object, select the Round Corners check box.


To change the selected line, select from the options under Line.


To change the style of an arrowhead, select an option in the Style box.


To change the width of the arrowhead, select an option in the Width box.


To change the length of the arrowhead, select an option in the Length box.


To align the text in selected text boxes, select from the options under Text Alignment.


To adjust the size of the selected text box to fit the text, select the Automatic Size check box.


To remove shading from the selection, click None.


Lotus 1-2-3 command (Help menu)

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.


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


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


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


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


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.


To continue the demonstration, enter the requested additional information in the dialog box that appears at the top of the screen.

To select a range, use the arrow keys. 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.


To return to the the initial Help For Lotus 1-2-3 Users dialog box or to a previous step, press ESC.


To continue running the Lotus 1-2-3 macro, click a menu item.

To stop the macro, press CTRL+BREAK.


To continue running the Lotus 1-2-3 macro, enter the requested information, and then press ENTER.

To stop the macro, press CTRL+BREAK.


To hide a cell's formula so that it doesn't appear in the formula bar when the cell is selected, select the Hidden check box.


Hide command (Format menu, Sheet submenu)

Hides the active sheet. The sheet remains open and accessible to other sheets, but it is not visible. You can't hide the only visible sheet in a workbook.


Unhide command (Format menu, Sheet submenu)

Displays any hidden sheets.


To display a hidden sheet, click the name of the sheet in the Unhide Sheet box. You can display only one hidden sheet at a time.


Cell command (Info menu)

Displays the cell reference for the active cell.


Formula command (Info menu)

Displays the contents of the active cell, as displayed in the formula bar.


Value command (Info menu)

Displays the value produced by the contents of the active cell.


Format command (Info menu)

Displays the format settings for the active cell, including style, number, alignment, font, border, and shading formats.


Protection command (Info menu)

Displays the protection status of the active cell. You can "lock" a cell to prevent changes to it, or you can hide the cell's formula.


Names command (Info menu)

Displays the names of any named areas that include the active cell.


Precedents command (Info menu)

Displays all the cells referred to by the formula in the active cell.


Dependents command (Info menu)

Displays all the cells that contain formulas that depend on or refer to the active cell.


To display the cells that supply values directly to the formula in the active cell, click Direct Only. To display all cells in the worksheet that supply values to the formula in the active cell, click All Levels.


To display the first cell with a formula that uses the values in the active cell, click Direct Only. To display all cells with formulas that use the values in the active cell, click All Levels.


Start command (Run menu)

Runs the Visual Basic procedure that contains the insertion point. If the procedure cannot run as a stand-alone procedure, this command allows you to pick a procedure to run from a list of available procedures.


Reset command (Run menu)

Resets all variables in the current workbook. Stops any running Visual Basic procedure if you're in break mode.


Step Into command (Run menu)

Runs the next executable line of code in the active Visual Basic procedure, stepping into other Visual Basic procedures when they're called. If the called procedure is in a hidden module, the Step Into command acts like the Step Over command.


Step Over command (Run menu)

Runs the next executable line of code in the active Visual Basic procedure, running other Visual Basic procedures when they're called without stepping into them. This command is available only in break mode.


Macro command (Tools menu)

Runs, modifies, deletes, or sets options for the selected macro.


To specify which macro you want to run, modify, delete, or set options for, click a macro name in the Macro Name/Reference box. If you want to set options for a procedure that doesn't appear in the box, type the procedure name in the box.


Displays descriptive information about the selected macro. To add or edit a description of the selected macro, click Options.


To run the selected procedure, click Run. If a procedure takes arguments, you cannot run it from the Macro dialog box.


To run the selected procedure one line of code at a time, click Step.


To open the selected procedure in a Visual Basic module, click Edit.


To delete the selected procedure, click Delete.


To assign the selected macro to a menu item or shortcut key, to add or edit a description for the selected macro, or to provide Help information for the selected macro, click Options. If you want to set options for a procedure that does not appear in the list in the Macro Name/Reference box, type the procedure name in the box, and then click Options.


Displays the name of the selected macro


To add or edit descriptive information about the selected macro, type text in the Description box. This information may include a brief explanation of the macro's function, the date the macro was recorded, the macro's author, or any other information that might help the user decide how to use the macro.


To assign the selected macro to a menu item on the Tools menu, type the name of the new menu item in the Menu Item On Tools Menu box. Type an ampersand (&) before the character you want to use as the access key for the new menu item (for example, &New Item). The new menu item will appear at the bottom of the Tools menu.


To assign shortcut keys to the selected macro, type a letter in the Shortcut Key box. 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.


To assign the specified function to a function category, click a name in the Function Category box. The function will appear under the specified category in the Function Wizard.


To associate status bar text with the menu item assigned to the selected macro, type the text in the Status Bar box. This text will appear in the status bar when the user points to the menu item.


To assign a Help topic to the menu item assigned to the selected macro, type the context ID number for the topic in the Help Context ID box.


To assign a Help topic to the menu item assigned to the selected macro, type the name of the Help file in the Help File Name box.


Record New Macro command (Tools menu, Record Macro submenu)

Records a new macro; allows you to specify a name for the macro, add a description of the macro, and set other macro options before starting to record the macro.


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


To store the new macro in your Personal Macro Workbook, which is a hidden workbook that's always open when Microsoft Excel is running, click Personal Macro Workbook.


To store the new macro in the active workbook, click This Workbook.


To store the new macro in a new workbook, click New Workbook.


To record the new macro using the Visual Basic language, click Visual Basic.


To record the new macro using the Microsoft Excel version 4.0 macro language, click MS Excel 4.0 Macro.


To assign the new macro to a shortcut key or menu item, to specify where to store the new macro, or to choose the programming language for the new macro, click Options.


Mark Position For Recording command (Tools menu, Record Macro submenu)

Marks the position of the insertion point in the active module. The next macro instructions you record using the Record At Mark command will be inserted into the module at this position.


Use Relative References command (Tools menu, Record Macro submenu)

Determines whether the Macro recorder uses relative or absolute references to cells on a worksheet.


Record At Mark command (Tools menu, Record Macro submenu)

Starts the Macro Recorder, inserting new recorded instructions at the location you previously specified using the Mark Position For Recording command.


Module command (Insert menu, Macro submenu)

Inserts a new Visual Basic module to the left of the selected sheet in the active workbook.


Dialog command (Insert menu, Macro submenu)

Inserts a new dialog sheet to the left of the selected sheet in the active workbook.


MS Excel 4.0 Macro command (Insert menu, Macro submenu)

Inserts a new macro sheet to the left of the selected sheet in the active workbook.


End command (Run menu)

Stops a procedure running in break mode without resetting variables.


Toggle Breakpoint command (Run menu)

Sets or removes a breakpoint at the line of code that contains the insertion point. Visual Basic enters break mode when it encounters a breakpoint.


Clear All Breakpoints command (Run menu)

Removes all breakpoints in all Visual Basic modules in the active workbook.


Continue command (Run menu)

Continues running the active macro from the current line of code. This command is available only when Visual Basic is in break mode.


Add Watch command (Tools menu)

Adds the specified expression to the list of watch expressions. You can then monitor the value of this expression as your code runs.


To specify an expression to watch, type it in the Expression box. You can also use the default expression if one is supplied The expression can be a variable, a property, a function call, or any other valid expression.


To specify whether Visual Basic should evaluate the variable in all open procedures or in only one of the open procedures, click the appropriate item in the Procedure box.


To specify whether Visual Basic should evaluate the variable in all open modules or in only one of the open modules, click the appropriate item in the Module box.


Displays the name of the current workbook. Expressions cannot be evaluated outside the current workbook.


To monitor the value of the specified expression while in break mode, click Watch Expression. The expression and its value are displayed in the Watch pane of the Debug window.


To automatically enter break mode when the specified expression evaluates to True, click Break When Value Is True. The expression and its value are displayed in the Watch pane of the Debug window.


To automatically enter break mode when the value of the specified expression changes, click Break When Value Changes. The expression and its value are displayed in the Watch pane of the Debug window.


Edit Watch command (Tools menu)

Edits or deletes existing watch expressions.


Instant Watch command (Tools menu)

Displays the value of the selected Visual Basic expression in the Instant Watch dialog box. In the Instant Watch dialog box, you can add this expression to the list of watch expressions.


To add the selected expression to the list of watch expressions, click Add.


To stop the Visual Basic macro, click End.

To stop the Microsoft Excel 4.0 macro and return to the previously selected cell, click Halt.

To start single-stepping after a Microsoft Excel 4.0 macro has stopped because of an error, click Step.

To proceed with the rest of the macro as if the error or interruption hadn't occurred, click Continue.

To stop the Visual Basic macro, open the Debug window, and select the line of code that caused the error, click Debug.

To stop the macro and select the line of code that caused the error, click Goto.

To open Visual Basic Help, click Help


To give the selected control a three-dimensional appearance, select the 3D Shading check box.


To stop the macro, open the Debug window, and select the line of code that caused the error, click Debug.


To stop the macro and select the line of code that caused the error, click Goto.


References command (Tools menu)

Adds, deletes, or edits references in the active workbook to other workbooks or libraries.


To add a reference to a specific workbook or library, select the check box next to the workbook or library name in the Available References box. To delete a specific reference from the list of available references, clear the check box next to the reference name.


To browse for other workbooks or libraries to add to the list of available references, click Browse.


To add or edit the caption for a selected custom menu component (menu, menu item, or submenu item), type text in the Caption box, including an ampersand (&) before the character you want to use as the access key for the new menu component (for example, &New Item). You cannot edit the caption of a built-in menu component.


To assign a macro to a custom menu item or custom submenu item, click the menu item or submenu item, and then click a name in the list of available macros in the Macro box.


To specify which set of menus you want to edit, click a name in the list of Microsoft Excel menu bars in the Menu Bars box.


To specify which menu you want to edit, click a name in the list of available menus in the Menus box.


To specify which menu item you want to edit, click a name in the list of available menu items in the Menu Items box.


To specify which submenu item you want to edit, click a name in the list of available submenu items in the Submenu Items box.


To insert a new menu, menu item, or submenu item, click the existing menu, menu item, or submenu item above which you want to insert the new one, and then click Insert.


To delete the selected menu, menu item, or submenu item, click Delete.


To restore all menus, menu items, and submenu items to their original default configurations, click Restore All.


Assign Macro command (Tools menu)

Assigns a macro to the selected object. This command is available only when a graphic object or a control is selected, or when the Customize dialog box is open and a tool is selected.


To specify which macro you want to assign to the selected object, click a name in the list of available macros in the Macro Name/Reference box.


To activate a Visual Basic module and edit the macro that runs when the selected object is clicked, click Edit. If the selected object has no macro assigned to it, this button changes to New. To create an empty procedure that's automatically assigned to the selected object, click New.


To record a new macro using the Macro Recorder and assign it to the selected object, click Record.


To set the font for the Visual Basic code in modules, enter the name of the font in the Font box.


To set the font size of the Visual Basic code in modules, enter the appropriate number in the Size box.


To specify the element of Visual Basic code you want to set colors for, click the name of the element in the Code Colors box.


To set the foreground (text) color for the selected element of Visual Basic code, click the color in the Foreground box.


To set the background (screen) color for the selected element of Visual Basic code, click the color in the Background box.


To select from the list of available controls on a dialog sheet, click the name in the Tab Order box.


To move the selected dialog sheet control up or down in the tab order, click the up arrow above Move or the down arrow below Move.


Run Dialog command (Tools menu)

Runs the custom dialog box on the active dialog sheet.


To allow automatic indents to lines of Visual Basic code, select the Auto Indent check box.


To activate the display of syntax error messages, select the Display Syntax Errors check box. If the check box is cleared, Microsoft Excel applies red formatting to a statement containing syntax errors, but it doesn't display an error message.


To allow interruption of a procedure when any run-time error is encountered, select the Break On All Errors check box. This setting overrides any error-trapping routine in your code, and it interrupts for all errors. If you have no custom error-trapping routines in your code, this option has no effect.


To require explicit declaration of all variables, select the Require Variable Declaration check box.


To set the tab width for code indents, enter a value from 1 to 40 in the Tab Width box.


To display the international settings for the active workbook, click Current Settings.


To display or change the international settings for new workbooks, click Default Settings.


To change the language and country setting for new workbooks, click an item in the Language/Country box. This box is available only if the Default Settings option is selected.


Displays the list separator for either the default or current international settings.


Displays the number format for either the default or current international settings.


Displays the currency format for either the default or current international settings.


Displays the date/time format for either the default or current international settings.


Procedure Definition command (View menu)

Jumps to the the procedure whose name contains the insertion point.


To browse the objects, properties, methods, and constants for one of the available referenced type libraries, or to browse the modules and procedures in any open or referenced Microsoft Excel workbook, click the name of the type library or workbook in the Libraries/Workbooks box.


To view the methods or properties of an object, or to see the procedures in a module, click the name of the object or module in the Objects/Modules box. To see a list of available built-in constants in the selected type library, click Constants.


To select from the list of methods, properties, constants, or procedures, click a name in the Methods/Properties box.


To open the Visual Basic module that contains the procedure selected in the Methods/Properties box, click Show.


To paste the selected method, property, or procedure (including arguments) into the active Visual Basic module, click Paste.


To set options for the selected procedure, click Options. This button is available only for procedures in the active workbook.


Help on procedure, method, or property button

Activates the Help topic for the item selected in the Methods/Properties box. This button is unavailable if there is no Help topic for the selected item.


To view the list of current watch expressions and their values, click Watch.


To type and immediately run one line of code at a time, to check the values of properties or variables, or to evaluate expressions, click the Immediate tab. Code typed on the Immediate tab isn't saved.


To examine or select code without dismissing the Debug window, use the Code pane. In the Code pane, the current execution point in the code has a rectangular outline around it.


Displays the name of the procedure that's currently running in break mode.  Click the Calls button ( [image] ) to display a list of the currently active procedure calls.


Calls button

Opens the Calls dialog box, which displays a list of the currently active procedure calls.


To select a procedure to examine from the list of all currently active procedure calls, click the name of the procedure in the Workbook.Module.Procedure box. The most recently called procedure appears at the top of the list; the first procedure called appears at the bottom.


To display the code in the procedure whose name is selected in the Workbook.Module.Procedure box, click Show. The code will appear in the Code pane of the Debug window.


Create Button button (Drawing toolbar or Forms toolbar)

Creates a button on a worksheet, dialog sheet, or chart.


Check Box button (Forms toolbar)

Creates a check box on a worksheet, dialog sheet, or chart.


Combination Drop-Down Edit button (Forms toolbar)

Creates a combination drop-down list box and edit box on a dialog sheet.


Combination List-Edit button (Forms toolbar)

Creates a combination list box and edit box on a dialog sheet.


Control Properties button (Forms toolbar)

Opens the Control tab in the Format Object dialog box to view or change the properties of the selected control on a worksheet, dialog sheet, or chart.


Drop-Down button (Forms toolbar)

Creates a drop-down list box on a worksheet, dialog sheet, or chart.


Edit Code button (Forms toolbar)

Edits or creates code for the selected object. If the object currently has code assigned to it, clicking this button opens the Visual Basic module or Microsoft Excel version 4.0 macro sheet that contains the code. If the object doesn't have code assigned to it, clicking this button creates an empty Visual Basic procedure that's automatically assigned to the object.


Edit Box button (Forms toolbar)

Creates an edit box on a dialog sheet.


Group Box button (Forms toolbar)

Creates a group box on a worksheet, dialog sheet, or chart.


Label button (Forms toolbar)

Creates a text label on a worksheet, dialog sheet, or chart.


List Box button (Forms toolbar)

Creates a list box on a worksheet, dialog sheet, or chart.


Option Button button (Forms toolbar)

Creates an option button on a worksheet, dialog sheet, or chart.


Scroll Bar button (Forms toolbar)

Creates a scroll bar on a worksheet, dialog sheet, or chart.


Spinner button (Forms toolbar)

Creates a spinner control on a worksheet, dialog sheet, or chart.


Tab Order button

Sets the order in which controls in a dialog box are activated when the TAB key is pressed.


Toggle Grid button (Forms toolbar)

Shows or hides the grid used to align objects on a worksheet or dialog sheet.


Right Parenthesis button

Adds a closing parenthesis at the insertion point in the formula bar or cell.

•	If a cell is active, clicking this button replaces the contents of the cell with a right parenthesis.


Resume Macro button

Continues running the active macro from the current instruction. This button is available only when it appears pushed down — that is, when Visual Basic is in break mode, or when a Microsoft Excel version 4.0 macro is paused.


Step Macro button

For Visual Basic procedures, clicking this button puts Visual Basic into break mode and opens the Debug window. For Microsoft Excel version 4.0 macros, clicking this button allows you to step through the currently selected macro one cell at a time, starting at the active cell.


Stop Macro button

Stops running or recording a macro.


Insert Module button

Inserts a new Visual Basic module to the left of the selected sheet. If no workbook is open, clicking this button creates a new workbook that contains a single module sheet.


Menu Editor button

Edits workbook menu bars, menus, menu items, and submenu items.


Object Browser button

Displays the procedures, objects, methods, properties, and constants that are available for use in the active workbook or that are currently loaded in Microsoft Excel.


Toggle Breakpoint button

Sets or removes a breakpoint at the line of code that contains the insertion point. Visual Basic enters break mode when it encounters a breakpoint.


Instant Watch button

Displays the value of the selected Visual Basic expression in the Instant Watch dialog box. In the Instant Watch dialog box, you can add this expression to the list of watch expressions.


Step Over button

Runs the next executable line of code in the active Visual Basic procedure (the line with a rectangle around it), running other Visual Basic procedures when they're called without stepping into them. This button is available only in break mode.


 	Step Into button

Runs the next executable line of code in the active Visual Basic procedure (the line with a rectangle around it), stepping into other Visual Basic procedures when they're called. If the called procedure is in a hidden module, the Step Into button acts like the Step Over button.


Attach Toolbars Command (Tools Menu)

Attaches a copy of a custom toolbar to the active workbook


To specify which toolbars you want to attach to the active workbook, click the appropriate names in the Custom Toolbars box. This box lists all the custom toolbars in the current workspace.


Lists all the toolbars attached to the active workbook. Toolbars that you copy to the active workbook are automatically added to the box.


To copy the selected custom toolbars to the active workbook, click Copy.


Displays the names of the workbook, module, and procedure that contain the selected expression.


Displays the selected expression.


Displays the value of the selected expression.


To stop the macro and return to the previously selected cell, click Halt.


To start single-stepping after a macro has stopped because of an error, click Step.


To see deleted menus, menu items, and submenu items, select the Show Deleted Items check box. Names of deleted components appear dimmed.


Displays the location of the workbook or library selected in the Available References box.


Displays the language of the workbook or library selected in the Available References box.


To set the accelerator key for the selected control, type a letter that appears in the control name in the Accelerator Key box. The letter you type will appear underlined in the control name in the running dialog box. Pressing ALT+ the accelerator key when the custom dialog box is running will activate this control.


To fill the selected list box with the contents of a range of cells on a worksheet, either type the range address in the Input Range box; or place the insertion point in this box, and then select a range.


To link the value of the selected control to a cell on a worksheet, either type the cell address in the Cell Link box; or place the insertion point in this box, and then select a cell.


To specify single-item selection for the selected list box, click Single. When the custom dialog box runs, the user will be able to select one item at a time from the list.


To specify multiple-item selection for the selected list box, click Multi. When the custom dialog box runs, the user will be able to select any assortment of items in the list. The user must select and deselect items one at a time.


To specify extendible selection for the selected list box, click Extend. When the custom dialog box runs, the user will be able to select multiple items by clicking the first item in a series and then holding down SHIFT and pressing the last item in the series. Both clicked items and all items in between will be selected. The user can select or deselect an individual item by holding down CTRL and clicking the item.


To specify that the selected button be the default button for the user-defined dialog box, click Default.


To specify that the selected button be automatically selected when the user cancels the user-defined dialog box, click Cancel. You can designate only one button in a dialog box to be the Cancel button.


To specify that clicking the selected button automatically close the user-defined dialog box, click Dismiss. You can designate any number of buttons in a dialog box to be Dismiss buttons.


To specify that the selected button be activated when the user presses F1, click Help.


To set the initial value for the selected scroll bar or spinner, type an integer in the Current Value box. This integer must fall between the Minimum Value and Maximum Value you set for this control.


To set the minimum value for the selected scroll bar or spinner, type an integer in the Minimum Value box. The value in this box must be less than the value in the Maximum Value box.


To set the minimum value for the selected scroll bar or spinner, type an integer in the Maximum Value box. The value in this box must be greater than the value in the Minimum Value box.


To specify how much the value of the selected scroll bar or spinner changes when the user clicks one of its arrows, type an integer in the Incremental Change box.


To specify how much the value of the selected scroll bar changes when the user clicks inside the scroll bar on either side of the scroll box, type an integer in the Page Change box.


To specify the number of lines displayed in the drop-down portion of the selected drop-down list box, type a number in the Drop Down Lines box. If the number you specify is less than the number of items in the list, a scroll bar will appear to the right of the list.


To specify what type of information you want the user to type in the selected edit box, click an option under Edit Validation. When the user closes the dialog box, Microsoft Excel displays an error message if the edit box does not contain this type of information.


To allow the user to enter more than one line in the selected edit box, select the Multiline Edit check box.


To add a vertical scroll bar to the selected edit box, select the Vertical Scrollbar check box. The scroll bar will appear only if you also select the Multiline Edit check box.


To display asterisks in place of the characters the user types in the selected edit box, select the Password Edit check box.


To set the initial state of the selected check box or option button to off, click Unchecked.


To set the initial state of the selected check box or option button to on, click Checked.


To set the initial state of the selected check box to mixed, click Mixed. The check box will contain a dimmed check mark when the dialog box first opens.


Single Step

This window shows which cell in the macro is about to be calculated and what formula is in that cell.

Step Into

Carries out the next instruction in the macro, including user-defined function calls.

Step Over

Carries out the next instruction in the macro. Carries out, but does not step through, user-defined function calls.

Evaluate

Evaluates each part of the formula in the active cell. If chosen repeatedly, this button will Step Into the macro, not Step Over.

Pause

Closes the dialog box and suspends the macro, allowing you to perform other tasks.

Halt

Stops the macro.

Continue

Runs the rest of the macro without single-stepping.

Goto

Stops the macro and selects the cell currently being evaluated on the macro sheet.


Object Browser command (View menu)

Displays procedures, objects, methods and properties.


Debug Window command (View menu)

Shows Debug window.


Make Add-in command (Tools menu)

Saves workbook as an add-in.


Menu Editor command (Tools menu)

Designs custom menus.


Help on Keyword command (Help menu)

Displays help on currently selected keyword.


File command (Insert menu)

Inserts code from a text file.


Tab Order command (Tools menu)

Changes tab order of controls.


Record Macro button

Records actions to create a macro.


Run Macro button

Runs macro at insertion point.


Form command (Data menu)

Displays a data form in a dialog box. You can use the data form to see, change, add, delete, and find records in a list or database.


Displays the column labels in your list.


Corresponds to each column in your list.


To move between the adjacent records in a list, use the scroll bar.


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.


To clear the fields in the Data Form dialog box and enter data for a new record, click the New button. Click New again to add the record to the end of the list.


To delete the displayed record in the data form, click Delete.


To undo any changes you make in the data form, click the Restore button before pressing ENTER or scrolling to another record.


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


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


To find records based on the criteria you specify, click the Criteria button.


To remove existing criteria from the dialog box, click the Clear button.


To expand the selection to include adjacent data, click Expand The Selection.

To sort only the current selection, click Continue With The Current Selection.


To sort the selected data in ascending or descending order, click Sort.


To see how the worksheet changes when you insert or delete cells, rows, or columns, select the Animate Insertion And Deletion check box. Displaying animation may slow video performance on older systems.


To paste the values and formats, but not the borders, click All Except Borders.


To assign a category to a Microsoft Excel 4.0 macro, click either Function or Command, and then click a category in the Category box.


To assign a shortcut key to a Microsoft Excel 4.0 macro, type a letter in the Key:Ctrl+ box.


TipWizard button (Standard toolbar)

Displays or hides the TipWizard, which provides tips about more efficient ways to do your work. The TipWizard also offers a tip each time you start Microsoft Excel. Use the up and down arrows to the right of the tip that's displayed to scroll through the tips that apply to the work you've done since starting Microsoft Excel.


Map button (Standard toolbar)

Creates a map based on the selected data. The data should contain geographic references, such as abbreviations of countries or states. To set the location and size of the map on your worksheet, drag the cross hair.


Map command (Insert menu)

Inserts a map based on the selected data. The data should contain geographic references, such as abbreviations of countries or states. To set the location and size of the map on your worksheet, drag the cross hair.


Template Wizard command (Data menu)

Creates a workbook template that automatically copies the data you enter in a workbook to a database.


Delete (Format, Format Cells, Number)
To delete a custom number format, select the number format under Type, and then click Delete. Built-in number formats cannot be deleted.


To change the type of marker for the error bar, click the style you want under Marker.


To display each page as it will look when printed, click Preview.


Copy command (Shortcut menu)

Copies the selection onto the Clipboard.


Move command (Shortcut menu)

Moves the selection into the selected cells.


Copy Formats command (Shortcut menu)

Pastes the formats of the copied cells into the selected cells.


Copy Values command (Shortcut menu)

Pastes the values of the copied cells into the selected cells.


Shift Down And Copy command (Shortcut menu)

Shifts the surrounding cells down and inserts the copied cells into the selected cells.


Shift Right And Copy command (Shortcut menu)

Shifts the surrounding cells right and inserts the copied cells into the selected cells.


Shift Down And Move command (Shortcut menu)

Shifts the surrounding cells down and moves the copied cells into the selected cells.


Shift Right And Move command (Shortcut menu)

Shifts the surrounding cells right and moves the copied cells into the selected cells.


Chart Group command (Format menu)

Specifies certain chart options, such as the order of data series, the axis on which the chart is plotted, and the spacing of data markers. The name of this command changes based on the chart groups — such as Column Group or Line Group — that are used in the active chart. The options available depend on the type of chart group.


Access Form command (Data menu)

Builds a data entry form for your Microsoft Excel list in the Microsoft AccessLinks Form Wizard.


Access Report command (Data menu)

Builds a data report based on your Microsoft Excel list in the Microsoft AccessLinks Report Wizard.


Convert To Access command (Data menu)

Converts your Microsoft Excel list to a Microsoft Access database.


To further view, analyze, or print data from each page of a selected page field on a new worksheet in the same workbook, click a page field in the Show All Pages Of box.


Bring To Front command (Format menu, Placement submenu)

Places the selected object in front of other overlapping objects.


Send To Back command (Format menu, Placement submenu)

Places the selected object behind other overlapping objects.


Group command (Format menu, Placement submenu)

Assembles the selected graphic objects into a single object, so that they can be moved or changed as a group.


Ungroup command (Format menu, Placement submenu)

Separates a grouped object into distinct objects, so that they can be moved or changed individually.


To specify the upper-left corner of the converted text range on your sheet, enter the location in the Destination box.


Justify command (Edit menu, Fill submenu)

Redistributes the contents of cells to fill the selected range. Except for the left column, cells in the range should be blank.


Options command (Tools menu)

Modifies Microsoft Excel settings that control screen appearance, calculation, editing, and other options.


Formula Bar command (View menu)

Displays or hides the formula bar.


Sized With Window command (View Menu)

Controls whether the size of a chart sheet is dependent on or independent of the window size. By default, a newly created chart sheet is independent of the window size.


Insert Worksheet button

Inserts a new worksheet.


Get External Data command (Data menu)

Retrieves data from external database files and tables using Microsoft Query.


To create a PivotTable with data from an external database using Microsoft Query, click Get Data.


To specify a number format, click an option in the Category box, and then select the options you want. The Sample box shows how your numbers will look with the selected formatting.


To change the maximum number of iterations used and maximum amount of change allowed between iterations, type the numbers in the Maximum Iterations and Maximum Change boxes. To specify other options, click under Workbook Options.


To create a new list, click 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. To create a custom list from a worksheet range, click in the Import List From Cells box, select the range on the sheet, and then click Import.


To specify scaling, paper size, print quality (in dots per inch), or starting page number, select the options you want.


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


Note command (Info Menu)

Displays or hides the cell note for the active cell.


Toolbars command (Toolbars shortcut menu)

Displays, hides, or customizes toolbars and toolbar buttons.


Customize command (Toolbars shortcut menu)

Adds a button to a toolbar or changes toolbars and toolbar buttons.


Pick From List command (AutoCompletion shortcut menu)

Displays a list of possible AutoCompletion values.


Vertical Gridlines button (Chart category)

Shows or hides vertical gridlines in charts.


Scenario button (Utility category)

Adds, displays, or edits scenarios.


Style button (Formatting category)

Applies or defines a cell style.


Line button (Drawing toolbar)

Draws straight lines.


Rectangle button (Drawing toolbar)

Draws rectangles or squares.


Filled Rectangle button (Drawing toolbar)

Draws filled rectangles or squares.


Ellipse button (Drawing toolbar)

Draws ellipses or circles.


Filled Ellipse button (Drawing toolbar)

Draws filled ellipses or circles.


Arc button (Drawing toolbar)

Draws arcs or circle segments.


Filled Arc button (Drawing toolbar)

Draws filled arcs or circle segments.


Filled Freeform button (Drawing toolbar)

Draws filled freehand polygon shapes.


Filled Polygon button (Drawing category)

Draws filled polygon shapes.


As New Sheet command (Insert menu, Chart submenu)

Starts the ChartWizard, which guides you through the steps required to create a new chart based on the selected worksheet data. The finished chart is placed on a new chart sheet that is inserted to the left of the active worksheet.


Worksheet command (Insert menu)

Inserts a new worksheet to the left of the selected sheet.


Module command (Insert menu, Macro submenu)

Inserts a new Visual Basic module to the left of the selected sheet.


Dialog command (Insert menu, Macro submenu)

Inserts a new dialog sheet to the left of the selected sheet.


Delete Sheet command (Edit menu)

Deletes the selected sheets from the workbook. You cannot undo this command.


Move Or Copy Sheet command (Edit menu)

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


To indicate the workbook to which you want to move or copy the selected sheets, click a workbook in the To Book list. Only open workbooks are listed. Click New Book to create a workbook containing only the moved or copied sheets.


To indicate the sheet before which you want the selected sheets placed, click the sheet name in the Before Sheet list.


To copy the selected sheets and leave the originals in place, select the Create A Copy check box.


Rename command (Format menu, Sheet submenu)

Renames the active sheet.


To rename the sheet, type a new sheet name in the Name box. The name can include up to 31 characters and spaces. Do not enclose the name in square brackets [ ]. The following characters are not allowed:  :  /  \  ?  *


More Sheets command (Sheet Tab Scroll Buttons shortcut menu)

Displays a list of all the sheets in the workbook.


To make a sheet active, double-click the sheet name in the Activate list.


Sheet commands (Sheet Tab Scroll Buttons shortcut menu)

Displays the sheet you click and makes it the active sheet. In workbooks with more sheets, click the More Sheets command to see a list of all sheets in the workbook.


Insert command (Workbook Tab shortcut menu)

Inserts a new sheet to the left of the selected sheet in the active workbook.


To insert a sheet, double-click the type of sheet you want.


Ungroup Sheets command (Workbook Tab shortcut menu)

Cancels the current group selection of sheets.


Select All Sheets command (Workbook Tab shortcut menu)

Selects all sheets in the active workbook. You can perform editing and formatting tasks simultaneously on all of the selected sheets. For example, you can delete several sheets at once or enter identical data onto several worksheets.


Shows how the selected type of sheet looks.


Currency Style button (Formatting toolbar)

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

International Currency Style button

Depending on the country selected in the Windows Regional Settings dialog box, the International Currency Style button might appear instead of the Currency Style button.


Percent Style button (Formatting toolbar)

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


Comma Style button (Formatting toolbar)

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


Increase Decimal button (Formatting toolbar)

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


Decrease Decimal button (Formatting toolbar)

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


To apply a number format, click a type in the Category box, and then select from the options that appear.


Hide Detail command (Data menu, Group And Outline submenu)

Hides the detail data of an outer item in a row field or column field on a pivot table. In an outlined worksheet, this command hides the detail rows or columns of a selected summary row or column.


Show Detail command (Data menu, Group And Outline submenu)

Displays the hidden detail rows or columns of a selected summary row or column in an outlined worksheet.

In a pivot table, this command displays the detail data of a hidden row field or column field.


To specify which row or column field to display, click an item in the list.


To specify whether you want to group data in rows or columns, click an option under Group.


Ungroup command (Data menu, Group And Outline submenu)

Removes selected rows or columns from a group in an outlined worksheet.

In a pivot table, this command separates each instance of a group into the items contained in the group; for example, it separates quarters into the original individual dates.


To specify whether you want to ungroup the data in rows or columns, click an option under Ungroup.


Clear Outline command (Data menu, Group And Outline submenu)

Removes the outline from the selected group of data. If the selection is not a specific group within the outline, the outline is removed from the entire worksheet.


Auto Outline command (Data menu, Group And Outline submenu)

Automatically outlines a selected range of cells or the entire worksheet, based on formulas and the direction of references.


Settings command (Data menu, Group And Outline submenu)

Specifies the options used to outline and summarize data in a worksheet or a selected range of cells.


To specify where the summary data will appear in an outline, select one or both of the options under Direction.


To apply built-in cell styles when you create an outline, select the Automatic Styles check box. 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.


To assign outline levels to data in a worksheet, click Create. Microsoft Excel groups related detail data and assigns outline levels based on the formulas in the worksheet.


Group command (Data menu, Group And Outline submenu)

Defines the selected rows or columns of detail data as a group in an outline so you can summarize the data. If you have not created an outline, this command creates one for you.

In a pivot table, this command groups items by category to create a single item from multiple items; for example, you can group days, weeks, months, or other dates into quarters for analysis, charting, or printing.


To apply formatting that emphasizes the summary rows and summary columns of an outlined worksheet, click Apply Styles. Microsoft Excel applies the built-in styles RowLevel_1, ColLevel_1, and so on, to the various summary levels of the selected outlined data.


Show Outline Symbols button

Creates an outline and displays the outline symbols in the worksheet. If the symbols are already displayed in an existing outline, clicking the button hides them.


  Constrain Pen Recognition button (Formula toolbar)

Limits pen recognition to digits and punctuation.  This reduces recognition errors between numbers and letters.


PivotTable command (Data menu)

Starts the PivotTable Wizard, which guides you through creating or modifying a PivotTable.


Refresh Data command (Data menu)

Updates the data in a PivotTable if the source data has changed.


To create a PivotTable from a list or database in your workbook, click Microsoft Excel List Or Database.

For more information, click  [image].


To create a PivotTable from data stored in a file or database outside of Microsoft Excel, click External Data Source.

For more information, click  [image].


To create one PivotTable from multiple Microsoft Excel worksheet ranges, click Multiple Consolidation Ranges.

For more information, click  [image].


To create a PivotTable from another PivotTable in the same workbook, click Another PivotTable.

For more information, click  [image].


To advance to the next step of the wizard, click Next.


To accept the default options for the remaining steps of the wizard and view the results in your document, click Finish.


To specify data for your PivotTable, type the range in the Range box or select the data on the worksheet.


To select a different workbook containing the list or data range you want to use, click Browse.


Displays the type of sort, based on the active cell. If the active cell under Sort By is a label for a row or column field, the Label option is automatically selected. If the active cell is an item in a row or column field, the Values option is automatically selected.


Describes how Microsoft Excel will sort your PivotTable, based on the active cell and the options you've selected in the Sort dialog box.


To specify a custom sort for your PivotTable field, click Options.


To specify the first item when you group data in a PivotTable, type the starting number in the Starting At box. If you want Microsoft Excel to determine the first item, select the Auto check box.


To specify the last  item when you group data in a PivotTable, type the ending number in the Ending At box. If you want Microsoft Excel to determine the last item, select the Auto check box.


Add Data Field command (shortcut menu)

Adds another data field to an existing PivotTable. Microsoft Excel displays a menu that lists the fields in the source data. On the menu, click the field you want to add.


Add Row Field command (shortcut menu)

Adds another row field to an existing PivotTable. Microsoft Excel displays a menu that lists the source data fields that are not already row, column, or page fields in your PivotTable. On the menu, click the field you want to add.


Add Column Field command (shortcut menu)

Adds another column field to an existing PivotTable. Microsoft Excel displays a menu that lists the source data fields that are not already row, column, or page fields in your PivotTable. On the menu, click the field you want to add.


Add Page Field command (shortcut menu)

Adds another page field to an existing PivotTable. Microsoft Excel displays a menu that lists the source data fields that are not already row, column, or page fields in your PivotTable. On the menu, click the field you want to add.


Show Pages command (shortcut menu)

Displays each page of a page field on a new worksheet in the same workbook. Use this command to further view, analyze, or print data from a page in a page field.


PivotTable Field command (Data menu)

Depending on which cell is active in your PivotTable, changes subtotal and item calculations for a field, or modifies properties of the data area.


To change the increment by which you want to group the items in your PivotTable, enter a number in the By box. (Microsoft Excel determines the group increment automatically, based on the items in your source data.)


To specify the starting date when you group dates in a PivotTable, type the date in mm/dd/yy date format in the Starting At box. If you want Microsoft Excel to determine the starting date from the source data, select the Auto check box.


To specify the ending date when you group dates in a PivotTable, type the date in mm/dd/yy date format in the Ending At box. If you want Microsoft Excel to determine the ending date, select the Auto check box.


To group your data by certain time periods, click a time period in the By box. Microsoft Excel automatically determines a time period based on the date field in your source data.


To specify the number of days you want in a time period, enter a number in the Number Of Days box. This option is available only when you click Days in the By box.


To change the name of the selected PivotTable field, type a new name in the Name box. This does not change the field name in the source data.


To move the selected field to another location in the PivotTable and reorganize the existing PivotTable, click an option under Orientation.


To specify a subtotal for the selected PivotTable field, click an option under Subtotals. Subtotals are placed in separate rows in the PivotTable.

For more information, click  [image].


To subtotal each item in the selected outer row or column field, click Automatic.

To subtotal each item in the selected inner row or column field, click Custom.


To subtotal each item in the selected inner row or column field, or to use more than one type of subtotal in a selected PivotTable field, click Custom and then click the summary functions you want to use.

For more information, click  [image].


To hide or omit subtotals in the selected PivotTable field, click None.


To hide items in the selected field of your PivotTable, click the items in the Hide Items box. At least one item in the field must be visible in your PivotTable.


Displays the name of the selected field exactly as it appears in the source data.


To change the function used to summarize data in the selected field, click a function in the Summarize By box.

For more information, click  [image].


To delete the selected PivotTable field from the PivotTable, click Delete. This does not affect the source data.


To format the numeric items in the selected field, click Number. Custom numeric formats are retained when you move the data in a PivotTable.


To create a custom calculation for the selected data field, click Options. Custom calculations can be useful when you want to compare one data field with another data field in your PivotTable. For example, you can display the sales data of a particular salesperson's sales as a percentage of all sales data in the PivotTable.


To specify a custom calculation for your selected field, click an option in the Show Data As box.

For more information, click  [image].


To use a field in your source data as the base field or comparison field in your custom calculation, click a field in the Base Field box.


To specify certain items in your base field or comparison field to be used in the custom calculation, click items in the Base Item box. When selecting items for your chosen base field, you can specify how these items are to be compared in the calculation.

•	Click Previous when you want each calculation to use the value preceding the current item in the base field.

•	Click Next when you want each calculation to use the value following the current item in the base field.


PivotTable Wizard button (Query And Pivot toolbar)

Starts the PivotTable Wizard, which guides you through creating or modifying a PivotTable.


PivotTable Field button (Query And Pivot toolbar)

Depending on which cell is active in your PivotTable, changes subtotal and item calculations for a field, or modifies properties of the data area.


Ungroup button (Query And Pivot toolbar)

In a PivotTable, separates a group of items into the individual items that made up the group; for example, it separates quarters (of years) into the individual dates.

Removes selected rows or columns from a group in an outlined worksheet.


Group button (Query And Pivot toolbar)

In a PivotTable, 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, charting, or printing.

When outlining a document, defines the selected rows or columns of detail data as a group in an outline so that you can summarize the data. If you have not created an outline, creates one for you.


Hide Detail button (Query And Pivot toolbar)

In a PivotTable, hides the detail data of an outer item in a row field or column field.

In an outlined worksheet, hides the detail rows or columns of a selected summary row or column.


Show Detail button (Query And Pivot toolbar)

In a PivotTable, displays the detail data of a hidden row field or column field.

In an outlined worksheet, displays the hidden detail rows or columns of a selected summary row or column.


Show Pages button (Query And Pivot toolbar)

Displays each page of a page field in a new worksheet in the same workbook.


Refresh Data button (Query And Pivot toolbar)

Updates the data in a PivotTable if the source data has changed.


To customize page fields for a PivotTable that you created from multiple Microsoft Excel consolidation ranges, click I Will Create The Page Fields.

You can assign separate names to your ranges in as many as four page fields.


To create only one page field for a PivotTable that you created from multiple Microsoft Excel consolidation ranges, click Create A Single Page Field For Me.


To specify the range for each consolidation source you want in your PivotTable, enter the sheet name and range reference in the Range box. If the range is from another workbook, type the workbook 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.


To select a workbook from which to consolidate a range in your PivotTable, click Browse. You must edit the browsed reference in the Range box so that the syntax reads as follows: [workbookname]sheetname!range.


To add the reference in the Range box to the list of references in the All Ranges box, click Add.


To delete the reference selected in the All Ranges box, click Delete. This does not affect the source data.


Lists all the worksheet ranges that will be consolidated or combined in your PivotTable.


To specify the number of page fields you want displayed in your PivotTable, click a number.


To create item labels for the worksheet ranges listed in the All Ranges box, select a range in the box, and then type an item name in each available field box. The number of available field boxes is determined by the number of page fields you specified.


To return to the previous step in the wizard, click Back.


To design the layout of your PivotTable, drag field names into the Row, Column, Data, or Page area.

For more information, click  [image].


To specify the upper-left cell of the range on the worksheet where you want the PivotTable to be placed, select the cell on the worksheet or type a cell reference in the PivotTable Starting Cell box.

To create the PivotTable on a new worksheet in the same workbook, leave the PivotTable Starting Cell box blank.


To change the name of the PivotTable, type a new name in the PivotTable Name box.


To specify options for displaying and saving the data in the PivotTable, select the options you want under PivotTable Options.


To display grand totals for columns in your PivotTable, select the Grand Totals For Columns check box.


To display grand totals for rows in your PivotTable, select the Grand Totals For Rows check box.


To save a copy of the source data on which the PivotTable is based, select the Save Data With Table Layout check box.

If you do not save a copy of the source data and you later want to manipulate, analyze, or customize your PivotTable by using the PivotTable Fields command (Data menu), you must first use the Refresh command (Data menu) to reattach the source data to the PivotTable. If you do not save this data, it will also be discarded from other PivotTables in the same workbook that use this PivotTable as a data source.


To apply the default Microsoft Excel AutoFormat to your PivotTable, select the AutoFormat Table check box. To apply a different AutoFormat to your PivotTable, use the AutoFormat command on the Format menu.


Print Preview command (File menu)

Displays each page as it will look when it's printed.


To display the next page, click Next.


To display the previous page, click Previous.


To switch between a magnified view and a full-page view of a sheet, click Zoom. Zoom does not affect printing size.


To set printing options so that you can print the selected sheet, click Print.


To set options that control the appearance of printed sheets, click Setup.


To display or hide the handles used to adjust page margins, header and footer margins, and column widths, click Margins.


To specify the portion of the workbook you want to print, click an option under Print What.


To print only the cells selected on the worksheet, click Selection.


To print each of the selected sheets, click Selected Sheets. Each sheet in the workbook starts on a new page. If a print area is defined on a sheet, only the print area is printed.


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


To specify which pages on the selected sheets to print, click an option under Page Range.


To print a range of pages, click Page(s), and then enter the starting and ending page numbers in the From and To boxes, respectively.


Set Print Area command (File menu, Print Area submenu)

Defines the selected range as the print area, which is the only portion of the worksheet that will be printed.


Clear Print Area command (File menu, Print Area submenu)

Removes the print area from the worksheet.


AutoSave command (Tools menu)

Saves your work automatically at the interval you specify.


Save Workspace command (File menu)

Saves a list of the open workbooks, their sizes, and their positions on the screen to a workspace file so that the screen will look the same the next time you open the workspace file.


Table command (Data menu)

Creates a data table — based on input values and formulas you define — that you can use to show the results of changing values in your formulas.


To specify the input cell reference for a one-variable data table, when the input values are in a row, enter the reference in the Row Input Cell box. For a two-variable data table, enter references in both this box and the Column Input Cell box.


To specify the input cell reference for a one-variable data table, when the input values are in a column, enter the reference in the Column Input Cell box. For a two-variable data table, enter references in both this box and the Row Input Cell box.


Goal Seek command (Tools menu)

Adjusts the value in a specified cell until a formula that is dependent on that cell reaches a target value.


To specify the cell that contains the formula you want to find a solution for, enter the cell reference or name in the Set Cell box.


To specify the new value you want to reach, type a number in the To Value box.


To specify the cell that contains the value you want to change, enter the cell reference in the By Changing Cell box. This cell must refer directly or indirectly to the formula in the Set Cell box.


Scenarios command (Tools menu)

Creates and saves scenarios, which are sets of data you can use to view the results of what-if analyses.


Lists the scenarios that are defined on the active worksheet.


Displays the cells that contain the data you want to change in a 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.


To display values on the worksheet for the selected scenario, click Show.


To specify values for each changing cell, click Add.


To name the changing cells, type a name in the Scenario Name box.


To specify or edit cells that contain the data you want to change, enter the cell references in the Changing Cells box.


To create or edit the user name, date of a scenario, or other information, type your text in the Comment box.


To protect scenarios from modification, select the Prevent Changes check box. To hide scenarios, select the Hide check box.


To prevent others from making changes to your scenario, select the Prevent Changes check box. You will also need to activate sheet protection 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.


To remove a scenario from the list in the Scenario Manager dialog box, select the Hide check box. You will also need to activate sheet protection by pointing to Protection on the Tools menu and then clicking Protect Sheet.


To enter the values you've specified for each of the changing cells, click OK.


To return to the Add Scenario dialog box, click Add.


To edit the values of a changing cell, make the changes you want in the box next to the reference for the changing cell. Only the first five changing cells are displayed.


To delete the selected scenario, click Delete.


To modify the scenario name, the references for the changing cells, or comments for the selected scenario, click Edit.


To change the scenario name, type your changes in the Scenario Name box.


To display the Merge Scenarios dialog box so that you can merge scenarios from worksheets in any open workbook, click Merge.


To specify the workbook you want to merge scenarios from, click the name of the workbook in the Book box.


To specify the worksheet you want to merge scenarios from, click the name of the worksheet in the Sheet box.


To create a Scenario Summary report or a Scenario PivotTable report, click Summary.


To specify the type of report you want to create, click Scenario Summary or Scenario PivotTable.


To create a report that lists your scenarios with their input values and result cells, click Scenario Summary. Use this type of report when your model has only one set of changing cells provided by a single user.


To create a report that gives you instant what-if analysis of your scenarios, click Scenario PivotTable. Use this type of report when your model has multiple sets of changing cells provided by more than one user.


To specify the cells you want to recalculate when you apply a new scenario, type the cell references in the Result Cells box. The referenced cells must include formulas that are related to the changing cells.


Displays the results of the goal-seeking process. To keep the resulting values on the worksheet; click OK. To restore the original values, click Cancel.


To move through the goal-seeking process one step at a time, click Step.


To interrupt the goal-seeking process, click Pause. To resume the process, click Continue.


Row heading

The numbered gray area to the left of each row. To select a row, click the row heading. 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 gray area at the top of each column. To select a column, click the column heading. 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.


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.


Select All button

The gray rectangle in the upper-left corner of a worksheet where the row and column headings meet. To select all cells on a worksheet, click this button.


Window sizing border

The border around a window. To change the shape and size of a window, drag its border. To size the window in two directions at once, drag a corner of the border.


Sheet tab

A tab near the bottom of a workbook window that displays the name of a sheet. To make a sheet active, click its tab. 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.


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. To display or hide the status bar, click Status Bar on the View menu.


Tab split box

The small box between the sheet tabs and the horizontal scroll bar. To display additional sheet tabs or increase the size of the horizontal scroll bar, drag the tab split box to the right or left. To return to the default display of sheet tabs, double-click the box.


Name box

The box at the left end of the formula bar that identifies the selected cell, chart item, or drawing object. To quickly name a selected cell or range, type the name in the Name box, and then press ENTER. To move to and select a previously named cell, click its name in the Name box.


Tab scrolling buttons

The arrow buttons to the left of the sheet tabs. To scroll between sheet tabs, 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.


Scroll bars

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.


Outline symbols

The minus sign, plus sign, and number symbols that appear next to row or column headings in an outlined worksheet. To hide or display information in the outline, click the symbols.


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 or chart, type the data, and then press ENTER. You can also double-click a cell to edit data directly in the cell.


Status Bar command (View menu)

Displays or hides the status bar.


Code pane

A type of sheet that contains programming statements. You can display, edit, and write module-level and procedure code in a code pane.


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 cross hair. To fill cells with data based on the current selection, drag the fill handle down or to the right. 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 control

A shaded cell in a PivotTable that contains the name of a summarized field of data from a database, list, or table. To change the way data is summarized, drag controls between rows and columns. To customize the way data is summarized, double-click a control.


AutoFilter control

An arrow next to a column title in a filtered table or list. To specify which items you want to display in the column, click the arrow, and then click the items you want. To remove the controls, point to Filter on the Data menu, and then click AutoFilter.


Displays "M" if the linked item is updated manually. Displays "A" if the linked item is updated automatically whenever the source file changes.


Displays the application, location, and name of the document containing the link, and the type of link. To change the link, change the name and location of the linked file specified in the Change Links To box.


To see a message each time before linked items are updated automatically, select the Ask To Update Automatic Links check box.


Copy Picture (Edit menu)

Copies a picture of the selected cell, cell range, or embedded chart.


To copy the selected object, as displayed on your monitor, select the As Shown On Screen check box.

To copy the selected object in a format for a printer, select the As Shown When Printed check box. The object will appear on your screen the same size as it will appear when it is printed. Colored objects may become black and white if your printer prints only black.


To display a picture as a bitmap, select the Bitmap check box. 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.

To display a picture as a Windows metafile, select the Picture check box. 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.


Paste Picture (Edit menu)

Pastes a picture of the contents of the Clipboard.


Shared Lists command (File menu)

Switches to shared mode, which allows you and other users on your network to edit the same workbook.


Status list (File, Shared lists, Shared lists dialog, Status tab)
Shows the names of users who are currently working on the shared workbook, along with the date and time they opened it.


Allow multi-user editing (File, Shared lists, Shared lists dialog, Editing tab)
To allow other users on your network to edit this workbook at the same time, select the Allow Multi-User Editing check box.

To prevent other users from editing this workbook at the same time, clear this check box.


Show Conflict History (File, Shared lists, Shared lists dialog, Editing tab)
To display the Conflict History worksheet in a shared workbook, select the Show Conflict History check box. This creates a worksheet that keeps track of shared list conflicts and the resolutions chosen by users. It's placed as the last sheet in the workbook.


Your changes on sheet (Conflict resolution dialog)
Displays the cell address and value you entered (during the current session) that conflicts with another user's entry.


Conflicting changes by (Conflict resolution dialog)
Displays the cell address and value entered by another user (during the current session) that conflicts with your entry.


Use all remaining changes from my session press button (Conflict resolution dialog)
To save all your changes from the current session to the shared workbook, click Use All Remaining Changes From My Session.


Use all remaining changes from the other session press button (Conflict resolution dialog)
To save all changes that other users have made to the shared workbook during the current session, click Use All Remaining Changes From The Other Session.


Use my changes button (Conflict resolution dialog)
To accept the value in the Your Changes On Sheet box, click Use My Changes.


Use these changes button (Conflict resolution dialog)
To accept the value in the Conflicting Changes By box, click Use These Changes.


Solver command (Tools menu)

Displays the Solver Parameters dialog box, in which you define the problem you want to solve. With Solver, you can solve complex problems by creating a worksheet model with multiple changing cells and multiple constraints.


Sort command (Data menu)

Arranges rows in a list according to the contents of particular columns.


Sort Ascending button (Standard toolbar)

Sorts a list in order from lowest to highest value, using the column that contains the active cell. If other sorting options were used in a previous sort, those options are also applied.

In a pivot table, items are sorted in ascending alphabetic order, using the selected field. Numbers are sorted from lowest to highest value.


Sort Descending button (Standard toolbar)

Sorts a list in order from highest to lowest value, using the column that contains the active cell. If other sorting options were used in a previous sort, those options are also applied.

In a pivot table, items are sorted in descending alphabetic order, using the selected field. Numbers are sorted from highest to lowest value.


To specify a custom sort order, select the sort order you want in the First Key Sort Order box.


To sort rows by a specific column, select the column you want in the Sort By box.


To use the lowest number first in the sorted list, or the beginning of the alphabet or earliest date, click Ascending.

To use the highest number first in the sorted list, or the end of the alphabet or latest date, click Descending.


 To sort by an additional column, select the column you want in the Then By box.


To exclude the first row from the sort if your list has column labels in the uppermost row, click Header Row.

To include the first row in the sort if the list doesn't have column labels in the uppermost row, click No Header Row.


To specify a custom sort order for the column specified in the Sort By box, click Options. You can specify a case-sensitive sort, or change the sort orientation from top to bottom to left to right.


To sort capitalization, click Case Sensitive. This option is not available when you sort items in a pivot table.


To sort rows by a single column, click Sort Top To Bottom.

To sort columns by a single row, click Sort Left To Right.


To create a new list, click New List, and then type the entries in the List Entries box.


To create a new custom list, type the list entries in the List Entries box. The first character in a list entry cannot be a number. Press ENTER to separate each entry. To use the custom list as a custom sort order, enter the items in the same order by which you want them to sort.


To create a custom list from a worksheet range, enter the range in the Import List From Cells box. Select the range, and then click Import.


To save a custom list in the List Entries box, click Add.


To delete a selected custom list, click Delete. You cannot delete the built-in custom lists.


To create a custom list from the selected range in the Import List From Cells box, click Import.


Data Analysis command (Tools menu)

Lists the statistical and engineering tools in the Analysis ToolPak.


Subtotals command (Data menu)

Calculates subtotal and grand total values for the labeled columns you select. Microsoft Excel automatically inserts and labels the total rows and outlines the list.


To specify each column that you want subtotals for, select a label from the At Each Change In box.


To specify the summary function you want to use to subtotal your values, select a function in the Use Function box.


To specify the items for which you want the subtotals to appear in your list, select one or more check boxes under Add Subtotal To.


To replace all subtotals in the list with the new subtotals, select the Replace Current Subtotals check box.


To insert page breaks automatically after each group of subtotaled data, select the Page Break Between Groups check box.


To insert the subtotal and grand total rows below the detail data, select the Summary Below Data check box.


To remove all subtotals from the current list, click Remove All.


Display or hide toolbars
To display a toolbar, select the check box next to the toolbar name in the Toolbars box.


Toolbar Name (View menu, Toolbars command, Toolbars dialog box)
Displays the name of the toolbar selected in the Toolbars box. To create a name for a new toolbar, type the name in the Toolbar Name box. You cannot rename a customized or built-in toolbar.


New (View menu, Toolbars command, Toolbars dialog box)
To create a custom toolbar, type a name in the Toolbar Name box, and then click New.


Assign Macro command (Customize Toolbar button shortcut menu)
Assign Macro command (Customize Toolbars shortcut menu)

Assigns a macro to the selected object, to a toolbar button, or to a command on the Tools menu.


Categories (View menu, Toolbars command, Toolbars dialog box, Customize button, Customize dialog box)
To see the available buttons, click the name of a category in the Categories box. To create your own toolbar button, click Custom at the end of the list.


Buttons (View menu, Toolbars command, Toolbars dialog box, Customize button, Customize dialog box)
To place a button on a toolbar, drag the button you want from the Buttons area onto a toolbar. To create a new toolbar, drag a button onto the worksheet.


Description (View menu, Toolbars command, Toolbars dialog box, Customize button, Customize dialog box)
Describes the function of the selected button.


Chart Type button

Displays a palette of 14 chart types. Click a chart type to create an embedded chart or to change the type of the active chart.


Area Chart AutoFormat button

Formats the active chart or the selected embedded chart as an area chart, replacing any formatting already in the chart. If worksheet data is selected, the resulting area chart is an embedded chart.


Bar Chart AutoFormat button

Formats the active chart or the selected embedded chart as a bar chart, replacing any formatting already in the chart. If worksheet data is selected, the resulting bar chart is an embedded chart.


Column Chart AutoFormat button

Formats the active chart or the selected embedded chart as a column chart, replacing any formatting already in the chart. If worksheet data is selected, the resulting column chart is an embedded chart.


Stacked Column Chart AutoFormat button

Formats the active chart or the selected embedded chart as a stacked column chart, replacing any formatting already in the chart. If worksheet data is selected, the resulting stacked column chart is an embedded chart.


Line Chart AutoFormat button

Formats the active chart or the selected embedded chart as a line chart, replacing any formatting already in the chart. If worksheet data is selected, the resulting line chart is an embedded chart.


Pie Chart AutoFormat button

Formats the active chart or the selected embedded chart as a pie chart, replacing any formatting already in the chart. If worksheet data is selected, the resulting pie chart is an embedded chart.


Doughnut Chart AutoFormat button

Formats the active chart or the selected embedded chart as a doughnut chart, replacing any formatting already in the chart. If worksheet data is selected, the resulting doughnut chart is an embedded chart.


3-D Area Chart AutoFormat button

Formats the active chart or the selected embedded chart as a 3-D area chart, replacing any formatting already in the chart. If worksheet data is selected, the resulting 3-D area chart is an embedded chart.


3-D Bar Chart AutoFormat button

Formats the active chart or the selected embedded chart as a 3-D bar chart, replacing any formatting already in the chart. If worksheet data is selected, the resulting 3-D bar chart is an embedded chart.


3-D Column Chart AutoFormat button

Formats the active chart or the selected embedded chart as a 3-D column chart, replacing any formatting already in the chart. If worksheet data is selected, the resulting 3-D column chart is an embedded chart.


3-D Perspective Column Chart AutoFormat button

Formats the active chart or the selected embedded chart as a 3-D perspective chart, replacing any formatting already in the chart. If worksheet data is selected, the resulting 3-D perspective chart is an embedded chart.


3-D Line Chart AutoFormat button

Formats the active chart or the selected embedded chart as a 3-D line chart, replacing any formatting already in the chart. If worksheet data is selected, the resulting 3-D line chart is an embedded chart.


XY (Scatter) Chart AutoFormat button

Formats the active chart or the selected embedded chart as an xy (scatter) chart, replacing any formatting already in the chart. If worksheet data is selected, the resulting xy (scatter) chart is an embedded chart.


3-D Surface Chart AutoFormat button

Formats the active chart or the selected embedded chart as a 3-D surface chart, replacing any formatting already in the chart. If worksheet data is selected, the resulting 3-D surface chart is an embedded chart.


Radar Chart AutoFormat button

Formats the active chart or the selected embedded chart as a radar chart, replacing any formatting already in the chart. If worksheet data is selected, the resulting radar chart is an embedded chart.


Line/Column Chart AutoFormat button

Formats the active chart or the selected embedded chart as a line/column chart, replacing any formatting already in the chart. If worksheet data is selected, the resulting line/column chart is an embedded chart.


Volume/High-Low-Close Chart AutoFormat button

Formats the active chart or the selected embedded chart as a volume/high-low-close chart, replacing any formatting already in the chart. If worksheet data is selected, the resulting volume/high-low-close chart is an embedded chart.


AutoFormat command (Format menu)

Applies built-in or custom (user-defined) autoformats to an active chart. The command also adds a new custom autoformat to, or deletes an existing custom autoformat from, the list in the Formats box.


To determine whether the formats that are displayed come from autoformats built into the product or from ones that you've added, click the appropriate option under Formats Used.


To display autoformats that you've defined or to add or delete new custom formats, click User-Defined.


To display built-in chart autoformats, click Built-in.


To view and select examples of built-in autoformats, click the chart type in the Galleries box. This option is available when Built-in is selected; the option is named "Formats" when User-Defined is selected.

To view and select formats that you've saved, or to view and select the Microsoft Excel 4.0 chart format, click the chart format name in the Formats box.


To view options for adding and deleting customized autoformats, click Customize. To save the formatting of the active chart for later use, add the formatting as a custom autoformat.


To see how the active chart would look with the custom autoformat you've selected, view the display under Format Sample.


To create a custom autoformat based on the active chart, click Add.


To delete a custom autoformat, click the format in the Formats box, and then click Delete.


To see descriptions of custom autoformats, view the text to the right of Format Description.


To assign a name to the autoformat you're adding, type a name up to 31 characters long in the Format Name box.


To assign a description to the autoformat you're adding, type a description up to 32 characters long in the Description box.


Chart Type command (Format menu)

Changes the chart type for an individual data series, a chart type group, or an entire chart.


To determine whether the chart type is changed for the selected series, the chart type group, or the entire chart, click the appropriate option under Apply To.


To change the chart type for the selected series, click Selected Series. When 3-D Chart Dimension is selected, the Selected Series and Group options are unavailable because you cannot combine 3-D charts with any other chart type.


To change the type of the chart type group, click the name of a group in the Group box. When 3-D is selected under Chart Dimension, the Selected Series and Group options are unavailable, because you cannot combine 3-D charts with any other chart type.


To change the chart type for all series in the chart, click Entire Chart.


To select from either 2-D or 3-D chart types, click an option under Chart Dimension. The Selected Series and Group options are unavailable when you click 3-D, because you cannot combine 3-D charts with any other chart type.


To select from 2-D chart types, click 2-D.


To select from 3-D chart types, click 3-D. The Selected Series and Group options are unavailable when you select the 3-D option, because you cannot combine 3-D charts with any other chart type.


To change the chart type for the active chart, double-click a chart format. To see additional options for a particular chart type, click the chart type, and then click Options.


To select additional options for the selected chart type, such as subtype and series order, click Options.


Zoom Control box (Standard toolbar)

Reduces or enlarges the display of a sheet. To set any magnification from 10 to 400 percent, enter the value in the Zoom Control box.

Changing the magnification of sheets does not affect printing. Microsoft Excel prints sheets at 100-percent size unless you specify a different magnification by using the Page Setup command (File menu).


Hide command (Format menu, Row or Column submenu)

Hides the selected rows or columns. Hiding rows or columns does not delete them from the worksheet.


Unhide command (Format menu, Row or Column submenu)

Shows rows or columns in the current selection that were previously hidden.


To display the formula bar, select the Formula Bar check box.


To display the status bar, which shows information about a selected command or option, select the Status Bar check box. The status bar appears at the bottom of the application window.


To display a small red dot in the upper-right corner of a cell when there is a note attached to the cell, select the Note Indicator check box.


To display the Info window, which shows detailed information about the active cell, select the Info Window check box.


To display all graphic objects, buttons, text boxes, drawn objects, and pictures, select the Show All check box.


To display selected pictures and charts as gray rectangles, select the Show Placeholders check box. 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.


To hide all graphic objects, buttons, text boxes, drawn objects, and pictures, select the Hide All check box. Microsoft Excel does not print hidden objects.


To display page breaks that have been set automatically by Microsoft Excel, select the Automatic Page Breaks check box.


To display the formulas in cells instead of the values that the formulas produce, select the Formulas check box.


To display cell gridlines, select the Gridlines check box.


To set the color for gridlines and for column and row headings, click the color you want in the Color box. If you click Automatic, the color is based on the text color defined in the Control Panel.


To display row and column headings, select the Row & Column Headers check box.


To display outline symbols, select the Outline Symbols check box. Microsoft Excel does not display outline symbols unless the worksheet contains a previously created outline.


To display a 0 (zero) in cells that contain 0 values, select the Zero Values check box.


To display sheet tabs so that you can navigate among and select workbook sheets, select the Sheet Tabs check box. Sheet tabs appear at the bottom of the sheet window.


Zoom In button (Utility category)

Enlarges the display of the worksheet, macro sheet, or chart sheet to the next higher magnification. Changing the magnification of sheets does not affect printing.


 	Zoom Out button (Utility category)

Reduces the display of the worksheet, macro sheet, or chart sheet to the next lower magnification. Changing the magnification of sheets does not affect printing.


To display a worksheet or chart sheet in different sizes so that you can navigate, position objects, or view your sheet, select the magnification you want.


To display the selected cells or chart sheet to fit in the current window size, select the Fit Selection check box.


To enlarge or reduce a worksheet or chart sheet by a specific percentage so that you can navigate, position objects, or view the sheet, select the Custom check box, and then type the percentage in the Custom box.


Zoom command (View menu)

Changes the magnification of a worksheet or chart sheet so that you can navigate, position objects, or view the sheet.


Freeze Panes command or Unfreeze Panes command (Window menu)

Freezes or unfreezes the top pane, the left pane, or both on the active worksheet. Use the Freeze Panes command to keep column or row titles in view while you're scrolling through a worksheet. Freezing titles on a worksheet does not affect printing.


Freeze Panes button (Utility category)

Freezes the top pane, the left pane, or both on the active worksheet. Use the Freeze Panes button to keep column or row titles in view while you're scrolling through a worksheet. Freezing titles on a worksheet does not affect printing.


Set Print Area button

Sets selected cells as area to print.


Insert Chart Sheet button

Creates a new chart with the default format settings.


Insert MS Excel 4.0 Macro button

Inserts a new macro sheet.


Insert Dialog button

Creates an empty custom dialog box form.


Find File button

Finds files that meet specific criteria.


Routing Slip button

Adds a routing slip to the current workbook if Microsoft Exchange or another electronic mail system is installed.


Send Mail button

Sends the active workbook as an attachment to an electronic mail message.


Update File button

Updates a read-only file to the most recently saved version.


Toggle Read-only button

Switches a file between read-only and read-write status.


Delete button

Removes the selected cells.


Insert button

Inserts blank cells.


Equal Sign button

Inserts an equal sign (=) in the formula bar.


Plus Sign button

Inserts a plus sign (+) in the formula bar.


Minus Sign button

Inserts a minus sign (-) in the formula bar.


Muliplication Sign button

Inserts an asterisk (*) in the formula bar.


Division Sign button

Inserts a forward slash (/) in the formula bar.


Exponentiation sign button

Inserts a caret (^) in the formula bar.


Left Parenthesis button

Inserts a left parenthesis [ ( ] in the formula bar.


Right Parenthesis button

Inserts a right parenthesis [ ) ] in the formula bar.


Colon button

Inserts a colon (:) in the formula bar.


Comma button

Inserts a comma (,) in the formula bar.


Percent Sign button

Inserts a percent sign (%) in the formula bar.


Dollar Sign button

Inserts a dollar sign ($) in the formula bar.


Paste Names button

Inserts a named cell or range of cells.


Color button

Applies color to the selection.


Dark Shading button

Applies dark shading to the selection.


Light Shading button

Applies light shading to the selection.


Lock Cell button

Locks selected cells and objects to prevent changes to them, or unlocks them so that you can make changes.


Camera button

Pastes a picture of the linked selection.


Calculate Now button

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


Answer Wizard button

Displays the Answer Wizard.


AutoFilter button

Filters all the columns of a list.


Tab Order button

Changes the order in which Microsoft Excel moves to each dialog box control when you press the TAB key while a form is open.


Label button (Forms toolbar)

Creates a text label on a worksheet or dialog sheet or in chart.


Edit Box button (Forms toolbar)

Creates an edit box in which you can type text on a dialog sheet.


Group Box button (Forms toolbar)

Creates a group box on a worksheet or dialog sheet or in a chart.


Create Button button (Forms toolbar)

Creates a button to which you can assign a Visual Basic procedure on a worksheet or dialog sheet or in a chart.


Check Box button (Forms toolbar)

Creates a check box on a worksheet or dialog sheet or in a chart.


Option Button button (Forms toolbar)

Creates an option button on a worksheet or dialog sheet or in a chart.


List Box button (Forms toolbar)

Creates a list box on a worksheet or dialog sheet or in a chart.


Drop-Down button (Forms toolbar)

Creates a drop-down list box on a worksheet or dialog sheet or in a chart.


Combination List-Edit button (Forms toolbar)

Creates a combination list box and edit box on a dialog sheet.


Combination Drop-Down Edit button (Forms toolbar)

Creates a combination drop-down list box and edit box on a dialog sheet.


Scroll Bar button (Forms toolbar)

Creates a scroll bar on a worksheet or dialog sheet or in a chart.


Spinner button (Forms toolbar)

Creates a spin box control on a worksheet or dialog sheet or in a chart.


Control Properties button (Forms toolbar)

Changes the properties of the controls on a worksheet or dialog sheet or in a chart.


Edit Code button (Forms toolbar)

Edits or creates code for the selected object.


Toggle Grid button (Forms toolbar)

Hides or displays gridlines used to align objects on a form on a worksheet or dialog sheet.


Run Dialog button (Forms toolbar)

Runs the custom dialog box currently being edited on the dialog sheet.


Custom button

Assigns a custom button to a macro.


Select Visible Cells button

Selects only the cells that are visible within the selected range; hidden cells are not selected. Hidden cells are not affected by changes you make to the selection.


Select Current Region button

Selects a rectangular range of filled-in cells that includes the active cell. The selected range is the block of data bounded by blank rows and columns.


1,2,3,...9 commands (Window menu)

Lists up to nine open windows in the order in which they were opened. Click a window to make it active. The check mark indicates the active window.


Arrange command (Window menu)

Arranges open windows so that you can see at least part of each window.


To arrange windows in a preset pattern, click an option.


To arrange the windows of only the active workbook, select the Windows Of Active Workbook check box


Arrange Icons command (Window menu)

Arranges the icons of minimized workbook windows from left to right at the bottom of the application window.


More Windows command (Window menu)

Lists all open windows. Double-click a window to make it active. This command is available only when more than nine windows are open.


New Window command (Window menu)

Opens an additional window for the active workbook so that you can view different parts of the workbook at the same time. A number is added to the workbook name in the window title bars and in the list on the Window menu — for example, SALES.:1, SALES.:2, SALES.:3.


Hide command (Window menu)

Hides the active workbook window. A hidden window remains open.


Unhide command (Window menu)

Displays hidden workbook windows.


To display a window, double-click the window name in the Unhide Workbook list.


Down command (Edit menu, Fill submenu)

Copies the contents and formats of the top cell or cells of a selected range into the lower cells of the range. Copied contents and formats replace existing contents and formats.


Right command (Edit menu, Fill submenu)

Copies the contents and formats of the leftmost cell or cells of a selected range into the cells to the right. Copied contents and formats replace existing contents and formats.


Up command (Edit menu, Fill submenu)

Copies the contents and formats of the bottom cell or cells of a selected range into the upper cells of the range. Copied contents and formats replace existing contents and formats.


Left command (Edit menu, Fill submenu)

Copies the contents and formats of the rightmost cell or cells of a selected range into the cells to the left. Copied contents and formats replace existing contents and formats.


Fill Right button

Copies the contents and formats of the leftmost cell or cells of a selected range into the cells to the right. To fill the selection to the left instead of the right, hold down SHIFT and click the Fill Right button.


Fill Down button

Copies the contents and formats of the topmost cells of a selected range into the cells below. To fill a selected range up instead of down, hold down SHIFT and click the Fill Down button.


Across Worksheets command (Edit menu, Fill submenu)

Copies the contents of the range of cells selected on the active worksheet to the same range of cells on all the other selected sheets in a group. This command is available only if a group of sheets is selected.


 To specify which items to copy from the selected cells, select an option under Fill.


Series command (Edit menu, Fill submenu)

Fills the selected range of cells with one or more series of numbers or dates. 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.


To specify whether the series is filled across selected rows or down selected columns, click Rows or Columns.


To calculate a best-fit line (for linear series) or geometric curve (for growth series), select the Trend box. 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. For more information, click  [image].


To specify the amount by which a series increases or decreases, type a positive or negative number in the Step Value box. A positive number increases a series; a negative number decreases a series.


To specify the value at which you want a series to end, type the value in the Stop Value box. The value can be positive or negative. If the selection is filled before the series reaches the stop value, the series stops at that point. The Stop Value box can be left blank.


To select the type of series, click an option under Type.


To create a linear series or linear best-fit trend, select Linear.

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.


To create a growth series or geometric growth trend, select Growth.

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.


To create a series of dates, select Date. The part of the date that is incremented in the series depends on the option selected under Date Unit.


To fill blank cells in a selection with a series based on data included in the selection, select AutoFill. 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. For more information, click  [image].


To specify whether a series of dates will increase by days, weekdays, months, or years, select an option under Date Unit. Use only when creating a date series.


Fill Days command (AutoFill shortcut menu)

Fills the selection by incrementing days.


Fill Months command (AutoFill shortcut menu)

Fills the selection by incrementing months.


Growth Trend command (AutoFill shortcut menu)

Creates a growth trend by multiplying in turn each cell value by a step value. The step value is calculated from the selected original values.


Fill Formats command (AutoFill shortcut menu)

Fills the selected range with only the formats of the originally selected cells.


Fill Series command (AutoFill shortcut menu)

Increments the values in the originally selected cells through the selected range.


Fill Values command (AutoFill shortcut menu)

Fills the selected range with only the values of the originally selected cells. If the selected original values are types of data that Microsoft Excel can extend in a series, such as numbers or dates, the values are incremented. Otherwise, the values are copied.


Fill Weekdays command (AutoFill shortcut menu)

Fills the selection by incrementing weekdays.


Fill Years command (AutoFill shortcut menu)

Fills the selection by incrementing years.


Linear Trend command (AutoFill shortcut menu)

Creates a linear trend by adding a step value to each cell value in turn. The step value is calculated from the selected original values.


Copy Cells command (AutoFill shortcut menu)

Copies the contents and formats of the originally selected cells to the selected range. Use this command when you want to copy types of data that Microsoft Excel normally increments as a series, such as numbers and dates.


To create a custom AutoFill list, type the items in the List Entries box in the order you want them filled on a worksheet. Press ENTER after each item, and then click Add.


To display a message if you drop cells over other cells that contain data, select the Alert Before Overwriting Cells check box


To move and copy cells and data by dragging, select the Allow Cell Drag And Drop check box. With this option selected, you can also drag the fill handle to copy data and to fill adjacent cells with a series of data.


To determine where Microsoft Excel will automatically put the decimal point in the numbers you enter as constants on a worksheet, select the Fixed Decimal check box, and then enter the number of decimal places in the Places box. A positive number moves the decimal to the left; a negative number moves the decimal to the right. If the Places box is left blank or set at zero, you need to enter the decimal point manually. To override this option, type a decimal point as you enter the number.


To make an adjacent cell the next active cell after you press ENTER in the current active cell, select the Move Selection After Enter check box. In the Direction box, indicate which adjacent cell becomes active.


To edit directly inside a cell by double-clicking the cell, select the Edit Directly In Cell check box.


To allow Microsoft Excel to complete text entries you type in a column of cells, select the Enable AutoComplete For Cell Values check box. If the first few letters you type match an existing entry in that column, Microsoft Excel fills in the remaining text for you.


To change the reference style of row and column headings and cell references to A1 style, click A1. In A1 style, columns are labeled alphabetically and rows are labeled numerically.

To change the reference style of row and column headings and cell references to R1C1 style, click R1C1. In R1C1 style, both columns and rows are labeled numerically.


To display a list of recently used files at the bottom of the File menu, select the Recently Used File List check box.


To display Microsoft Excel 4.0 menus instead of the default Microsoft Excel menus, select the Microsoft Excel 4.0 Menus check box. To return to the default Microsoft Excel menus, click New Menus on the Options menu.


To ignore requests made from other applications that use Dynamic Data Exchange (DDE), select the Ignore Other Applications check box.


To display the summary information when you save a new workbook, select the Prompt For File Properties check box. The Summary tab of the Properties command (File menu) contains information such as the author, title, and subject of a workbook.


To restore the ability of the TipWizard to display tips you have already seen, select the Reset TipWizard check box.


To set the default number of worksheets in a new workbook, enter the number in the Sheets In New Workbook box.


To set the standard font for new sheets and workbooks, click the font in the Standard Font list. The new standard font is used the next time you start Microsoft Excel.


To set the standard font size for new sheets and workbooks, enter the font size in the Size box. The new standard font size is used the next time you start Microsoft Excel.


To set the default working folder, type the path in the Default File Location box.


To specify the path to an alternate startup folder, type the full path in the Alternate Startup File Location box.


To enter the name you want to display in scenarios, views, file sharing, and summary information, type the name in the User Name box. The new name is used the next time you start Microsoft Excel.


As Shown On Screen (Edit, Copy Picture, Copy Picture dialog box, Appearance)
To copy a selected cell, cell range, or embedded chart onto a Microsoft Excel worksheet as a graphic object, click As Shown On Screen.


As Shown When Printed (Edit, Copy Picture, Copy Picture dialog box, Appearance)
To copy a selected cell, cell range, or embedded chart into another application as a graphic object, click As Shown When Printed.


Picture (Edit, Copy Picture, Copy Picture dialog box, Format)
To copy a selected cell, cell range, or embedded chart in picture format, click Picture. Picture format uses less memory and disk space than bitmap format, allows Microsoft Excel to redraw the screen faster, and works well when you need a high-quality printout.


Bitmap (Edit, Copy Picture, Copy Picture dialog box, Format)
To copy a selected cell, cell range, or embedded chart in bitmap format, click Bitmap. Bitmap format uses more memory and disk space than picture format, may cause slow screen redrawing, and does not work well when you need a high-quality printout. The bitmap can be displayed correctly only on a screen of the same type and resolution as that of the screen on which it was created.


Automatic option (Format, Object, Format Object db, Patterns tab)
To apply the default settings for the color, thickness, and line or border style to the selected graphic object, click Automatic.


None option (Format, Object, Format Object db, Patterns tab)
To remove the selected line, or the border or fill from the selected graphic object, click None.


Custom option (Format, Object, Format Object db, Patterns tab)
To specify a style you choose for the selected graphic object, click Custom.


Style box (Format, Object, Format Object db, Patterns tab)
To change the look of the selected line or of the selected graphic object's border, click a line or border style in the Style box.


Color box (Format, Object, Format Object db, Patterns tab)
To change the color of the selected line or of the selected graphic object's border, click a color in the Color box.


Weight box (Format, Object, Format Object db, Patterns tab)
To change the thickness of the selected line or of the selected graphic object's border, click an option in the Weight box.


Shadow box (Format, Object, Format Object db, Patterns tab)
To add a shadow to a rectangle, ellipse, chart, or text box, select the Shadow check box.


Round Corners box (Format, Object, Format Object db, Patterns tab)
To make the corners of a rectangle, chart, or text box round, select the Round Corners check box.


Pattern box (Format, Object, Format Object db, Patterns tab)
To choose a fill pattern for the selected cells or graphic objects, click a fill pattern in the Pattern box.


Style box (Format, Object, Format Object db, Patterns tab, Arrowhead)
To change the look of an arrowhead, click an option in the Style box.


Width box (Format, Object, Format Object db, Patterns tab, Arrowhead)
To change the width of an arrowhead, click an option in the Width box.


Length box (Format, Object, Format Object db, Patterns tab, Arrowhead)
To change the length of an arrowhead, click an option in the Length box.


Sample (Format, Object, Format Object db, Patterns tab)
Shows the styles and patterns you have chosen for the selected graphic object.


Locked (Format, Object, Format Object db, Protection tab)
To prevent a selected object, such as a chart, from being changed, moved, resized, or deleted, select the Locked check box. This feature takes effect only when the worksheet is also locked.


Lock Text (Format, Object, Format Object db, Protection tab)
To prevent changes to text in a text box, select the Lock Text check box. This feature takes effect only when the worksheet is also locked.


Move And Size With Cells option (Format, Object, Format Object db, Properties tab, Object Positioning)
To ensure that a graphic object will move and resize with its underlying cells, click Move And Size With Cells. This option anchors selected objects to the cells under its upper-left and lower-right corners.


Move But Don't Size With Cells option (Format, Object, Format Object db, Properties tab, Object Positioning)
To ensure a graphic object will move, but not resize, with its underlying cells, click Move But Don't Size With Cells.


Don't Move Or Size With Cells option (Format, Object, Format Object db, Properties tab, Object Positioning)
To maintain the position and size of a graphic object on your worksheet, click Don't Move Or Size With Cells.


Print Object box (Format, Object, Format Object db, Properties tab)
To print selected graphic objects when you print a worksheet, select the Print Object check box.


Paste Picture command (Edit menu)

Pastes a picture of a copied cell, cell range, or embedded chart into a Microsoft Excel worksheet.


Paste Picture Link command (Edit menu)

Pastes a linked picture of a cell, cell range, or embedded chart into a Microsoft Excel worksheet. When you change the source data, the linked picture also changes.


Copy Picture command (Edit menu)

Copies a picture of a cell, cell range, or embedded chart that you can then paste into the active worksheet or into another Microsoft Excel worksheet.


Color button (Formatting toolbar)

Applies the default color to the selected object. To change the fill color of a selected graphic object, click the down arrow, then select a fill color in the Color box.


Object command (Format menu)

Specifies the attributes of the selected graphic objects.


Selected Object command (Format menu)

Specifies the attributes of the selected graphic object.


Size With Chart (Format, Selected Object command, Properties tab)
To automatically change the size of a graphic object when you change the size of the underlying cells, click Size With Chart.


Don't Size With Chart (Format, Selected Object command, Properties tab)
To ensure that a graphic object will stay the same size regardless of changes to the size of underlying cells, click Don't Size With Chart.


Print Object (Format, Selected Object command, Properties tab)
To print selected graphic objects when you print the chart, click Print Object.


New command (File menu)

Creates a new workbook.


New Workbook button (Standard toolbar)

Creates a new, blank workbook.


To open a workbook on a network or a workbook in a shared folder for viewing only, select the Read Only check box. To save changes to a read-only workbook, use the Save As command to save it with a new name.


Recently Used File List box (Tools, Options, General tab)
To display the names of the most recently used documents on the File menu, select the Recently Used File List check box.


Specify or change your user name
To change your user name, type the new name in the User Name box.


Read Only button (File Open, File Reservation db)
To open a workbook that another user currently has open, click Read Only. To save changes to a read-only workbook, use the Save As command to save it with a new name.


Notify button (File, Open, File Reservation db)
To be notified when a workbook that another user currently has open becomes available, click Notify.


Arrow button (Drawing toolbar)

Creates a line with an arrowhead.


Create Button button (Drawing toolbar)

Places a button on your worksheet that you can use to run a macro. When you create the button, the Assign Macro dialog box appears so you can assign an existing macro to the button or record a new macro.


Drawing Selection button (Drawing toolbar)

Changes the pointer to an arrow for selecting graphic objects. You can use the drawing selection pointer to click an object to select it or to drag a selection rectangle around multiple objects to select them. The drawing selection pointer remains active until you double-click a cell.


Drop Shadow button (Drawing toolbar)

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


Shape button

Displays a toolbar of the drawing buttons you use to draw shapes on worksheets or charts. To keep the drawing tools displayed, click the down arrow and drag the tools to create a separate toolbar.


Freehand button (Drawing toolbar)

Lets you create freehand drawings.


Polygon button

Lets you create freeform drawings, which can be a combination of freehand shapes and straight lines.


Reshape button (Drawing toolbar)

Displays the vertexes so you can change the shape of a freeform drawing.


Selection button

Changes the pointer to a cross hair so you can drag a selection rectangle around multiple objects to select them.


Text Box button (Drawing toolbar)

Lets you draw a text box so you can add text to a graphic object, such as a chart or picture.


Bring To Front button (Drawing toolbar)

Places the selected object in front of other overlapping objects.


Send To Back button (Drawing toolbar)

Places the selected object behind other overlapping objects.


Group Objects button (Drawing toolbar)

Assembles the selected graphic objects into a single object so they can be moved or changed as a group.


Ungroup Objects button (Drawing toolbar)

Separates a grouped object into individual objects so they can be moved or changed individually.


Pattern button (Drawing toolbar)

Applies the default pattern to the selected graphic object. To change the fill pattern or color, click the down arrow and then click a fill pattern and color.


Freeform button (Drawing toolbar)

Lets you draw a freeform drawing object in your spreadsheet.


Shows how your document will look with the selected options.


To change the current style, click Modify.


Increase Font Size button (Formatting toolbar)

Increases the font size of the selected text to the next larger size in the Font Size box.


Decrease Font Size button (Formatting toolbar)

Decreases the font size of the selected text to the next smaller size in the Font Size box.


To change the appearance of the selected arrow, select from the options under Arrowhead.


Font box (Formatting toolbar)

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


Font Size box (Formatting toolbar)

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


Bold button (Formatting toolbar)

Formats the selected text and numbers as bold. If you click the button again, the formatting is removed.


Italic button (Formatting toolbar)

Formats the selected text and numbers as italic. If you click the button again, the formatting is removed.


Underline button (Formatting toolbar)

Underlines the selected text and numbers. If you click the button again, the formatting is removed.


To change the font of the selected text, select a font name. To change the appearance of the selected text, select the options you want on the Font tab.


To apply special formatting effects, select any combination of check boxes under Effects.


To change the font style of the selected text, select a style in the Font Style box.


To change the size of the selected text, select a size in the Size box. The sizes available depend on the printer and the selected font.


To stop automatically correcting spelling and replacing text as you type, clear the Replace Text As You Type check box.


AutoCorrect command (Tools menu)

Corrects text automatically as you type. You can also use the AutoCorrect feature to store and reuse text and other items you use frequently.


To add or replace the AutoCorrect entry displayed in the Replace and With boxes, click Add.


To add an entry to the list of words and phrases that AutoCorrect won't correct automatically, click Add.


To make sure that the first letter of the days of the week is capitalized automatically, select the Capitalize Names Of Days check box.


To always change two consecutive uppercase letters in a word so that the second uppercase letter becomes a lowercase letter, select the Correct Two Initial Capitals check box.


To delete the AutoCorrect entry displayed in the Replace and With boxes, click Delete.


Enter the name of the AutoCorrect entry (the abbreviation or word that you want to replace automatically as you type).


Displays the text or graphics that you want to use as a replacement for the word or abbreviation in the Replace box.


Cut command (Edit menu)

Removes the selection from the active document and places it on the Clipboard.


Copy command (Edit menu)

Copies the selection onto the Clipboard.


Paste command (Edit menu)

Inserts the contents of the Clipboard at the insertion point, replacing any selection.


To format the selected text with an underline, select an underline type.


To change the color of the selected text or object, select a color from the list.


To format a table automatically, select an autoformat in the Table Format box. To remove an autoformat, click None.


To specify which aspects of the autoformat you want to apply, click Options.


To format the selected text or numbers as subscript, select the Subscript check box.


To draw a line through selected text or numbers, select the Strikethrough check box.


To format the selected text or numbers as superscript, select the Superscript check box.


Left Border button

Adds a border along the left edge of the selection. If you click the button again, the border is removed.


Right Border button

Adds a border along the right edge of the selection. If you click the button again, the border is removed.


Top Border button

Adds or removes a border along the upper edge of the selection.


Bottom Border button

Adds or removes a border along the lower edge of the selection.


Style box (Formatting toolbar)

Applies a style to the selection, or defines a style based on the selection. To apply an existing style, select the style in the Style box. To define a new style based on the selection, type a new name in the Style box and press ENTER.


Double Underline button (Text Formatting category)

Formats the selected text with a double underline. If you click the button again, the formatting is removed.


Strikethrough button (Text Formatting category)

Formats the selected text with a strikethrough line. If you click the button again, the formatting is removed.


Justify button (Formatting toolbar)

Aligns the contents of the selection to the left and right. If you click the button again, the justification is removed.


Style command (Format menu)

Defines or applies to the selection a combination of formats, called a style.


To delete the current style, click Delete.


To add shading to the selection, select from the options under Fill.


To remove shading from the selection, click None.


Add/Edit Routing Slip command (File menu)

Sends a document to reviewers to revise and add annotations. To use routing, you and those you are sending the document to must have installed both the application in which the document was created and Microsoft Exchange or a compatible mail package.

When you have an existing routing slip or a message has been sent to you with a routing slip, the command name changes to Edit Routing Slip.


Displays the name of the person routing the document.


To enter the names of the people you want to route a document to, click Address, click a recipient name, and then click Add.


To route a document to one recipient after another, click the Move arrows until the names in the To box appear in the correct routing order.

If a routed document has already been sent to a name on the list, the name is dimmed and cannot be moved.


To find and select the recipient names you want to route the document to, click Address.


To remove a recipient from the To box, click the recipient's name, and then click Remove.


To describe the contents of the routed document, type a title in the Subject box.


To send a message or instructions about the routed document, type the message in the Message Text box.


To specify whether you want to send a copy of a document to all recipients at the same time or to one after another, select the option you want.


To let each reviewer of a routed document see the comments of all previous reviewers, click One After Another. The document is routed to recipients in the order specified in the To box.


To send a copy of a routed document to all reviewers at the same time, click All At Once.


To send a routed document back to you after the last recipient closes it, select the Return When Done check box.


To send an electronic mail message to yourself when each recipient forwards a routed document, select the Track Status check box.


To add a routing slip to the open document, click Add Slip.


To send a document after you have created the routing slip, click Route.


To clear the list of recipients and message text from the routing slip, click Clear.

To remove the routing slip from the document, click Clear, and then click Add Slip.

When a document is returned after routing, or reaches the last recipient, the list of recipients is dimmed.


Send command (File menu)

Sends a mail message with an attached document.


To specify whether you want to route the document to the recipients specified on the routing slip, or to mail the document independent of the routing slip, click the option you want.


Toolbars command (View menu)

Displays or hides selected toolbars, creates new toolbars, resets toolbars to their original settings, sets the color scheme for toolbars, and changes toolbar button size.


To add a button to a toolbar or change toolbar buttons and toolbars, click Customize.


To enlarge toolbar buttons so that they are easier to see, select the Large Buttons check box.


To display on-screen descriptions of toolbar buttons when the pointer pauses on them, select the Show ToolTips check box.


To restore the selected built-in toolbar to its original settings, click Reset. When you select a custom toolbar in the Toolbars box, the Reset button changes to Delete.


Copy Button Image command (Edit menu)

Copies the button image so that you can paste the image onto another button.


 Reset Button Image command (toolbar button shortcut menu)

Restores the button image to its built-in image.


Paste Button Image command (Edit menu)

Pastes the button image onto the selected button.


 Changes the color and image on a toolbar button.


To edit the button image, click the pixels in the Picture box.


To draw with a specific color, click the color in the Colors box, and then drag across the pixels whose color you want to change in the Picture box.


To remove the color from pixels in the button image, click the Erase box, and then drag across the pixels whose color you want to remove in the Picture box.


To move the button image up, down, left, or right one column or row at a time in the Picture box, click a direction button under Move.


Displays the button image as it will appear on the toolbar.


To clear the button image and display only the background color, click Clear.


To display colored buttons on toolbars, select the Color Buttons check box (Microsoft Word) or the Color Toolbars check box (Microsoft Excel). If you are using a black-and-white monitor and want to display the buttons with more contrast, clear this check box.


Full Screen command (View menu)

Hides most screen elements so that you can view more of your document.

To switch to your previous view, click  [image].


Zoom Control box (Standard toolbar)

Controls how large or small a document appears on the screen.


Full Screen button (Full Screen toolbar)

Cancels full screen view and returns hidden toolbars and other screen elements to the screen.


To display the horizontal scroll bar or the vertical scroll bar, select either the Horizontal Scroll Bar or Vertical Scroll Bar check box.


Split command or Remove Split command (Window menu)

Splits the active window into panes, or removes the split from the active window.


Application Control menu

To control the size and position of an application window, click the application Control-menu icon in the upper-left corner of the application window — or press ALT+SPACEBAR — and then click the command you want.


Document Control menu

To control the size and position of a document window, click the document Control-menu icon in the upper-left corner of the document window — or press ALT+HYPHEN — and then click the command you want.


Print Preview button (Standard toolbar)

Displays each page as it will look when printed.


Print command (File menu)

Displays printing options and prints all or part of the document.


Print button (Standard toolbar)

Prints one copy of the active document using the current print settings.


To return to the previous view of the document, click Close.


To specify the number of copies to print, enter a number in the Number Of Copies box.


To select a printer, click its name in the Name box. The information that appears below the Name box applies to the selected printer.


To print the entire document, click All.


To print your document to a file instead of to a printer, select the Print To File check box.


To organize pages when you print multiple copies of a document, select the Collate check box. A complete copy of the document is printed before the first page of the next copy is printed.


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


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


Close command (File menu)

Closes the active document without quitting the application. To close all open documents, hold down SHIFT and click Close All on the File menu.


 Save command (File menu)

Saves the active document with its current filename, location, and file format.


Save As command (File menu)

Saves the active document with the filename, location, and file format you specify. You can also use this command to save a document with a password or to protect a document so that others cannot change its contents.


To save a backup copy each time you save the document, select the Always Create Backup Copy check box.


To be reminded to enter document properties—such as title, subject, author, keywords, and comments—for each new document you save, select the Prompt For Document Properties check box (Word) or Prompt For File Properties check box (Microsoft Excel).


To restrict access to documents and protect documents from changes, use the options under File-Sharing.


To prevent others from opening a document, type a password in the Protection Password box.

A password is case-sensitive and can contain up to 15 characters, including letters, numerals, and symbols. If you lose your password, you cannot open your document.


To let others open a document as read-only, type a password in the Write Reservation Password box. If someone opens the document 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, numerals, and symbols. If you lose your password, you cannot open your document.


To recommend that others open a document as read-only, select the Read-Only Recommended check box. If someone opens the document as read-only and changes it, it must be saved with a different name.


To confirm the password, retype it in the Reenter Protection Password box.


To confirm the password, retype it in the Reenter Write Reservation Password box.


Help is available for each item in this group. Click  [image] at the top of the dialog box, and then click the specific item you want information about.


Help is available for each button on this toolbar. Click  [image], and then click the specific button you want information about.


To get help with options in this dialog box, click Help.


Post To Exchange Folder command (File menu)

Saves a copy of the active file to a Microsoft Exchange folder.


Exit command (File menu)

Exits the application.


Displays the selected toolbar.


Picture command (Insert menu)

Inserts a picture from a graphics file.


Toolbar

Contains buttons that give you quick access to many commands and features. To see the name of a button, point to it with the mouse. To display or hide toolbars, use the Toolbars command on the View menu. To make an anchored toolbar a floating toolbar, or vice versa, double-click a blank area on the toolbar.


Title bar

To move a window or dialog box, drag its title bar. To maximize a window or restore it to its previous size and location, double-click the title bar.


Minimize

To reduce an application or document window to an icon, click  [image]  in the upper-right corner of the window, or click Minimize on the application or document Control menu. To restore the window to its previous size and location, double-click the icon.


Maximize

To enlarge an application or document window to fill the screen, click  [image]  in the upper-right corner of the window, or click Maximize on the application or document Control menu. To restore the window to its previous size and location, double-click the title bar.


Restore

To restore a window to its previous size and location, click  [image]  in the upper-right corner of the window, or click Restore on the application or document Control menu.


Close

To close an application or document, click  [image]  in the upper-right corner of the window, or click Close on the application or document Control menu.


docked toolbar

A toolbar that's attached, or "anchored," to one edge of the screen or the application window. You can dock a toolbar below the menu bar or to the left, right, or bottom edge of the application window. When you drag a toolbar to the edge of the screen or the application window, the toolbar outline "snaps" to the length of the edge. If you drop the toolbar after its outline "snaps," it docks to that edge of the screen.


floating toolbar

A toolbar that's not docked at the edges of the application window.


Format Painter button (Standard toolbar)

Copies the formatting (such as font and color) of selected text or a selected object and applies it to other text or another object.


Open button (Standard toolbar)

Opens or finds a document.


Open command (File menu)

Opens or finds a document.


File List command (File menu)

Opens the document. Click the number or name that corresponds to the document you want to open.


Move command (Control menu)

To use the arrow keys on the keyboard to change the location of the application or document window, click Move.


object

A file or information (textual or graphical) you can link to or embed in another application.


The Microsoft Network command (Help menu)

This command is unavailable if The Microsoft Network is not installed on your computer. For information about installing The Microsoft Network, click the Windows Start button, click Help, and then enter microsoft network.


The Microsoft Network command (Help menu)

Connects your computer to The Microsoft Network location you select.


About Microsoft Application command (Help Menu)

Displays the version number of this Microsoft application; copyright, legal, and licensing notices; the user and organization name; the software serial number; and information about your computer and your operating system.


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


Microsoft Application Help Topics command (Help Menu)

Displays online Help for this Microsoft application, including the Answer Wizard, where you can type a request for help in your own words.


Answer Wizard command (Help menu)

Displays the Answer Wizard, where you can type a request for help in your own words.


Save button (Standard toolbar)

Saves the active document with its current filename, location, and file format.


Properties command (File menu)

Displays the properties of the active file.


You have chosen an item that's associated with previous versions of this product. There are no Help topics available for this item. For assistance, try using the commands on the product's Help menu.


For more information about technical support options, click the Tech Support button.


To open the document as read-only, click Read Only. If you open the document as read-only and change it, you must save the document with a different name.


Copy button (Standard toolbar)

Copies the selection onto the Clipboard.


Cut button (Standard toolbar)

Removes the selection from the active document and places it on the Clipboard.


Paste button (Standard toolbar)

Inserts the contents of the Clipboard at the insertion point, replacing any selection.


OLE application

An application that supports object linking and embedding. Use linking if you want to automatically update the linked information in the destination file when the source file changes. Use embedding to insert an object into another application. All Microsoft Office applications support OLE.


selection

All items that are currently selected. Selected items are usually highlighted on your screen and are changed by the commands and actions you perform.


Drawing button (Standard toolbar)

To display or hide the Drawing toolbar, click the Drawing button.


To make a window the active window, double-click its name.


Displays the type of object — for example, Microsoft Excel worksheet — that you are converting or activating.


To convert the selected embedded object to the application format or type of information selected in the Object Type box, select the Convert To check box. Use this option to change the file format of the embedded object so that you can open it in the applications you use.


To open the embedded object as the type selected in the Object Type box, select the Activate As check box. After you edit the object, it returns to the current type.


To convert the selected object to another object type, click an application or object type in the Object Type box. The embedded object opens for editing in the source application for the object type you've selected.


Displays the results of selected options.


To display the selected embedded object as an icon, select the Display As Icon check box.


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


Edit command (Edit menu, Object submenu)

Opens the selected embedded object or the source file of linked information so that you can edit the object or information in the source application.


Open command (Edit menu, Object submenu)

Opens the selected embedded object or the source file of linked information so that you can edit the object or information in the source application.


Convert command (Edit menu, Object submenu)

Specifies a different source application for the selected object so that you can open and edit the object in an application other than the original source application.


Paste Special command (Edit menu)

Pastes, links, or embeds the Clipboard contents into the current file in a format you specify.


To insert or embed the Clipboard contents at the insertion point in the format specified in the As box, select the Paste check box. When you select this option, the Clipboard contents are pasted or embedded, but no link is created.

To create a link, select the Paste Link check box.


To specify the type of information you want to paste from the Clipboard, click the type in the As box.


To display the Clipboard contents as an icon, select the Display As Icon check box. Use this option if you do not want data to be displayed in your file.


To change the icon that represents a link, click Change Icon, and then select the options you want in the Change Icon dialog box.


Displays the results of selected options.


Links command (Edit menu)

Displays and modifies information for each link in the current file, including the filename, the item, the type, and whether the link is updated automatically or manually. This command is unavailable if the current file contains no links.


Lists the names and locations of the source files.


Displays the range name of the linked item.


Displays the name of the application or type of application in which the linked object was created.


To update data for the selected link when you open the container file, and every time the source file changes, select Automatic. This option is unavailable if the link is locked.


To update data for the selected link only when you click Update Now, select Manual. This option is unavailable if the link is locked.


To update all of the links selected in the Links dialog box, click Update Now.


To 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.


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


To open the selected source document in the source application, click Open Source.


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."


Object name Object command (Edit menu)

Displays commands that apply to the selected object.


Object command (Insert menu)

Links or embeds an object — such as a chart or an equation — in the current file.


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 Office Setup to install the source application.


To display the new embedded object as an icon, select the Display As Icon check box.


Describes the results of the selected options.


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


Type the name of the file you want to insert as a linked or embedded object.


To locate the file you want to link or embed, click Browse, and then select the options you want.


To create a link to the selected file rather than embedding it, select the Link To File check box.


To display the embedded object as an icon, select the Display As Icon check box.


To search for files in other locations, click Browse, and then select the options you want.


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


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


Type the caption — such as the filename — you want to appear under the embedded object icon in your file.


To locate files that contain icons you want to use to represent embedded objects, click Browse.


Displays the name of the file that contains the icons that appear in the Icon box.


dynamic data exchange (DDE)

The ability of Windows-based applications to exchange information and commands. For example, a Microsoft Excel macro uses DDE to send commands to Word to print a document.


embedded chart

A chart object that's been placed on a worksheet and is saved with that worksheet when the workbook is saved. When the object is selected, you can move and size it. When it's activated, you can add data and select, format, move, and size most items. Embedded charts are linked to worksheet data and are updated when the worksheet data changes.


chart sheet

A sheet in a workbook containing a chart. When you create a chart sheet, Microsoft Excel inserts it in the workbook to the left of the worksheet it's based on. When a chart sheet is activated, you can add data and select, format, move, and size most items. Chart sheets are linked to worksheet data and are updated when the worksheet data changes.


Open Database Connectivity (ODBC)

A Driver Manager and a set of ODBC drivers that enable applications to use Structured Query Language (SQL) as a standard language to access data created and stored in another format.


data source

Information stored in another application.


merge field

A placeholder for the actual information that changes for each version of a document.


main document

In a mail merge operation, the main document contains the text and graphics that stay the same for each version of the merged document — for example, a form letter.


source file

The file in which an object originated, or the application that was used to create the object. When you change information in a source file, the information is updated in the file to which it's linked.


OLE

Acronym for object linking and embedding. OLE is an application-integration technology you can use to share information among applications. All of the Office applications support OLE, so you can link and embed information in any of these applications.


link

To copy information from one file (the source file) to another file (the destination file) and maintain a connection between the two files. When you change the information in the source file, the information is automatically updated in the destination file.


embed

To insert information created in one file (the source file) into another file (the container file). After it's been embedded, the information — called an object — becomes part of the container file. When you double-click an embedded object, it opens in the application in which it was created. Any changes you make to the object are reflected in the container file but not in the source file.


embedded object

Information such as a chart or document that's created in one file (the source file) and inserted into another file (the container file). Both the source and container applications must support object linking and embedding, or OLE. After it's been embedded, the object becomes part of the container file.

When you double-click an embedded object, it opens in the application in which it was created. Any changes you make to the object are reflected in the container file but not in the source file.


import

To bring information stored in one file format or application into another one. The Office applications use converters to import information.


container file

A file that contains a linked or embedded object. Also called a compound document.


bound object frame

In Microsoft Access, a control on a form or report used to display and manipulate OLE objects that are stored in tables.


unbound object frame

In Microsoft Access, a control you place on a form or in a report to contain an unbound object. An unbound object is an object (such as a picture) whose value isn't derived from data stored in a table.


To close this dialog box without saving any changes you've made, click Cancel.


To close this dialog box and save any changes you've made, click OK.


Microsoft Software Library

The Microsoft Software Library (MSL) is a collection of binary (nontext) files for all Microsoft products. For example, the MSL contains device drivers, utilities, Help files, and technical articles.


The Microsoft Network

The Microsoft Network (MSN) is an online service that provides easy and affordable access to a worldwide community of computer users. Access to MSN is a feature of Windows 95 — MSN is seamlessly integrated with the operating system. Using MSN, you can exchange messages with people around the world; read the latest news, sports, weather, and financial information; find answers to your technical questions; download from a collection of thousands of programs; connect to the Internet; and more.


Microsoft Download Service

The Microsoft Download Service (MSDL) is a standard bulletin board system. It contains the Microsoft Software Library (MSL), technical articles, device drivers, Help files, and other support files you can download from Microsoft.


auto hide

A mode that causes the docked Office Shortcut Bar to remain off the edge of the screen when you're not using it. A small border appears on the edge of the screen where the Office Shortcut Bar is hidden; when you point to that edge of the screen, the Office Shortcut Bar reappears. The Auto Hide Between Uses check box has no effect when the Office Shortcut Bar is minimized or floating, or when the Auto Fit Into Title Bar Area check box is selected and the Office Shortcut Bar is docked at the top of the screen.


Application Note

A technical article, written and distributed by Microsoft, that provides additional information about a Microsoft product or a fix for a specific bug or problem. An Application Note may include a disk that contains new software, documentation, sample files, device drivers, utilities, templates, or macros.


query

One or more phrases that tell the Knowledge Base what to search for. Queries can contain operators, quotation marks, wildcards, and parentheses to help focus the search.


Microsoft Knowledge Base

The Microsoft Knowledge Base (KB) is the primary source of product information for Microsoft support engineers and customers. This comprehensive collection of articles, which is updated daily, contains detailed how-to information, answers to technical-support questions, bug lists, and fix lists. Use text and keyword queries to access information in the KB.