Excel Shortcut - Various Options within Excel Paste Special - Episode 2136

2,717 views · Published 22 August 2017 · 2:47 · Indexed 4 November 2026

Channel: MrExcel.com · 2017 · Education

Watch on YouTube

Microsoft Excel Tutorial: Shortcuts for various Excel Paste Special Options.

Microsoft Excel shortcuts for Paste Special Values, Paste Special Formats, Paste Special Formulas, Paste Special Multiply Values.

Welcome to another episode of Learn Excel From MrExcel. In this podcast, we will be discussing faster ways to paste values in Excel. We all know the traditional method of copying and pasting values using the keyboard shortcut CTRL+C and then ALT+E, S, V. But did you know there are even faster ways to do this?

One of the quickest ways to paste values is by using the mouse. Simply select the data you want to copy, go to the right edge of the selection, hold down the right mouse button, and drag the data to a new location. Then, release the mouse button and select "COPY HERE AS VALUES ONLY" from the alternate drag-and-drop menu. This is a great option for those who prefer using the mouse over keyboard shortcuts.

For those who prefer using keyboard shortcuts, there is a little-known key on your keyboard that can make the process even faster. It's called the program key or the application key, and it is usually located between the ALT and CTRL keys on the right-hand side. Simply press and release this key, and then press V for values to quickly paste values without having to use the ALT+E, S, V shortcut.

But what if your keyboard doesn't have this key? Not to worry, there are still other keyboard shortcuts you can use. For example, you can use SHIFT+F10 to open the drop-down menu and then press V to select values. Or, you can use ALT+E, S, F to paste formulas, ALT+E, S, T to paste formats, or ALT+E, S, M to multiply values by a specific number.

While using these keyboard shortcuts may not leave an audit trail, they are incredibly efficient and can save you a lot of time when working with large amounts of data. So, give them a try and see how much faster you can paste values in Excel. Thanks for watching and be sure to tune in for our next netcast from MrExcel.

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/

#excel
#microsoftexcel
#exceltips
#excelshortcut
#evergreen
#shortcutkey

This video answers these common search terms:
how to special paste in excel
how to special paste using keyboard excel
how to do special paste in excel
how to paste special for excel
how to paste special in excel
how to paste special in excel 365
how to paste special in excel multiply
how to paste special values in excel
what is paste special used for in excel
how does paste special work in excel
where is paste special in excel
how to do paste special in excel
how do you paste special in excel
how to get paste special in excel shortcut
how to use paste special multiply in excel
how to find paste special in excel
how to do excel paste special
what are the options of the special paste in excel

Table of Contents:
(00:00) Keyboard shortcut for pasting values
(00:19) Alternate method for pasting values using mouse
(00:55) Using the program key for pasting values
(01:34) Alternative method for laptops without program key
(01:56) Other useful keyboard shortcuts for paste special
(02:21) Clicking Like really helps the algorithm

Join the MrExcel Message Board discussion about this video at  https://www.mrexcel.com/board/threads/1153961/

More from this channel