Microsoft Excel Interview Question:

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?

Submitted by: Administrator

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.
Submitted by: Administrator