| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Saving spreadsheet
How do you save a spreadsheet with formulas to appear as values?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Saving spreadsheet
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 "Beginner Excel User" wrote: How do you save a spreadsheet with formulas to appear as values? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Saving spreadsheet
If you want to permanently change the formulas to values, select the range of formulas and choose Edit/Copy. Then choose Edit/Paste Special and click against Values and then click OK. So for instance =1+2 would be permanently converted to 3. Beginner Excel User Wrote: How do you save a spreadsheet with formulas to appear as values? -- Clivey_UK ------------------------------------------------------------------------ Clivey_UK's Profile: http://www.excelforum.com/member.php...o&userid=32569 View this thread: http://www.excelforum.com/showthread...hreadid=524993 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| RECOVER A SPREADSHEET CLOSED BEFORE SAVING | Excel Discussion (Misc queries) | |||
| Saving spreadsheet gives read only error message | Excel Discussion (Misc queries) | |||
| Excel 2003 spreadsheet saving prevented by violation error | Excel Discussion (Misc queries) | |||
| Copy From One Spreadsheet To Another Spreadsheet | Excel Discussion (Misc queries) | |||
| Spreadsheet merging problems | Excel Worksheet Functions | |||
Hybrid Mode
