Excel Rev Up - Paste Options: Episode 1282

Microsoft Excel Tutorial: Excel Paste Options: Convert Formulas to Values with Keyboard Shortcuts and Mouse. Welcome to another episode of the MrExcel podcast. In this episode, we're diving into Excel 2010's Paste Options menu, specifically the ability to quickly convert formulas to values. Before Excel 2010, my go-to method for this was to right-click and drag, but now there's an even faster way. Let's take a look. First, we have a set of formulas that we want to convert to values. Instead of right-clicking and dragging, we can simply use the keyboard shortcut Ctrl+C to copy and then Ctrl+V to paste. This will bring up the Paste Options menu, which can also be opened with the shortcut Ctrl. From here, we can see a variety of options, each with their own shortcut key. The one we want is values, which is represented by the letter V in parentheses. So, to quickly convert our formulas to values, we can use the shortcut Ctrl+C, Ctrl+V, Ctrl, V. This keeps our hands on the keyboard and is the fastest method I've found. But, if you prefer using the mouse, you can also right-click and choose the Paste Options menu, then select values. To make things even easier, I've created a chart with all the keyboard shortcuts and their corresponding icons. You can find this chart on our WordPress blog, so you can print it out and keep it handy next to your computer. The hardest part is figuring out what each icon means, but once you have that down, converting formulas to values will be a breeze. Now, for the absolute fastest way to convert formulas to values, we can use the keyboard shortcut Ctrl+C to copy and then the Program key (also known as the Context key) and V to paste. This will bring up the right-click menu and automatically select the values option. It may take a bit of practice to get used to, but once you do, it will become your new favorite method. Thanks for tuning in to this episode of the MrExcel podcast. Don't forget to check out our WordPress blog for more helpful tips and tricks. See you next time!" 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-... Table of Contents: (00:00) Chapter 6: Paste Options in Excel 2010 (00:11) New Paste Options menu for converting formulas to values (00:25) Previous method for converting formulas to values (00:39) Faster method using keyboard shortcuts (01:10) Using mouse to access Paste Options menu (01:30) Keyboard shortcut chart available on WordPress blog (01:49) Absolute fastest way to convert formulas to values (02:38) Clicking Like really helps the algorithm This video answers these common search terms: Chart of keyboard shortcuts Context key/Program key Convert formulas to values Ctrl+C Ctrl+V Excel 2010 Fastest way to convert formulas to values Keyboard shortcuts Mouse shortcuts MrExcel netcast MrExcel podcast Paste Options Episode #1282 takes a look at the new Paste Options menu in Excel 2010. Specifically, Bill reviews a variety of time methods to convert Excel Formulas to Values in Excel 2010. "Rev Up to Excel 2010: Upgraders Guide to Excel 2010" by Bill Jelen Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads...