| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fix/Freeze a spreadsheet
In Supercalc, I could save a spreadsheet as 'values'.
Formulae relating cells no longer operated. The spreadsheet became 'dead'! How do I do the same thing in Excel? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Fix/Freeze a spreadsheet
Select the cells you want to remove the formulas from, (the whole sheet if
you wish). Right click 'Copy'. Right click again, 'Paste Special' check 'Values' OK. Regards, Alan. "alphamnemonic" wrote in message ... In Supercalc, I could save a spreadsheet as 'values'. Formulae relating cells no longer operated. The spreadsheet became 'dead'! How do I do the same thing in Excel? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Fix/Freeze a spreadsheet
CopyPaste SpecialValuesOKEsc.
Then save. Gord Dibben MS Excel MVP On Thu, 10 Apr 2008 15:45:01 -0700, alphamnemonic wrote: In Supercalc, I could save a spreadsheet as 'values'. Formulae relating cells no longer operated. The spreadsheet became 'dead'! How do I do the same thing in Excel? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Fix/Freeze a spreadsheet
"Alan" wrote: Select the cells you want to remove the formulas from, (the whole sheet if you wish). Right click 'Copy'. Right click again, 'Paste Special' check 'Values' OK. Regards, Alan. "alphamnemonic" wrote in message ... In Supercalc, I could save a spreadsheet as 'values'. Formulae relating cells no longer operated. The spreadsheet became 'dead'! How do I do the same thing in Excel? I hope my 'thank-you' sent on the day of receipt of your solution got through to you. Your solution was exactly what I needed, and such was the number of problems solved by that solution that you instantly became 'God in my Universe'...!!! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Fix/Freeze a spreadsheet
"Gord Dibben" wrote: CopyPaste SpecialValuesOKEsc. Then save. Gord Dibben MS Excel MVP Gord - Thank you for your excellent solution. Alan got in first, and as such, inevitably gets the prime credit! I didn't see your post until today... Thank you, again. What is perhaps very simple and/or obvious to you is FAR from being such to the likes of me! On Thu, 10 Apr 2008 15:45:01 -0700, alphamnemonic wrote: In Supercalc, I could save a spreadsheet as 'values'. Formulae relating cells no longer operated. The spreadsheet became 'dead'! How do I do the same thing in Excel? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 freeze panes won't freeze top row only | Excel Discussion (Misc queries) | |||
| Can I freeze BOTH a column and a row in the same spreadsheet? | Excel Discussion (Misc queries) | |||
| How do I freeze the top and side of a spreadsheet? | Excel Discussion (Misc queries) | |||
| How do I freeze data in the spreadsheet so no one can change it? | Excel Discussion (Misc queries) | |||
| Large Spreadsheet - Freeze On Recalculate | Excel Worksheet Functions | |||
Linear Mode
