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