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 - trumpexcel.com/learn-excel/
Paid Online Training - trumpexcel.com/excel-training/
Best Excel Books: trumpexcel.com/best-excel-books/

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

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

Note: Some of these links here are affiliate links!

#Excel #ExcelTips #ExcelTutorial

• Remove Formula but keep the data in Excel (2 Really Simple Ways) ( Download)
• Remove All Formulas from an excel sheet and Keep Values (using Shortcuts) ( Download)
• How to Remove All Formulas but Keep Values in Excel ( Download)
• how to remove formulas from excel sheet but keep the values l excel formula hacks l ( Download)
• Delete Values But Keep Formulas. Reset An Excel Worksheet. ( Download)
• How to Quickly Clear Data But Not Your Formulas in Excel | Reset Your Spreadsheet ( Download)
• Delete values only but keep the formulas #shorts ( Download)
• How to Remove Formulas but keep Values in Excel cells ( Download)
• I Simpósio - Tubarões e Raias de Noronha - dia 2 ( Download)
• Excel tip how to delete and not lose everything because formulas are in cells ( Download)
• Delete All Data in a sheet but Keep Formulas | Excel ( Download)
• How To Remove Formulas But Keep The Values In Excel [Excel Trick] You Didn`t Know It! ( Download)
• Remove Formulas But Keep The Data In Excel ( Download)
• How to Remove Formulas but keep Values in Excel cells ( Download)
• How to Remove All Data but Keep Formulas in Excel ( Download)