| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to delete datas without deleting formulas
Dear Excel Experts,
I would like to select a full sheet and only delete datas from it without touching the formulas. Please help. Regards, Exel Dubai |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to delete datas without deleting formulas
You sure?
I would think that there would be headings/instructions--cells with values that you don't want to touch. But if you select your range to clear (all cells if you really want) edit|goto|special Select constants and click ok then hit the delete key on the keyboard. Excel Dubai wrote: Dear Excel Experts, I would like to select a full sheet and only delete datas from it without touching the formulas. Please help. Regards, Exel Dubai -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to delete datas without deleting formulas
Thanks a lot Dave !
I have tried it and it is working fine. Regards, Excel Dubai "Dave Peterson" wrote: You sure? I would think that there would be headings/instructions--cells with values that you don't want to touch. But if you select your range to clear (all cells if you really want) edit|goto|special Select constants and click ok then hit the delete key on the keyboard. Excel Dubai wrote: Dear Excel Experts, I would like to select a full sheet and only delete datas from it without touching the formulas. Please help. Regards, Exel Dubai -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| line appears when deleting chart- cannot delete it | Excel Worksheet Functions | |||
| I can't delete a cell without deleting a row | Excel Discussion (Misc queries) | |||
| deleting values in a worksheet without deleting the formulas | Excel Worksheet Functions | |||
| how do I delete numbers without deleting formulas | Excel Discussion (Misc queries) | |||
| delete values in several cells without deleting the formulas | Excel Discussion (Misc queries) | |||
![Excel Dubai[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
