21 British American Blvd.
Latham, NY 12110
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