Look Who it Was Random video

Excel - 7 Ways to Paste Values in Excel - Shortcut, Macro, and More! - Episode 877

487 views · Published 5 January 2009 · 4:00 · Indexed 20 September 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial: 7 Ways to Paste Values in Excel - Shortcut, Macro, and More!.

Welcome back to the MrExcel netcast! In this video, we're going to talk about Paste Special Values in Excel. I just got back from one of my Power Excel seminars where I always stress the importance of using this feature. Most people are familiar with the traditional method of copying and then using the Paste Special Values option. But did you know there are several other ways to do this that can save you time and clicks?

One method is to use the keyboard shortcut Ctrl+C followed by Alt+ESV. This is a little faster than the traditional method, but there are even quicker ways to Paste Special Values. For example, you can add the Paste Values icon to your toolbar and simply click it after copying. This reduces the process to just two clicks. But thanks to a suggestion from Dawn in Orville, Ohio, we have an even better solution.

Dawn pointed out that we can create a simple two-line macro that will convert formulas to values with just one click. To do this, go to Tools, Macro, Record New Macro and name it "PasteValuesInPlace". Make sure to turn on Relative Reference and then perform the Ctrl+CLESV action. This will create a macro that copies and pastes values in one step. You can then add this macro to your Personal Macro Workbook and assign it to an icon on your toolbar for easy access.

But wait, there's more! I can't talk about Paste Special Values without mentioning my favorite trick of all time. In Columbus, Indiana, I learned a fast way to change formulas to values by right-clicking and dragging. This brings up a menu where you can select "Copy Here as Values Only". With at least seven different ways to Paste Special Values, you're sure to find a method that works best for you. Thanks for watching and be sure to check out our other netcasts for more Excel tips and tricks.

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/


Seven ways to paste values in Excel. While I talk about many ways to convert formulas to values, Don from Orrville has come up with a method shorter than the other 6 methods I usually discuss. So...drumroll please... Episode 877 with method #7 for doing Paste Values!!!

Table of Contents:
(00:00) Introduction
(00:15) Using Paste Special Values
(00:25) Faster Method Using Ctrl+C and Alt+ESV
(00:40) Using the Paste Values Icon
(01:05) Adding a Macro for One-Click Solution
(01:25) Customizing the Toolbar
(03:01) Shoutout to Columbus, Indiana
(03:14) Fast Way to Change Formulas to Values
(03:38) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial

This video answers these common search terms:
Adding the Paste Values icon to the toolbar
Changing formulas to values
Copy and paste methods
Copy Here as Values Only feature
Creating a two-line macro
Ctrl+C and Alt+ESV shortcut
Customizing the toolbar
Paste Special Values
Paste Values icon
Personal Macro Workbook
Power Excel seminars
Using macros in Excel


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

More from this channel