In Excel for Windows, find Advanced Options by selecting File>Options>Advanced.
Editing options
After pressing Enter, move selection Makes an adjacent cell the 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.
- Automatically Flash Fill When Excel detects a pattern, it will show a preview and you can choose to use the predicted text. Check this option to avoid pressing Enter to use Flash Fill.
Zoom on roll with IntelliMouse If you have the Microsoft IntelliMouse pointing device, set 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) 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.
Cursor movement Choose between two modes (for use with mixed bidirectional text):
Do not automatically hyperlink screenshot Prevents Excel from automatically adding a hyperlink to screenshots (for example, linking to the source web page).
Cut, Copy, and Paste
Show Paste Options buttons when content is pasted 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.
Warn if external clipboard operation fails Select to receive a warning if Excel encounters a clipboard error.
File open preferences
Open Word, Excel, and PowerPoint files using Desktop or Browser. For more information, see Open file links directly in Microsoft 365 desktop apps from Teams and classic Outlook.
Pen
Use pen to select and interact with content by default Use a digital pen or stylus to interact with Excel.
Enable the draw and hold ink-to-shape gesture while inking Enable ink to shape. Learn how to convert your ink to shapes and math equations.
Image size and quality
Discard editing data This option deletes data used to restore images to their original state after they've been edited. Note that if you discard the editing data, you won't be able to restore the image.
Do not compress images in file Checking this option provides maximum image quality but may result in very large file sizes. If this option is unchecked, pictures will be downsized to the number of pixels per inch specified below when they are saved.
Default resolution Using a resolution other than high fidelity might reduce the number of pixels in your pictures. High fidelity resolution preserves picture quality but may increase the file size of your documents.
Print
High quality mode for graphics Checking this box tells Excel to render charts, shapes, and images at a higher fidelity when printing.
Include fonts that are stored on the printer
Chart
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.
Properties follow chart data point for all new workbooks Select this option to have formatting and data labels follow data points when they move or change, for all new workbooks you create.
Current workbook Choose an open workbook to use with the next setting (Properties follow chart data point for current workbook).
Properties follow chart data point for current workbook Select this option to have formatting and data labels follow data points when they move or change, for the workbook shown under the previous setting, Current workbook.
Display
Show this number of Recent Workbooks A list of recently used workbooks is displayed under Recent in the Backstage, allowing you to reopen those workbooks quickly. Enter the number of workbooks that you want to display in the Show this number of Recent Workbooks box. Enter or select a positive number between 0 and 50.
Quickly access this number of Recent Workbooks When checked, a list of files is displayed at the bottom of the File tab, under Options. Set the number of files to display by changing the number to the right.
Show this number of unpinned Recent Folders A list of recently accessed folders is displayed under Recent in the Backstage, allowing you to reopen those folders quickly. Enter the number of workbooks that you want to display in the Show this number of unpinned Recent Folders 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 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.
For cells with comments, show Select one of the following options to determine how notes and comments are displayed on the worksheet.
No comments or indicators If you have cells that contain notes or comments, this setting hides the small indicator in the upper-right corner of the cells.
Indicators only, and comments on hover If you have cells that contain notes or comments, this setting shows the small indicator in the upper-right corner of the cells. This setting also enables you to display notes or comments by hovering over cells.
Comments and indicators If you have cells that contain notes or comments, this setting shows the small indicator in the upper-right corner of the cells. If a cell contains a note, Excel will show keep the note shown. If a cell contains a comment, the comment stays hidden until you hover over the cell.
Default direction chooses the flow direction for the workbook canvas. You must reopen any existing workbooks for this change to take effect.
Right-to-left places cell A1 at the top right of the view, with sheet tabs aligned to the right side of the window. Cell-specific controls appear on the left side of cells.
Left-to-right places cell A1 at the top left of the view, with the sheet tabs aligned to the left side of the window. Cell-specific controls appear on the right side of cells.
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 select Automatic, the gridline color is based on the text color defined in Windows Control Panel.
Enable multi-threaded calculation Selected by default, this option enables fast calculation by using multiple processors. Please note that Excel only supports using up to 64 processor cores.
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.
Python in Excel
Automatically show Python Editor Show the Python editor whenever there are new entries.
Python Formula Timeout (in seconds) The maximum length of time allotted for a Python formula to execute. Once this timeout is reached, the formula may be asked to terminate early and return #TIMEOUT!
Default input size for images Controls the size of images used as data input for Python in Excel. The image will be scaled to the dimension chosen in the dropdown.
General
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.
Always open encrypted files in this app
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.
Enable multi-threaded processing Forces Excel to perform all calculations using a single thread, which can reduce CPU usage, but may slow calculations in large workbooks.
Create lists for use in sorts and fill sequences Excel provides day-of-the-week and month-of-the year built-in lists, but you can also create your own custom list. Select Edit Custom Lists to create or delete a custom list for sorting and filling data.
Lotus Compatibility
Microsoft Office Excel menu key Sets the key that you can use to access the commands on the Ribbon, 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.
Excel for Windows additional resources
Data import and analysis options in Excel
Customize the save experience in Office
Add an editing or authoring language or set language preferences in Office
Accessibility tools for Excel
Add commands to the Quick Access Toolbar
Office Options–The General tab
In Excel for Mac, find Options by selecting Excel>Preferences...
Below is a selected list of Excel Preferences that address advanced options in Excel for Mac. For guidance on general Excel Preferences, please see the list of additional resources toward the end of this article.
View
Show in Workbook
Formula bar Displays the formula bar in all workbooks. To set different viewing options for individual workbooks on the View menu, select Formula bar.
Sheet tabs appear at the bottom of the document window and display so you can move among and select sheets. Only affects the active workbook.
Row and Column headers Row numbers appear on the left of the sheet and column letters appear at the top. Only applies to the active sheets.
Outline symbols appear if the sheet contains an outline. Only affects the active sheets.
Gridlines around cells display if this box is checked. Choose a color from the dropdown menu. To print gridlines, make sure the Print Gridlines check box is checked on the Sheet tab of the Page Setup dialog box.
Preferred view for new sheets: Choose from Normal or Print views. Excel opens new sheets using the view you choose here.
Zero values Displays a 0 (zero) in cells that contain zero values.
Page breaks Displays page breaks that have been set automatically by Excel.
Formulas Displays the formulas in cells instead of the values that the formulas produce.
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.
Ruler unitsLets you select the units that you want to display on the Layout view ruler: Inches, centimeters, or millimeters.
- No comments or indicators If you have cells that contain notes or comments, this setting hides the small indicator in the upper-right corner of the cells.
-_Indicators only, and comments on hover If you have cells that contain notes or comments, this setting shows the small indicator in the upper-right corner of the cells. This setting also enables you to display notes or comments by hovering over cells.
- Comments and indicators If you have cells that contain notes or comments, this setting shows the small indicator in the upper-right corner of the cells. If a cell contains a note, Excel will show keep the note shown. If a cell contains a comment, the comment stays hidden until you hover over the cell.
For Cells with 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.
Placeholders Shows placeholders only.
Nothing (hide objects) Hides all of the graphic objects, buttons, text boxes, drawn objects, and pictures. Hidden objects are not printed.
In Ribbon, Show
Developer tab Shows tools for advanced customization that lets you create and run macros, work with XML data, and use other controls to build and automate solutions within workbooks.
Group Titles Check this box to display group titles in each Tab on the Ribbon. For example: Clipboard, Alignment, Number, etc.
Choose from the list of Commands to add, customize, or remove Tabs or Groups on the Ribbon. You must create a new custom Group to add Commands.
Customize an existing tab on the Ribbon
- Select the Tab you'd like to customize.
- Select New (+) and select new Group.
- Select Rename (...) to give it a custom name.
- Select a Command from the list and select Add (>) or Remove (<) to customize your new Group.
Create a new tab on the Ribbon
- Select New (+) and select new Tab.
- Select Rename (...) to give it a custom name.
- Add Groups and Commands using the instructions above.
Edit
Edit Options
Edit 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.
Allow 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.
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.
Automatically insert a decimal point Select this check box to display a number with decimal points by default.
After pressing Return, 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.
Suggest formula variations that are supported by older versions of Excel With the introduction of dynamic arrays, we upgraded Excel's formula language. As a result, you may enter formulas that are not supported in some older versions of Excel. This option will recommend an alternative formula.
Convert to data when scanning a document from iOS device With the insert data from picture feature, you can insert data from a screen clipping on your clipboard, an image file from your computer, or from your iPhone camera.
Provide feedback with animation Displays sheet movement and changes when you insert or delete cells, rows, or columns. Animation might slow video performance on some systems.
Ask to update automatic links Displays a message when you open a workbook that contains links to information in other locations, such as other Office documents. With this option enabled, you can confirm before linked items are updated.
Show Convert to Data Types when typing Show the Convert to Data Type options when typing terms in cells that potentially match a data types category. Convert to Data Types provides a quick way to convert to data types like stocks and geography.
Enable Click to Add Mode With Click to Add enabled, when editing a formula, just click cells to add them. Hold OPT (option) to temporarily disable this mode.
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 and Paste Options
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 related 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.
Tips: With a worksheet open, you can set which paste action will happen in the following cases:
Date Options
Preserve display of dates entered with four-digit years Changes the default date format from two-digit years to four-digit years. For example, if you type the date 5/28/1999, Excel displays 5/28/1999 instead of 5/28/99.
Automatically convert date system When you copy and paste between workbooks that use different date systems (1900 and 1904), converts the date system of the source data to match the date system of the target workbook.
Interpret as 21st Century for two-digit years before Indicates the earliest two-digit year that you want Excel to interpret as being in the twenty-first century. For example, if you enter 40, Excel interprets the years 00 through 39 as 2000 through 2039 and the years 40 through 99 as 1940 to 1999.
Pen
Use pen to select and interact with content by default Allow a digital pen or stylus to interact with Excel. Learn how to convert your ink to shapes and math equations.
Automatic Data Conversion
Enable all default data conversions below when entering, pasting, or loading text into Excel
Remove leading zeros and convert to a number Disable this option to store numerical data with leading zeros as text and retain the leading zeros instead of converting it to a number and losing the leading zeros. For example, 00123 remains as 00123 in text and isn't converted to the number 123.
Keep first 15 digits of long numbers and display in scientific notation Disable this option to store numerical data with 16 or more digits as text and retain all digits instead of only keeping the first 15 digits and converting it to a number that may be displayed in scientific notation. For example, 12345678901234567890 remains as 12345678901234567890 in text and isn't converted to the number 12345678901234500000 or displayed in scientific notation as 1.23457E+19.
Convert digits surrounding the letter "E" into a number in scientific notation Disable this option to store numerical data surrounding the letter "E" as text instead of converting it to a number in scientific notation. For example, 123E5 remains as 123E5 in text, and isn't converted to the number 1.23E+07 in scientific notation.
Convert continuous letters and numbers to a date Disable this option to store "date-like" values with consecutive letters and numbers as text, instead of converting to a date. For example, JAN1 remains as JAN1 in text and isn't converted to the date January 1. Data that includes spaces or other characters, such as JAN 1 or JAN-1 may still be treated as dates.
When loading a .csv file or similar file, notify me of any automatic data conversions When checked, Excel will display a warning message when it detects that an optional automatic data conversion is enabled and about to occur when opening a .csv or .txt file. This message gives you the opportunity to open the file once without converting the data. Disable this option to stop showing the warning.
AutoCorrect
Replace internet and network paths with hyperlinks Automatically formats text as a hyperlink when it matches the syntax of an internet or network path.
You can enable or disable various options for automatically correcting capitalization:
Capitalize names of days In languages that capitalize names of days, automatically capitalizes the first letter of the names when you enter them into a document.
Correct TWo INitial CApitals Clear this box to prevent AutoCorrect from correcting a specific word that contains mixed uppercase and lowercase letters (such as "IDs").
Capitalize first letter of sentences Clear this box to prevent AutoCorrect from capitalizing the first letter of any sentence.
Replace text as you type Clear this box to stop Excel from automatically replacing a matched word in the Replace list with the corresponding word in the With list. You can add multiple entries that point to the same "With" text. For example: "youve", "you'vr", and "you'ww" can all be replaced with "you've". Just add a separate entry for each of these changes.
To add a word to the exception list, type the word in the Replace box and then select Add. To delete a word, select the word and select Delete.
Chart
Show chart element names on hover Displays the name of a chart element when you rest the pointer over it. This setting affects all Office Applications.
Show data point values on hover Displays the value of a data marker when you rest the pointer over it. This setting affects all Office Applications.
Accessibility
Accessible Authoring helps you find and fix content in your workbook that may make it harder for people with disabilities to consume your content. Turn on this setting to keep Accessibility Assistant running even when the pane isn't open.
KeyTips provide a way to access controls in the Ribbon using the keyboard. Press and release the activation keystroke to show KeyTips, then navigate to and execute controls by typing the displayed characters. Choose an option to set the activation keystroke or to disable this feature.
Larger Control Surfaces This setting enlarges controls in certain cases to allow easier interaction when using assistive devices.
Copilot
Enable Copilot Select this option to use Copilot in Excel on this device. (Requires restart.)
Calculation
Calculation Options When automatic calculation is enabled, Excel recalculates the workbook automatically each time a value affecting a formula changes. If you turn off this feature, you must manually recalculate the workbook, such as by using the Calculate Now command.
Enable multi-threaded calculation Selected by default, this option enables fast calculation by using multiple processors. Please note that Excel only supports using up to 64 processor cores.
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.
Use iterative calculation limits iteration for goal seeking or for resolving circular references. Unless you specify otherwise, Excel stops after 100 iterations or when all values change by less that 0.001. You can limit iteration by changing the number in the Maximum iterations box, the Maximum change box, or both.
Use R1C1 reference style changes the way Excel formulas refer to cells. Instead of using letters for columns and numbers for rows (called A1 notation, because the first cell in the sheet is cell A1), Excel uses numbers for both rows and columns, so the first cell is R1C1.
When Calculating Workbooks
Set precision as displayed permanently changes stored values in cells from full precision (15 digits) to whatever precision (the number of decimal places) is displayed, including decimal places.
Use 1904 date system Changes the starting date from which all dates are calculated from January 1, 1900 (Windows date system), to January 2, 1904 (Mac date system). Only affects the active workbook.
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.
Automatically show Python Editor Show the Python editor whenever there are new entries.
Python Formula Timeout (in seconds) The maximum length of time allotted for a Python formula to execute. Once this timeout is reached, the formula may be asked to terminate early and return #TIMEOUT! Changing this setting will cause the workbook to recalculate.
Default input size for images Controls the size of images used as data input for Python in Excel. The image will be scaled to the dimension chosen in the dropdown.
Custom Lists
Custom Lists Excel provides day-of-the-week and month-of-the year built-in lists, but you can also create your own custom list. Select a list you want to edit or select NEW LIST in the Custom Lists box to create a new list, and then type the entries in the List Entries box. The first character cannot be a number. Press Return to separate each entry.
You can also select Import list from cells to import list entries from a data range on a sheet (for example, A1:B10), and then select Import. Each entry in the data range must be in a separate cell. The first character of an entry cannot be a number.
Learn more at create or delete a custom list for sorting and filling data.
AutoComplete
Use AutoComplete 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.
Show AutoComplete options for functions and named ranges Select this box to have Excel help you complete formulas that are typed into a cell. If the first entry s =, Excel displays all available functions and named ranges in a menu. If the next few letters you type match a function name or named range, Excel displays the matching items.
AutoComplete the closest match while I type If the letters you type into a formula closely match a function name or named range, Excel automatically enters it in the cell.
Show options after typing one or more letters Controls how many letters must be typed before the AutoComplete menu is displayed with matching items. If you specify zero letters the AutoComplete menu will appear after you type the equals sign (=).
Show and print formulas in Excel for Mac
Show scroll bars in Word or Excel
Copy a formula by dragging the fill handle in Excel for Mac
Customize how Excel starts in Excel for Mac
Change the file format for saving workbooks in Excel for Mac
File formats supported in Excel for Mac
Detect formula errors in Excel
Why do I get an "Unprotected Formula" message in Excel?
