Excel Level-Up: Day 3

Advance Copy & Paste

I’m sure you are pretty good in copy and paste, i.e. [Control] + [C] and [Control] + [V].

Today, we are going to show you a more sophisticated technique of pasting.

You might have known the “Paste Special” function in the Excel but do you know that it can be done without using mouse?

The trick is very simple, pressing [Alt], then [E], then [S] will prompt the “Paste Special” dialogue out.

From here, you can choose the option that it has by simply press the corresponding letter underlined in each function.

For example, to paste special as value, press [Alt] [E] [S] [V] (one at a time).

To paste special as formatting only, press [Alt] [E] [S] [T]

To paste special as formula only, press [Alt] [E] [S] [F]

Same apply to all functions.

Now, are you excited to use this trick to level up your pasting skills?

Go back to previous awesome trick: Excel Level-Up: Day 2

Proceed to next awesome trick: Excel Level-Up: Day 4