Editing Options

After pressing Enter, move selection - After entering a value or formula into a cell, pressing Enter will change the active cell to an adjacent cell. Which cell this is depends on the direction chosen in the Direction drop-down list below. The default is ticked.
Direction - Controls which cell will become the active cell after you press Enter. The drop-down contains the values: Down, Up, Right and Left. The default is Down.
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 always having to edit the cell contents in the formula bar. The default is ticked.
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 - (Added in 2013). Uses an algorithm for recognising patterns in your data and automatically predicts and can fill in the remaining cells for you. For more information refer to the Flash Fill page.
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.
Cursor movement -
Logical - The insertion point movement will move in the logical order of bidirectional text.
Visual - The insertion point movement will ignore the text language and move continuously to the right or left.
Do not automatically hyperlink screenshot - (Added in 2013). Prevents automatic hyperlinks being added when you use the (Insert Tab, Illustrations, screenshot).