Thread: how to clear data
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
  
Posts: 9,221
Default how to clear data
Select all* the ranges (hold down CTRL to select discontiguous ranges)
Then press F5 Special Check "Constants" OK
This will focus it only on cells with data. Press Delete key to clear at one
go.

*In selecting the ranges, try as far as possible to exclude text labels, col
headers etc ie data that you want to retain
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:17,800 Files:359 Subscribers:56
xdemechanik
---
"chrisk" wrote:
How can I clear data from a worksheet with out erasing the formulas?
I want to reuse last years sheet for this year. So how can I clear the data
with out erasing the formula?
Reply With QuoteReply With Quote