Delete Only Number From Excel Cells


Do you need to clear just the numbers from your Excel worksheet?. I know I do this regularly if I have a worksheet I want to re -use for example a generic input form and I want to keep all of the text and formulas intact.

I have found the quickest way to delete just the numbers form my Excel cells is to use the GoTo Special Command. This is found under the Find and Select button on the Home Tab ( Excel 2007-10).

All you need to do next is select Constants and un-check everything EXCEPT the numbers option.

After that just hit the Delete key to remove the values.

 

Job done!.

 

 

 

 

 

 

Other Excel Tips You Might Like

1. Awesome Excel shortcut -Can you draw cells borders as quick as this?

2. Easily edit Excel formulas in a dialog box

3. Create an Excel table- A Tutorial

4. Fast Fun Formulas

Barbara

Barbara is an experienced data analyst with over 20 years of experience. Author of the How To Excel At Excel Top 50 Excel tips Ebook, YouTuber and Excel Blogger.

Recent Posts