Enter Same Data in Multiple Cells in Excel
This shortcut allows you to input the same value into multiple selected cells simultaneously. It is extremely useful when you need to fill many cells with identical data quickly.
Keyboard Shortcut
| Windows / Mac |
|---|
| Ctrl + Enter |
What Does This Shortcut Do?
When you select multiple cells and type a value, pressing Ctrl + Enter will enter the same data into all the selected cells without moving the active cell.
How to Use the Shortcut
- Select the range of cells where you want to enter data
- Type the value you want to enter
- Press Ctrl + Enter (Windows / Mac)
- All selected cells will now contain the same value
Tips & Best Practices
- Works with both numbers, text, and formulas
- Ideal for filling multiple empty cells quickly
- Combine with formatting shortcuts to maintain consistent style
FAQ
- Q: Can I use this in non-contiguous cells?
- Yes, you can select multiple non-adjacent cells using Ctrl (Windows) or Cmd (Mac), then use Ctrl + Enter to fill them all.
- Q: Does it overwrite existing data?
- Yes, the selected cells will all be replaced with the new value.