| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting the DATA but NOT the Formulae!
Folks ---
I have a spreadsheet that got -- to understate the matter, delicately -- the wrong data pasted into it. I need to delete JUST the numbers, but leave the recalculation logic in place. How does one do this? Thankx in advance from the Big Gray Cat. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Deleting the DATA but NOT the Formulae!
Press F5
Click on Special Check the Constants option Click Ok Press Delete "Big Gray Cat" wrote: Folks --- I have a spreadsheet that got -- to understate the matter, delicately -- the wrong data pasted into it. I need to delete JUST the numbers, but leave the recalculation logic in place. How does one do this? Thankx in advance from the Big Gray Cat. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formulae: Paste value formulae after doing an average operation | Excel Discussion (Misc queries) | |||
| How to delete cell values withour deleting cell formulae | Excel Discussion (Misc queries) | |||
| Deleting cell data without deleting formula | Excel Discussion (Misc queries) | |||
| protect cells in excel to prevent users from deleting formulae | Excel Discussion (Misc queries) | |||
| Searching TEXT in formulae, rather than results of formulae | Excel Worksheet Functions | |||
![Big Gray Cat[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
