Faster At Excel

  • Home
  • Book: Excel Shortcut Bible

  • Shortcuts
  • Blog
  • Archives
  • Links
  • My Account
  • Login
  • About
  • Contact

Use Excel’s Ctrl+Enter To Fill Multiple Cells Quickly

August 31, 2016 by terp Leave a Comment

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:

  1. Copy and Paste (copy A1, then select A2:A20, and hit paste)
  2. 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))
  3. 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:

4. Ctrl+Enter

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.

According to Microsoft, Ctrl+Enter “Fills the selected cell range with the current entry.”  So:

Fill the selected cell range with the current entry: Ctrl+Enter

Ctrl+Enter Is Faster And More Flexible

In the A1:A20 example, Ctrl+Enter is only three steps (select A1:A20, type content, hit Ctrl+Enter).  The other three methods are either four steps (Autofill and Ctrl+D) or six steps (Copy & Paste) (try it yourself if you don’t believe me).  See below:

excel-ctrl-enter-shortcut

 

Unlike with Autofill and Ctrl+D, you can use Ctrl+Enter across columns, rows, rectangular ranges, and even non-contiguous ranges.  You can do the same with Copy & Paste — but Ctrl+Enter is fewer steps.

Let’s take an example of entering the same thing into two non-contiguous cells.  You can’t do that with Ctrl+D or AutoFill.  But you can with Copy & Paste, so let’s compare the number of required steps.  Copy & Paste is six steps, while Ctrl+Enter is only four.

Here’s Copy & Paste — 6 steps:

  1. Type value/formula
  2. Enter
  3. Go back to cell
  4. Copy
  5. Select new cell
  6. Paste

Here’s Ctrl+Enter — 4 steps:

  1. Select first cell
  2. Select second cell
  3. Type value/formula
  4. Hit Ctrl+Enter

 

Conclusion: Excel Ctrl+Enter Is Fast & Flexible, So Use it!

Ctrl+Enter seems counter-intuitive at first, but well worth the habit change.

Filed Under: Copy & Paste, Keyboard Shortcuts Tagged With: cut copy paste, Excel Keyboard Shortcuts, Excel Shortcuts

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Post Categories

Tags

Alt Shortcuts Books challenges Charts comments cut copy paste data Double Click Excel Formulas Excel Keyboards Excel Keyboard Shortcuts Excel macros Excel Mouse Shortcuts Excel Shortcuts Excel Speed Tricks F-Key Shortcuts Filter Find & Replace Font format Format Cells Format Painter Formatting freeze panes Hybrid Shortcuts Menu Key Open Paste Formats Paste Special Paste Values Products Quick Access Toolbar - QAT save Selection and Navigation Sort

Recent Posts

  • 3 Ways To Convert Text To Numbers In Excel
  • 5 Quick Data Set Up Excel Shortcuts
  • Excel Shortcut Bible: Comprehensive Excel Shortcut Book
  • 7 Easy Excel Speed Tips
  • Basic Excel Macros: Part 3 Of 3, Personal.xlsb & Adding A Macro To Your Quick Access Toolbar

© 2016 Faster At Excel