| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Clearing Contents
How can I highlight and clear contents but not formulas
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Clearing Contents
Hi,
Select the range you want to clean up--include as many formula cells as you want. Then edit|goto|special check Constants click ok hit the delete key on the keyboard. (You may have constants that you want to keep--headers/descriptions/instructions.) "AMANDA" wrote: How can I highlight and clear contents but not formulas |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Clearing Contents
Hi Amanda
Press F5 from worksheet. From Goto window select Constants. Select the option you needed. Hit OK to select all cells. Press delete key,. If this post helps click Yes --------------- Jacob Skaria "AMANDA" wrote: How can I highlight and clear contents but not formulas |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro for clearing cell contents | Excel Discussion (Misc queries) | |||
| Clearing contents not formatting | Excel Discussion (Misc queries) | |||
| Selectively Clearing cell contents | Excel Worksheet Functions | |||
| Clearing Contents of Cell | Excel Worksheet Functions | |||
| Clearing Contents but not Formulas | Excel Worksheet Functions | |||
Linear Mode
