Microsoft Excel Question: Download Questions PDF
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 special command to past the permanent values over the original formulas?
Answer:
Yes there is. You will need to first select the cell or range of cells that you want to convert to fixed values. Then you will need to drag the blocked cell or range one row over, either to the right or left. The row you are moving it to should be empty. Then using the right mouse button, drag the selected cell or range to where you originally had it. Once you release the right mouse button a shortcut menu will display, which will give you several options to choose from, you will select “Copy Here as Values Only”. This will give you a permanent value.
Download MS Excel Interview Questions And Answers
PDF
| Previous Question | Next Question |
| My furnace and air conditioner are both new. Do I really need to have it cleaned? | Can I open .PRN files in Microsoft Excel? |