Excel Shortcut of the year
On February 3rd this year I published a post titled My Excel Shortcut of the Year. Now, only two months later, I’m passing the flattering title on to another shortcut. Ctrl + ‘
Ctrl + ‘
If you haven’t heard of this already, brace yourselfJ. In cell A1 write a formula, function or any constant entry you want. Now go to the cell bellow that (A2) and press Ctrl + ‘.
Guess what, you get an identical entry right away. Yet another big step towards eternal happiness.
Related Posts
Add data to your Chart (the easy way)
- April 7, 2015
(as simple as Copy and Paste) This is our sample data. First we ...
My Excel Shortcut of the Year
- February 3, 2015
In my work as a Trainer and also as a Data Scientist (I love that ...
What Excel should learn from Word
- November 25, 2014
I’m only guessing, but I think that anybody who wants to ...
Comments 3
Leave a Reply
Excel Unplugged acknowledgements
Donate
If you have a formula in A1
if you key: CTRL+’ – the FORMULA will be copied.
But:
if you key: CTRL+SHIFT+’ – the FORMULA’S VALUE will be copied.
@Meni
You are right and thanks for that, but that one has an issue. It doesn’t work on every keyboard layout. The shortcut for the value is actually Ctrl + ” which in some countries is Ctrl + Shift + ‘, for some it’s Ctrl + Shift + 2 and so on…
@Gašper
Yes, we all know that the UI (user interface) of Excel might operate differently on other languages. At least in the English UI it works as I explained.
Best Regards.