Paste Buddy is an Excel Add-in that will automatically load every time you open Excel. It's a really fast way to paste values, and you can setup custom shortcuts for any of the paste special commands. I then undo my actions with Ctrl+Z to show that you can still use Undo with Paste Buddy. Then I use the keyboard shortcut Ctrl+Shift+V to paste the values in cells E6:E8. In the above video I use Ctrl+C to copy cell C8.
In the following example I am using the keyboard shortcut Ctrl+Shift+V to paste values in the the worksheet. And the keyboard shortcuts are fast and easy to perform in one step. This means you can choose keyboard shortcuts for any of your favorite paste special commands. Paste Buddy is an Excel Add-in that allows you to create custom keyboard shortcuts for any of the paste special commands like paste values, formulas, formats, and more. So I have developed a solution that has saved me a lot of time and will hopefully do the same for you. It also prevents you from using the QAT for other commands that do not have keyboard shortcuts. Using the QAT is great, but many people find that to be quite a stretch with the fingers. This makes them slow and/or difficult to perform. Most of the other built-in methods require multiple mouse clicks or key presses. Most Ways to Paste Values are Slow or Difficult One of the fastest ways I have found to paste values is to add the paste special buttons to the Quick Access Toolbar (QAT) and then use the built-in Alt+# keyboard shortcuts. If you are a reader of my blog, you probably know that I am constantly trying to find the fastest and most efficient ways to get things done in Excel. Since it's something we do so often, it's best to figure out which of these eight methods is the fastest. That means that we spend a lot of time copying and pasting. There Are A LOT of Ways to Paste Valuesĭid you know that there are at least eight different ways to perform the paste special commands in Excel? Eight different ways! I'm talking about copying a cell that contains a formula or number formatting, and pasting the values of that cell to another cell. What method do you use to paste values in Excel?
0 kommentar(er)
