Right click again and select Paste Special. This will open the format cells dialog box. You may spend more time waiting on Excel to finish than you do on updating or entering information.
Press Enter to complete the formula.
Select all the cells in the worksheet use the keyboard shortcut Control A. Select the cells with formulas you want to remove but keep results press Ctrl C keys simultaneously to copy the selected cells. Type the equal sign followed by the constants and operators up to 8192 characters that you want to use in the calculation. You can follow the question or vote as helpful but you cannot reply to this thread.