MicroKnowledge, Inc.
21 British American Blvd.
Latham, NY 12110
Phone: 518.786.1181
Fax: 518.786.6221

MK Blog


« Return to MK Resources

Excel: Fun with Ctrl+Enter
Posted: April 19, 2012

Stumbling upon new tips in a program I’ve already used for many years is always a good time. Most recently, I discovered some interesting uses for Ctrl+Enter in Excel. (This means pressing Ctrl and Enter at the same time).

For starters, I use Ctrl+Enter whenever I want to finalize typing in a cell but want the focus to stay on the cell – say because I am going to copy it next. Pressing only the Enter key shifts the cell focus down one. You could also change what Enter does through Options, but I like the ability to choose either way with the press of the Ctrl key.

Another interesting feature can be used when highlighting multiple cells, typing a value and pressing Ctrl+Enter. The value you type automatically copies down to all the highlighted cells!

And, you know, it works the same when creating or updating formulas.

Yet another way to copy quickly in Excel. Amazing!

If you’re feeling adventurous, you can also try experimenting with Ctrl+Enter in Array Formulas (Chip Pearson explains more), or you can try using Alt+Enter in some of your column headings.

Author:  Ryan Donelan

Remember, if you are a MicroKnowledge customer and have a software question to ask, feel free to contact us at any time by using our Support link at the top of the site. Your question might be featured in our next blog entry!

Do you have a related tip to share? Leave a comment. We’d love to hear from you

Category: Tech Tips

Leave a Reply

microknowledge.com is proudly powered by WordPress | Design by Trampoline-Design | Follow Us on Google + Google+ | Subscribe to RSS Subscribe to RSS