How Do You Enter The Same Material Into Multiple Cells Quickly?
If you want to enter something in cell A1, and have the same value or formula extend down to A20, how would you do it? Here are three methods that are commonly used:
- Copy and Paste (copy A1, then select A2:A20, and hit paste)
- Autofill (drag what you’ve entered in A1 all the way down through A20 using the autofill handle (or by double-clicking in some cases))
- Ctrl+D (fill-down shortcut — you enter into A1, then select A1:A20 and hit Ctrl+D)
Ctrl+Enter: A Less Common, But More Useful Fourth Way
Here’s a fourth one that’s simple, yet not as commonly used — and you’ll see that it’s also faster and more flexible:
So how does Ctrl+Enter work?
Simple: just select your whole range BEFORE you start typing. Then, after you’re done typing, hit Ctrl+Enter instead of Enter.