Learn how to copy & paste values in Excel with right-click and drag shortcut. This is a quick way to replace formulas in a range with values.
-- LINKS --
DOWNLOAD THE WORKBOOK ►[ Ссылка ]
*** JOIN OUR COMPREHENSIVE EXCEL TRAINING PROGRAM***
[ Ссылка ]
--
~ Learn my BLUEPRINT for Excel including when to use what tool (FREE TRAINING SESSION) [ Ссылка ] ~
~Become an Excel Campus Insider (100% free) to access advanced workshops, bonus training, and weekly Excel tips: [ Ссылка ]
-- Copy & paste values in Excel with right-click and drag shortcut --
Here are a few important things to know about this technique:
- This method can only be used when copying & pasting on the same sheet. You cannot right-click and drag to a different sheet.
- The range is NOT copied to the clipboard. This can be a pro or con, but I typically consider it to be a positive. You don't have to worry about hitting Escape to exit CutCopy Mode (stop the marching ants around the range) because the range is never copied to the clipboard. This can prevent accidental pastes with the Enter key.
- After releasing the right-mouse button, you can hit the Escape key if you want to cancel the operation.
- There are quite a few other handy commands on that right-click menu, and I encourage you to check those out too.
**********
EXCEL FRIENDLY ACCESSORIES WE USE (Affiliate Links When Possible): LOGITECH KEYBOARD
Check out all the tech we use and recommend at [ Ссылка ]
**********
--- Related Content ---
- 5 Keyboard Shortcuts for Pasting Values: [ Ссылка ]
00:00 Introduction
00:22 Rightclick drag Method
01:19 Replace Values
02:03 Recap
02:20 Outro
![](https://s2.save4k.ru/pic/sVagS3j1ryI/maxresdefault.jpg)