Advanced options

Editing options

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

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

Automatically insert a decimal point     Select this check box to display a number with decimal points by default.

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

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

  • Alert before overwriting cells     Displays a message if you drop cells over other cells that contain data.

Allow editing directly in cells     Select this check box to enable editing inside a cell by double-clicking the cell, rather than by editing the cell contents in the formula bar.

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

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

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

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

Alert the user when a potentially time consuming operation occurs     Select if you want to be notified when an operation affects a large number of cells and may take a long time to process.

  • When this number of cells (in thousands) is affected     Lets you specify the maximum number of cells that are affected by an operation without being notified. If more cells than the maximum number of cells are affected, you are notified.

  • Use system separators     Select to use the default Decimal and Thousands separators. Clear to enter alternate separators.

    • Decimal separator     To change the default decimal separator, clear Use system separators, select the default separator in the Decimal separator box, and then type the separator that you want to use.

    • Thousands separator     To change the default thousands separator, clear Use system separators, select the default separator in the Thousands separator box, and then type the separator that you want to use.

Cut, Copy, and Paste

Show Paste Options buttons     Select to have Excel automatically display a dialog box with special options when you paste, such as Formatting Only and Link Cells.

Show Insert Options buttons     Select to have Excel automatically display a dialog box with special options when you insert cells, rows or columns, such as Formatting Same As Above and Clear Formatting.

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

Display

Show this number of Recent Documents     Displays a list of recently used workbooks under Recent Documents when you click the Microsoft Office Button Office button image , so that you can open those workbooks quickly. Enter the number of workbooks that you want to display in the Show this number of Recent Documents box. Enter or select a positive number between 0 and 50.

Ruler units     Lets you select the units that you want to display on the Layout view ruler.

Show all windows in the Taskbar      Select to display multiple workbooks on the Windows taskbar.

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

Show function ScreenTips     Displays brief descriptions of the functions that you select in the list of functions that is displayed when Formula AutoComplete is turned on.

Show chart element names on hover     Displays the name of a chart element when you rest the pointer over it.

Show data point values on hover     Displays the value of a data point when you rest the pointer over it.

For cells with comments, show     Select one of the following options to determine how comments are displayed on the worksheet.

  • No comments or indicators     Hides comments and comment indicators in cells that have comments attached.

  • Indicators only, and comments on hover     Displays a small triangle in the upper-right corner of a cell when there is a comment attached to the cell. Comments are displayed only when you rest a pointer over a cell that has a comment.

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

Display options for this workbook

Display options for this workbook     Select the workbook in this list box that is affected by the following options.

Show horizontal scroll bar     Displays the horizontal scroll bar at the bottom of the worksheet.

Show vertical scroll bar     Displays the vertical scroll bar on the right side of the worksheet (when you are using left-to-right language mode) or on the left side (when you are using right-to-left language mode).

Show sheet tabs     Displays worksheet tabs so that you can move among and select individual worksheets. Worksheet tabs appear at the bottom of the worksheet window.

Group dates in the AutoFilter menu     Changes the hierarchical grouping of dates to a nonhierarchical list of dates in the list of dates at the bottom of the AutoFilter menu in a date filter. For example, you can filter for just two-digit years by manually selecting two-digit years from a nonhierarchical list.

For objects, show     Select one of the following options to display or hide graphic objects in the workbook.

  • All     Displays all of the graphic objects, buttons, text boxes, drawn objects, and pictures.

  • Nothing (hide objects)     Hides all of the graphic objects, buttons, text boxes, drawn objects, and pictures. Hidden objects are not printed.

Display options for this worksheet

Display options for this worksheet    Select the worksheet in this list box that is affected by the following options.

Show row and column headers     Displays row numbers on the left side (when you are using left-to-right language mode) or on the right side (when you are using right-to-left language mode) of the worksheet and column letters at the top of the worksheet.

Show formulas in cells instead of their calculated results     Displays the formulas in cells instead of the values that the formulas produce.

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

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

Show outline symbols if an outline is applied     Displays outline symbols. Outline symbols are not displayed unless the worksheet contains an outline.

Show gridlines     Displays cell gridlines. To print gridlines, make sure that the Print check box is selected under Gridlines in the Sheet Options group on the Page Layout tab.

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

Formulas

Enable multi-threaded calculation     Selected by default, this option enables fast calculation by using all of the processors on your computer, or by using the number of processors that you type manually.

Number of calculation threads     Lets you specify the number of processors that are used for calculation.

  • Use all processors on this computer     Selected by default, this option uses all of the processors that are available on your computer.

  • Manual     Lets you specify the number of processors that you want to use. In the Manual box, enter a positive number between 1 and 1024.

When calculating this workbook

When calculating this workbook    Select the workbook in this list box that is affected by the following options.

Update links to other documents     Calculates and updates formulas that include references to other applications.

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

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

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

General

Provide feedback with sound     Plays available sounds that are associated with Microsoft Office program events, such as opening, saving, and printing files, and displaying error messages. Sounds that are assigned to different events can be changed in Control Panel. In Microsoft Windows, click the Start button, and then click Control Panel. In Windows Vista, click Hardware and Sound, and then click Sound. Click the Sounds tab. To change the sound that is associated with an event, click the program event in the list and select a sound to apply. In Windows XP, click Sounds, Speech, and Audio Devices. Click Change the sound scheme and then click the Sounds tab. If you select or clear the Provide feedback with sound check box in one Office program, it is also turned on or off for all other Office programs. Your computer must have a sound card to play most sounds.

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

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

Ask to update automatic links     Displays a message that lets you confirm before linked items are updated.

Show add-in user interface errors     Displays errors in the user-interface of add-ins that you install and use.

Scale content for A4 or 8.5 x 11" paper sizes     For some countries or regions, the standard paper size is Letter; for others, the standard size is A4. Select this check box if you want Excel to automatically adjust documents formatted for the standard paper size of another country or region (for example, A4) so that they print correctly on the standard paper size for your country or region (for example, Letter). This option affects the printout only. It does not affect the formatting in your document.

At startup, open all files in     At startup, Excel automatically opens files from the folder that you type in this text box. Type the full path to the folder in the text box to indicate the location of the files.

Web Options      Sets options for how Excel data looks and responds when the data is viewed in a Web browser.

Service Options     Lets you specify customer feedback and document management options.

Lotus Compatibility

Microsoft Office Excel menu key     Sets the key that you can use to access the commands on the Ribbon, which is a component of the Microsoft Office Fluent user interface.

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

Lotus Compatibility Settings for

Lotus Compatibility Settings for     Select the worksheet in this list box that is affected by the following options.

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

Transition formula entry     Converts formulas that are entered in Lotus 1-2-3 release 2.2 syntax to Excel syntax, and makes names that are defined in Excel behave like names that are defined in Lotus 1-2-3.

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×