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

[@MyOnlineTrainingHub]

❓ What’s the most frustrating data cleanup task you deal with in Excel? Download the example file & cheatsheet here: bit.ly/pastespecial24file

[@juskeepit]

Thank you.

[@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...

[@bpbeary8011]

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.

[@juskeepit]

Thank you.

[@chrism9037]

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

[@MyOnlineTrainingHub]

Glad to introduce you to Ctrl-Alt-V, Chris 😁

[@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.

[@almontaser92]

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.

[@حسامكانو]

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

[@dispirted8]

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.

[@sanketv1]

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

[@mogarrett3045]

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

[@scotolivera8207]

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

[@dispirted8]

I was aware of skip blanks, but never understood what it did. Now I know, I am sure I will find a use for it.

[@PaulEBrownbill]

Thanks, including for the cheat sheet. handy Paul

[@nicolevanheerden7879]

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.

[@juddgoswick2024]

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

[@sawa85sa]

around Win XP Excel really struggled with bigger ranges to use its own "convert text to number" function and multiplying by 1 was my go to as well, but the new 365 converts itself just as quick - try it

[@navinraj0107]

Thank you

[@123mailashish]

❤

[@laganuk]

My pet hate is converting American, mm/dd/yyyy, to British dates, dd/mm/yyyy.