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.

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

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

[@MyOnlineTrainingHub]

Nice tips. Thanks for sharing.

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

[@MyOnlineTrainingHub]

I'm so happy to hear that! Thanks for watching!

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

[@MyOnlineTrainingHub]

Awesome to hear!

[@sanketv1]

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

[@MyOnlineTrainingHub]

Good suggestion 🙏 It pastes the contents and conditional formatting options from the copied cells.

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

[@MyOnlineTrainingHub]

That's great to hear - I'm glad you found something new!

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

[@MyOnlineTrainingHub]

@sawa85sa good point. The newer versions of Excel are very good at identifying numbers stored as text and enabling you to convert it with the click of a button.

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

[@MyOnlineTrainingHub]

Yes, good point 👍

[@mogarrett3045]

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

[@MyOnlineTrainingHub]

Thanks for your kind words and support!

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

[@MyOnlineTrainingHub]

Yeah, I found the key wrangling required for CTRL+SHIFT+V hard at first, but I'm used to it now.

[@حسامكانو]

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

[@MyOnlineTrainingHub]

Awesome to hear!

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

[@MyOnlineTrainingHub]

So pleased to hear you both found something new!

[@PaulEBrownbill]

Thanks, including for the cheat sheet. handy Paul

[@MyOnlineTrainingHub]

My pleasure, Paul!

[@alexb9312]

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.

[@MyOnlineTrainingHub]

Nice tip. Thanks for sharing.

[@navinraj0107]

Thank you

[@MyOnlineTrainingHub]

Thanks for watching!

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

[@123mailashish]

❤

[@MyOnlineTrainingHub]

Thanks for watching!

[@laganuk]

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

[@alexb9312]

To do that use Text to Columns in Step 3 select Date and pick the original (source) date from the drop down box which in your case would MDY

[@MyOnlineTrainingHub]

Yeah, it's annoying. I use Power Query to fix dates like this on import of the data.