| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003. Re-use a spreadsheet?
I want to delete all the data but keep the formulas. I made a copy of the
original workbook and cleared the data but now I have no formulas. What did I do wrong? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2003. Re-use a spreadsheet?
hi
not sure how you cleared the data but you may have deleted the formulas too. try this...... make a copy of the original workbook again. in the new copy, hit the f5 key to bring up the goto dialog. click the special button at the bottom. on the special go special dailog, click contraints the ok. all non formula data should be high lighted. delete. data should be gone. formulas remain. Regards FSt1 "MollyO" wrote: I want to delete all the data but keep the formulas. I made a copy of the original workbook and cleared the data but now I have no formulas. What did I do wrong? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2003. Re-use a spreadsheet?
Great! Thanks for the replies. I will attempt this soon and see how it goes.
Molly "Roger Govier" wrote: Hi Molly You should have pressed F5SpecialConstantsOKDelete -- Regards Roger Govier "MollyO" wrote in message ... I want to delete all the data but keep the formulas. I made a copy of the original workbook and cleared the data but now I have no formulas. What did I do wrong? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003: Copying Spreadsheet | Excel Discussion (Misc queries) | |||
| How do I highlight changes to an Excel 2003 spreadsheet? | Excel Discussion (Misc queries) | |||
| I can not see colors in my spreadsheet when using Excel 2003 | Setting up and Configuration of Excel | |||
| Spreadsheet sticking in Excel 2003 | Excel Worksheet Functions | |||
| Excel 2003, cannot save a spreadsheet.xls | Excel Discussion (Misc queries) | |||
Linear Mode
