Have formulas that you want to remove but keep the data as is? In this video, I will show you two super simple methods to remove the formula but keep the data.

The first method is by using Paste Special. You just need to copy the existing cells – which have the formulas that you want to remove – and replace these with values only. This can easily be done using the Paste Special dialog box.

Another method to do this is by using a less-known mouse trick. Select a range of cell, place the cursor at the right edge of the selection, hold the right mouse key and move it a little to the right and then bring it back. This will show you a menu that will have the option to ‘copy and paste as values’.

This video is a part of my ‘Excel is two-minute’ series, where I share simple and quick tips to help you speed up your work and be more efficient

Free Excel Course – https://trumpexcel.com/learn-excel/
Paid Online Training – https://trumpexcel.com/excel-training/
Best Excel Books: https://trumpexcel.com/best-excel-books/

️ Gear I Recommend:
Camera – https://amzn.to/3bmHko7
Screen Recorder – techsmith.z6rjha.net/26D9Q
USB Mic – https://amzn.to/2uzhVHd
Wireless Mic: https://amzn.to/3blQ8uk
Lighting – https://amzn.to/2uxOxRv

Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexcel?sub_confirmation=1

Note: Some of these links here are affiliate links!

#Excel #ExcelTips #ExcelTutorial

Please take the opportunity to connect and share this video with your friends and family if you find it useful.