Hi
- select your data range
- hit F5, click 'Special' and choose 'Constants'
- now hit the DEL key
--
Regards
Frank Kabel
Frankfurt, Germany
"DarrellK" schrieb im Newsbeitrag
...
I use Excel 2003. I track mothly sales data. Each month I add a new
worksheet, I want to transfer the borders, column widths, formats,
and
fomulas only, but I want to delete the previous month's data so I can
fill in
the data as the new month progresses. I can "special paste" but
everything
transfers. How Can I delete ONLY the enterd data on a whole worksheet
while
preserving the formats, formulas, etc.
TIA
|