How do you save a spreadsheet with formulas to appear as values?
B Beginner Excel User Mar 21, 2006 #1 How do you save a spreadsheet with formulas to appear as values?
D Duke Carey Mar 21, 2006 #2 You must convert the formulas to values BEFORE you save it. Select the range of formulas, press Ctrl-C to copy them, and without changing the selection use the menu Edit->Paste Special->Values Then save your file
You must convert the formulas to values BEFORE you save it. Select the range of formulas, press Ctrl-C to copy them, and without changing the selection use the menu Edit->Paste Special->Values Then save your file
C Clivey_UK Mar 21, 2006 #3 If you want to permanently change the formulas to values, select th range of formulas and choose Edit/Copy. Then choose Edit/Paste Specia and click against Values and then click OK. So for instance =1+2 woul be permanently converted to 3.
If you want to permanently change the formulas to values, select th range of formulas and choose Edit/Copy. Then choose Edit/Paste Specia and click against Values and then click OK. So for instance =1+2 woul be permanently converted to 3.
