| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to copy an Excel worksheet with formulas and clear contents.
I have worksheets from 2007 that I want to copy and use for 2008. Everything
I tried to clear just the contents for the year also removes the formulas which I want to keep. Help!!! Sue |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to copy an Excel worksheet with formulas and clear contents.
Select the cells
F5Special Contants press the delete button -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Compeer buddy" wrote in message ... I have worksheets from 2007 that I want to copy and use for 2008. Everything I tried to clear just the contents for the year also removes the formulas which I want to keep. Help!!! Sue |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to copy an Excel worksheet with formulas and clear contents.
hi
hit the F5 key. click the special button. check constants. click ok this will high light all of your non formula cells. hit the delete key. your data should be gone and your formula still there. regards FSt1 "Compeer buddy" wrote: I have worksheets from 2007 that I want to copy and use for 2008. Everything I tried to clear just the contents for the year also removes the formulas which I want to keep. Help!!! Sue |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Clear contents, keep formulas | Excel Discussion (Misc queries) | |||
| How do I clear contents from a spreadsheet but not the formulas | Excel Discussion (Misc queries) | |||
| Formulas to copy contents of one cell in a worksheet to another ce | Excel Discussion (Misc queries) | |||
| excel command to clear contents except 2 formulas | Excel Discussion (Misc queries) | |||
| Clear contents but leave formulas in Excel | New Users to Excel | |||
Linear Mode
