Is there an easier way to change formula results to fixed values in microsoft excel? I usually copy the cells that I am working with and then use the paste specialcommand to past the permanent values over the original formulas?
- 1 Answers
- 771 Views
- I also Faced
- E-Mail Answers
Answer / Alok Kumar Pandey
To change formula results to fixed values in Microsoft Excel without using Paste Special, consider the following steps:n 1. Copy the cells containing formulas.n 2. Right-click a destination cell and select 'Paste' or press Ctrl + V.n 3. Instead of seeing the results of the formulas, you will see 'Values'.n 4. Click 'Formulas' in the Paste Options dialog box to see the original formulas.
| Is This Answer Correct ? | 0 Yes | 0 No |
How do I consolidate text data in excel?
How many types of work in ms excel?
What are the three components of a data table in excel?
How do you add a measure in a pivot table?
How do you do autosum in excel?
Who built microsoft excel?
How to sort numerically in excel?
How do I enable the shortcut menu in excel?
How do you ungroup worksheets in excel?
How do I remove a table from excel?
What is difference between excel and spreadsheet?
What are the benefits of ms excel?
MS Excel Microsoft 
