Remove Formula and Keep Valuse in Excel

Advertisements

Prev Tutorial Next Tutorial

Remove Formula and Keep Valuse in Excel

In MS-Excel many time you face this types of problem, Whenever you copy and paste the data containing the formula to another place, then your data may not be pasted. To solve this problem, you have to paste this data as a value.

To remove a formula and keep the value in Excel, Copy the cell and go to Paste drop down in Home tab. Here there are a bunch of different options to choose from. If you want to copy just the value then select Values.

remove formula and paste value in excel

To remove formula and keep valuse in excel you have to paste this data as a value.

Alternatively you can use the shortcut Ctrl+Alt+V after copying to do this. A dialogue box will open.

paste data as value in excel

Copy your data and right click on any cell then choose Paste Special next choose Value and last press OK button.


Prev Tutorial Next Tutorial

Google Advertisment

Buy This Ad Space @$20 per Month, Ad Size 600X200 Contact on: hitesh.xc@gmail.com or 9999595223

Magenet is best Adsense Alternative here we earn $2 for single link, Here we get links ads. Magenet


For Projects 9999595223

Google Advertisements


Buy Websites 9999595223

Buy College Projects with Documentation Contact on whatsapp 9999595223. Contact on: hitesh.xc@gmail.com or 9999595223 Try this Keyword C++ Programs

Advertisements