answersLogoWhite

0


Best Answer

we can use the option copy and then past special value.

User Avatar

Wiki User

15y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How you delete formula in excel sheet without deleting value?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

How do you cancel the formula that you entered into an excel?

You place your cursor in the cell, and delete the formula.


List 2 things you should NOT do when deleting data in Excel?

You should not delete data that is crucial to the working of the spreadsheet. You should not delete data that will interfere with how formulas work.


How do you delete on excel?

It depends on what you want to delete. Deleting what is in cells can be done by selecting them and pressing the Delete key. You can also delete charts by selecting them and pressing the Delete key. To delete full rows and columns, you can select them and use the menu/ribbon options to remove them completely.


How do you move a horizontal line of print in Excel down the page without deleting the line of print?

You can cut and paste it.


How do you edit a formula in Excel?

Click on the cell containing the formula and edit within the cell or in the cell bar at the top of the screen. You can do that by clicking in the formula or pressing the F2 key.


How can you change the case of letter in Microsoft Excel without using any formula in current cell position?

If you do not want to use a formula, you can delete the lower case letter (Del or Backspace) and type an upper case letter.


How do you delete the shared document in Microsoft Excel?

I am not sure what you mean by shared document. If you are talking about a document on SharePoint, ensure you have edit access and follow the procedures established on your SharePoint portal for deleting a document.


How do you cancel an entry in Excel?

You can delete it if it has already been entered, by pressing the delete key. If you are still typing it in you can press the Esc key or the red X on the formula bar to stop it.


What happens in Excel when you clear a cell?

Same as deleting its content.


How would you delete a data from a cell in excel?

Use the delete key.


How do you number your rows in Excel?

To number your rows in Excel, put a '1' in the first row, for instance in cell a1, the formula '=a1+1' in the second row, and then copy that formula to each additional row you want to number. Be careful, though, as inserting and deleting rows will mess the sequence up, and you will need to fix it as needed.


Does the Delete key in Excel 2013 remove all texts and formats?

The delete key in Excel 2013 removes content, but not formatting.