New Shortcut in Excel - CONTROL + SHIFT + V
HTML-код
- Опубликовано: 28 сен 2024
- Excel introduced a NEW Excel Shortcut - Control + Shift + V to paste as values in Excel.
In this short video, I show how to use this Excel shortcut and some scenarios where it could be helpful (such as converting formulas to values).
00:00
00:50 Control + Shift + V to Copy Data Without Formatting
02:08 Control + Shift + V to Copy Data from Web
02:49 Control + Shift + V to Remove Formulas
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - www.buymeacoff...
✅ Free Excel Course (Basic to Advanced) - trumpexcel.com...
✅ Free Dashboard Course - bit.ly/free-ex...
✅ Free VBA course - bit.ly/excel-v...
✅ Free Power Query Course - bit.ly/power-q...
✅ Best Excel Books: trumpexcel.com...
Subscribe to get awesome Excel Tips every week: www.youtube.co...
#Excel #ExcelTips #ExcelTutorial
If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what Excel topics you want me to cover in future videos.
Also, I have made all of my Excel courses available for free. You can check these out using the below links:
✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
✅ Free Dashboard Course - bit.ly/free-excel-dashboard-course
✅ Free VBA course - bit.ly/excel-vba-course
✅ Free Power Query Course - bit.ly/power-query-course
This is a very handy shortcut. Thanks for sharing!!!
Yeah, I am glad it's finally in Excel. It's kinda universal and works in most apps and sites I work with.
Thank you. I will definitely be using this shortcut.
Thanks for commenting... Glad you found the video useful :)
Always useful Sumit ! Thx again for yeaurs of good hints for us ! You are my EXCEL expert ! 🙂
Thank you so much for the kind words Michel 😊 Hope you're well. Good to see you
That was a good one! Thanks!
Thanks... Glad you found the video useful :)
Thank you Sumit for sharing
Glad you liked the video!
Thank you so much. Very helpful video
Glad you found the video useful :)
Thanks much!!!!
Glad you liked the video!
Thanks 🙏🙏👍👍
Hello sir can you share some vedio about search box in excel?
Have a look at these videos:
- ruclips.net/video/xBRkCv6RWcE/видео.html
- ruclips.net/video/k-ALMFokyzg/видео.html
- ruclips.net/video/_WqBWv7_IkQ/видео.html
@Summit Brother Can you please guide on how to retain date and time formats same as when doing paste as values, date and time value convert into numbers instead of actual date or time. I want to keep the date and time value intact while using paste as values. Is there any way to do this.
You can retain date format when you paste the format as well. So when you have pasted the data, right click again and choose Formatting option under Paste Options. You can also use the shortcut ALT + E + S + T + Enter
Thank you brother.
Its not working even in office 365
Try Alt+E+S+V Enter
👍
Great video Sumit👍.. I came to know about this shortcut accidentally as I use this in Google Sheets a lot.
I want to ask is there any Keyboard Shortcut for using Format Painter in Excel?
You can use ALT + H + F + P to copy and activate format painter. But then you will have to use the mouse /trackpad to make the selection. So not a very helpful shortcut unfortunately
Ctrl,alt , v
Control Shift V.
Control ALT V will open the Paste Special dialog box.
Hey bro, why here doesnot work? I use this comand in my job, but here in my house doesnot work
Thank you for sharing... I am way too happy about this lol!
I am very happy about this too.... nerds, lol ;)
Very good shortcut thanks
Thanks for commenting... Glad you found the video useful :)
Google sheet also has the same shortcut key to paste as value.
Yes, they have had it for years. They also have another one that Excel hasn't copied (yet), which is to paste formats only (Control + ALT + V). In Excel, this open the Paste Speical dialog box.
Thanks for sharing this helpful tip Sumit!
Glad you found the video helpful Marinalini 🙂
How to connect with you sir
You can reach me at sumitbansal@trumpexcel.com