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
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
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920