10 Paste Special Tricks Excel Pros Use to Save Hours (+Cheat Sheet)

The copy-paste tricks that Excel pros use daily to save hours on mundane tasks.

Most Excel users only use the paste special dialog box to paste values, missing out on the 16 other Paste Special options that can wield all kinds of Excel magic… if you know how.

In this video I’ll show you some of my favourite shortcuts I use all the time, making Excel do the heavy lifting to instantly fix messy data and speed up my workflow.

And stick around to the end because I’ve got a free tool to help you master these tricks in no time.

LEARN MORE
===========



⏲ TIMESTAMPS
==============
0:00 Many Excel users miss this
0:26 Trick №1
2:08 Trick №2
2:51 Trick №3
3:22 Trick №4
4:32 Trick №5
5:44 Trick №6
6:28 Trick №7
7:33 Trick №8
8:02 Trick №9
9:57 Trick №10
11:11 Free bonus

#Excel #ExcelTricks #PasteSpecial

[MyOnlineTrainingHub]

❓ What’s the most frustrating data cleanup task you deal with in Excel?

[chrism]

These are great Mynda! I usually use ALT-E-S to bring up the Paste Special dialog box, I never new about Ctrl-Alt-V, thanks

[bpbeary]

I use Format Painter and custom number formats a lot with my sheets. The downside is that it's typically a once-and-done copy; you have to double-click the paintbrush icon to keep CutCopyMode on. But I prefer typing commands rather than mousing & clicking, so Paste Special Formatting is a great time saver; for a simple one-time paint Alt-H FP does the job, and for multiple paints it's a regular Ctrl-C to copy followed by Alt-H VR to paste format as often as needed.

[alcoolbc]

Valuable! How many times have you broken me out of my 'fixed' and usually limited way to use these tools! Learning new skills never stops. Thank you a ton...

[almontaser]

I wish I could give you more than one like because your videos are just so good! Thank you so, so much for everything you do.

[mogarrett]

you always have the best tutorials...thank you so much

[tecwzrd]

I knew most of these but still learned a few things :) I mostly paste special values only and I always right click using the right click on the keyboard and then S, then A to do it. Didn't know about the Ctrl+Shift+V for the values only. I might use it, but I'm so used to doing it the other way. I will share that tip though as I think it's easier to remember for people who don't know.

[sanketv]

Please make a video about ----all merging conditional in first group on left/right side--which is normally dimmed)

[rahulphalke]

Learned skip blanks in paste special today. Thanks.

[حسامكانو]

Great this actually save a lot of time for my work....thanks

[chahineatallah]

Great video, specially the last tip of copying chart formats, I used to do ctrl +d for charts, so the f4 and paste special is great for charts

Paste special mainly I use the values in it, before I used also the transpose but now there is transpose formula in excel 365

Paste special is hidden gem 😀 in excel

[dispirted]

Nice video, thanks. For one thing, I didn’t know the Ctrl+Alt+V shortcut for Paste Special. I have been using Alt, E, S.

Probably, I will carry on using Alt, E, S, because I prefer shortcuts where you don’t have to hold two keys down at once.

[juddgoswick]

Paste Special > Multiply by 1 is a handy way to convert numbers that came in as text values from another source.

[PaulEBrownbill]

Thanks, including for the cheat sheet. handy Paul

[scotolivera]

honestly i never thought that there will be something i wouldn’t know about in this video, but that skip blanks was new even though i use paste special like 100 times per day

[alexb]

Although most people use Paste Values, in most cases there are some columns that contain dates and they would be better off using Paste "Values and number formats". This will show the dates as dates rather than showing a 5 digit number.

[ericgustafsson]

Just found you channel - seems like great stuff! Will come back for more :)
Do you have any video on concatenating a "formula"? Seems they removed it..?

[nicolevanheerden]

Great tips but if someone removes the values in your empty cells you will get errors. So once done, I always go and paste them as values.

[Nezarus]

CTRL+SHFT+V holy cow! When did they add that?

I'm also embarrassed to admit I use the special paste window a lot but apparently can't read, because I never noticed the math functions. No more temp columns for me.

[JonathanExcels]

Its probably just me, but I use transpose enough that I memorized that menu acceleration as well.

F4 is very underutilized. "Wait, how did you just do that?" Is the comment I hear.