When you type data into an Excel cell, you must finalize the entry for it to be saved. The Enter key is the most common method, but it moves the selection to the next cell. The Formula Bar provides dedicated Cancel and Enter buttons that keep your cell selection in place. This article explains the function of the X and check mark icons in the Formula Bar. You will learn how to use these buttons to confirm or discard edits without changing your active cell.
Key Takeaways: Using the Formula Bar Buttons
- Formula Bar check mark (Enter): Confirms the cell entry and keeps the same cell selected for further editing.
- Formula Bar X (Cancel): Discards any changes made in the active cell and restores its previous value or formula.
- Keyboard Shortcut Esc: Performs the same cancel action as the X button, providing a faster alternative.
Understanding the Formula Bar Entry Controls
The Formula Bar is the editing area above the worksheet grid that displays the content of the active cell. When you click into a cell or the Formula Bar itself to edit, two buttons appear to the left of the formula text box: a red X and a green check mark. These are the Cancel and Enter buttons, respectively. Their primary purpose is to give you precise control over finalizing data entry without altering your navigation flow. Unlike pressing the Enter key on your keyboard, which confirms the entry and typically moves the selection down one cell, clicking the check mark confirms the entry while the active cell remains selected. This is useful for reviewing a formula result or making multiple adjustments to the same cell.
Steps to Use the Formula Bar Buttons
Follow these steps to confirm or cancel a cell entry using the buttons in the Formula Bar.
- Select and edit a cell
Click on any cell in your worksheet. Begin typing new text, a number, or a formula. You can also click directly inside the Formula Bar to edit the cell’s existing content. - Observe the Formula Bar buttons
Look to the left of the text box in the Formula Bar. The red X (Cancel) and green check mark (Enter) buttons will be active and visible once you start editing. - To confirm your entry
Click the green check mark button. This saves the new content into the cell. The cell will remain selected and active, allowing you to immediately format it or edit it again. - To cancel your entry
Click the red X button. This action discards all changes you made during the current edit. The cell’s content reverts to what it was before you started typing, and the cell stays selected.
Using Keyboard Shortcuts as Alternatives
- Press Enter on the keyboard
Pressing the Enter key confirms the cell entry. By default, this also moves the active cell selection down. You can change this behavior in File > Options > Advanced under “Editing options” by toggling “After pressing Enter, move selection.” - Press Escape on the keyboard
Pressing the Esc key performs the same function as clicking the red X button. It cancels the edit and restores the cell’s original value without moving the selection.
Common Mistakes and Limitations
Buttons Disappear After Confirming Entry
The X and check mark buttons are only visible when a cell is in edit mode. Once you confirm an entry by clicking the check mark or pressing Enter, the buttons disappear. They reappear as soon as you double-click the cell or press F2 to edit again. This is normal behavior and not a sign of a problem.
Cancel Button Does Not Undo Saved Changes
The red X button only cancels edits made during the current, active editing session. It cannot undo a previously confirmed and saved change to a cell. To revert a saved change, you must use the Undo command (Ctrl+Z) or manually re-enter the old data.
Formula Bar is Missing or Hidden
If the entire Formula Bar is not visible, the buttons will not be available. To show it, go to the View tab on the Ribbon. In the Show group, ensure the checkbox for “Formula Bar” is selected. If it is unchecked, click to enable it.
Formula Bar Buttons vs Keyboard Shortcuts
| Item | Formula Bar Buttons (X / Check) | Keyboard Shortcuts (Esc / Enter) |
|---|---|---|
| Primary Action | Cancel or confirm entry | Cancel or confirm entry |
| Cell Selection After Action | Active cell remains selected | Enter moves selection; Esc keeps cell selected |
| Best For | Mouse-driven editing, reviewing formulas | Fast data entry, keyboard-only workflows |
| Visibility | Requires Formula Bar to be enabled in View tab | Always available |
| Reversion Scope | Only current edit session | Only current edit session |
You can now use the Formula Bar buttons to finalize cell edits without changing your selected cell. This is particularly helpful when auditing complex formulas. For more precise control, try using the F2 key to enter edit mode directly in the cell. Remember that the Esc key is a universal shortcut to cancel any edit in progress across all Office applications.