After decades of using Excel, Ctrl+Enter is still one of the shortcuts I reach for most: on Windows desktop, it enters the same value or formula into every cell in a selected range in one action. Select the cells, type once in the active cell, and press Ctrl+Enter.
How to enter the same data into several cells at once
- Select the cells you want to fill. They can be next to each other or separated; Microsoft Support says, “The cells do not have to be adjacent.”
- Type the value or formula you want into the active cell.
- Press Ctrl+Enter. Excel fills the selected cells with that entry.
For example, select A2, A5, and A8, type Review, and press Ctrl+Enter. Each selected cell receives the same entry. This is handy when a label, status, or formula needs to appear in several chosen places without entering it cell by cell.
As an Amazon Associate I earn from qualifying purchases.
What does Ctrl+Enter do in Excel?
In Windows desktop Excel, Ctrl+Enter fills the selected cell range with the current entry. It is useful when you already know which cells should receive an identical value or formula. Microsoft’s manual data-entry guidance documents the multi-cell workflow and notes that the selection may be non-adjacent.
Recommended Free Tools
Formula entry is the same basic workflow: select the target cells, type the formula in the active cell, and press Ctrl+Enter. The documented behavior is that the current entry is filled into the selected cells; do not assume this shortcut adjusts relative references for you.
#1 Best Overall
- Over 215 Microsoft Windows Excel Shortcuts
- Two-Sided Durable Laminiated Sheet
- Designed for Excel on a Windows Computer
Which key combination should Mac and web users use?
Microsoft’s shortcut reference lists Cmd+Return or Ctrl+Return on Mac for filling the selected cell range with the text typed. Follow the combination documented for your setup rather than assuming the Windows keys apply.
Excel for the web runs in a browser, where browser shortcuts can affect the key combinations available. Microsoft cautions that web shortcuts can differ from desktop Excel, and its web guidance does not establish one universal multi-cell Ctrl+Enter workflow across browsers and operating systems. Check Microsoft’s current Excel keyboard-shortcut reference for your environment.
Ctrl+Enter can also keep the cursor in the active cell
The shortcut has another documented use: in a simple formula-entry example, Microsoft says Ctrl+Enter can leave the cursor in the active cell after the formula is entered. That is distinct from filling multiple selected cells. The result depends on the context: whether you have selected a range determines whether you are using the multi-cell entry workflow.
Do these 3 things before closing this tab:
1Clear out junk files and repair common Windows errors2Scan for outdated or missing drivers - takes under a minute3Repair Windows errors before they cause bigger problemsWhen the fill handle is a better fit
Microsoft also documents the fill handle as an alternative for entering the same data into several cells. Use whichever method suits the selection and your working style: Ctrl+Enter is a keyboard workflow for a chosen selection, while the fill handle is another way to copy the entry into cells. Neither is universally better for every task.
Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.Take care when worksheets are grouped
Excel can apply edits to matching cells across multiple selected worksheets. That can be useful when the same change is intended on each sheet, but edits apply to all selected sheets and can inadvertently replace data. Confirm which worksheets are selected before editing grouped sheets; Microsoft’s data-entry guidance describes this behavior and its risk.
Quick Recap
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
