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 + ‘
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.
(as simple as Copy and Paste) This is our sample data. First we ...
In my work as a Trainer and also as a Data Scientist (I love that ...
I’m only guessing, but I think that anybody who wants to ...
This site uses Akismet to reduce spam. Learn how your comment data is processed.
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.