how do you clear cells of data but not formula's. Rows or colunms or the whole spread sheet?

Dear @Denn Huess, 

Thank you for posting your question in the Microsoft Q&A forum.  

Based on my understanding, you want the cells where you manually enter numbers to be the part you want to delete. But the cells containing Formulas are the part you want to keep. Can you tell me if my understanding is correct? 

If that is correct, please help me with the following steps: Highlight the entire range where you want to clear data > Press F5 > Select Special > In the dialog box, select Constants (Purpose: The tool will only select cells containing manually entered values, not formulas.) > When you select Constants, you will see 4 sub-options: Text, Numbers, Logicals, and Errors. You will uncheck the data types you want to keep and check the data types you want to delete > Click OK. This action will uniquely select only the cells within your original selected range that contain non-formula data (constants). Finally, press the delete key on your keyboard. 

After uncheck "Text" > Only A1:B9 was chosen because it does not contain a formula. 

If there’s anything I may have misunderstood, I would truly appreciate it if you could provide a bit more detail to help me better understand your needs.

Looking forward to your response! 

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". 

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.