| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Removing data entries but not formulas or formats
How do I clear or remove data entries from a worksheet without removing
formulas or formats? The edit, clear content function removes the formulas? Thanks -- JD |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Removing data entries but not formulas or formats
Edit/Go To/Special/Constants
Delete key "JD" wrote: How do I clear or remove data entries from a worksheet without removing formulas or formats? The edit, clear content function removes the formulas? Thanks -- JD |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Removing data entries but not formulas or formats
Works Great.
Thanks Sean -- JD "Sean Timmons" wrote: Edit/Go To/Special/Constants Delete key "JD" wrote: How do I clear or remove data entries from a worksheet without removing formulas or formats? The edit, clear content function removes the formulas? Thanks -- JD |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Removing data entries but not formulas or formats
Thank you for the feedback!
"JD" wrote: Works Great. Thanks Sean -- JD "Sean Timmons" wrote: Edit/Go To/Special/Constants Delete key "JD" wrote: How do I clear or remove data entries from a worksheet without removing formulas or formats? The edit, clear content function removes the formulas? Thanks -- JD |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Removing duplicate entries | New Users to Excel | |||
| Removing duplicate entries | Excel Discussion (Misc queries) | |||
| Looking to copy a worksheet with all formats and formulas without coping inputed data | Excel Discussion (Misc queries) | |||
| Pasting data without removing formulas | Excel Discussion (Misc queries) | |||
| extend data range formats and formulas | Setting up and Configuration of Excel | |||
Linear Mode
