Excel - Fast Formulas to Values - Episode 2019

1,661 views · Published 14 September 2016 · 4:26 · Indexed 12 November 2026

Channel: MrExcel.com · 2016 · Education

Watch on YouTube

Microsoft Excel Tutorial: Microsoft Excel - Convert Formulas to Values | Excel Tips and Tricks.

Welcome to episode 2019 of the MrExcel podcast, where we will be discussing one of the most useful Excel skills - converting formulas to values. As always, you can find the entire podcast series by clicking the “i” on the top-right hand corner and accessing the playlist for all of the videos.

In this episode, I will be sharing my two favorite methods for converting formulas to values. For those who prefer using the mouse, the first method involves selecting the data, holding down the right mouse button, and dragging to the right and then back to the left. This will bring up the alternate drag and drop menu, where you can select “Copy Here as Values Only”. This menu can be accessed anytime you right-drag a selection, making it a quick and efficient way to convert formulas to values.

For those who prefer using keyboard shortcuts, the second method is for you. Simply select the data, press Ctrl+C to copy, then press the right-click key (or Shift+F10 if you don’t have the key) and then press V. This will instantly convert your formulas to values. This shortcut was introduced in Excel 2010 and has been a game-changer for many Excel users. 

But wait, there’s more! In the outtakes of this episode, I will also be showing you several other methods for pasting values, such as using the copy and paste icons, the Alt E S V Enter shortcut, and the Ctrl+Alt+V shortcut. I will also be addressing the issue with the Quick Analysis icon in Excel 2016 and how it affects the Ctrl+V shortcut. And if you know of any other methods, feel free to share them in the comments section below. 

Don’t forget to grab a copy of my book, where you can find even more amazing tips and tricks for Excel. The e-book is only $10 and the print book is $25. Thank you for tuning in to this episode of the MrExcel podcast, and I’ll see you next time for another netcast!

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/


Table of Contents:
(00:00) Change formulas to values in Excel
(00:16) Two favorite ways to convert formulas to values
(00:30) Using the mouse: alternate drag and drop menu
(01:14) Using keyboard shortcuts: Ctrl + Alt + Spacebar + Application key + V
(01:52) Recap 
(02:03) Buy the book
(02:16) 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 #excelformula #excelformulasandfunctions #pastevalues

This video answers these common search terms:
change formula to value in excel
change from formula to value excel
how to change formulas to values in excel
how to change formulas to values in excel
how to change from formula to value in excel
how to change formulas in excel to values
how to change excel from formula to value
how to change from excel formula to values
how to change a formula in excel to a value
how do i change a formula to a value in excel
how do you change formula to value in excel
how do you change excel from formula to value
excel how to change formula to value
excel how to change from formula to value
how to value paste in excel
how to paste value excel keyboard
how to paste value only in excel
how to paste values in excel as numbers
how to paste values in excel shortcut
how do you paste value in excel
how to paste as a value in excel
what is the paste values option in excel
how to hotkey paste values in excel
how to paste special values in excel
how do i shortcut paste values in excel
how to copy paste unique values in excel
how to copy and paste unique values in excel
is there a shortcut to paste values in excel
what is the shortcut to paste values in excel
how to paste in excel to number values
how copy values in excel not formula
how to turn formula into value in excel
how to turn formulas into values excel
how to remove a formula but keep the value in excel
how to remove a formula but keep the values in excel
excel how to remove formulas and keep values
excel how to remove formulas but keep values
how to remove formula in excel and keep value
how to delete the formula in excel but keep values


You need to convert formulas to values
Mouse: Right-drag the border of the range to the right, back to the left, let go
Choose Copy Here as Values Only from the Alternate Drag-and-Drop menu
Keyboard: If you have the right-click key, Ctrl+C, Right-Click Key, V
If you don't have Program key, you can use Shift+F10 instead
Several other methods shown in the outtake

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

More from this channel