Select all cells (click the box above and to the left of cell A1) then
use Edit | Go To.... Special..., Constants, click OK, then hit
Delete. Note that this will also get rid of headers and labels, so if
you need to keep those, narrow done your initial selection to just
cells that you may want emptied.
MS Excel MVP
"HANKYPANK" <microsoft.com> wrote in message
in the cells?
want to delete the data in the cells, so I have a blank workbook, but
still have the formulas for the cells.