Monday, April 8, 2013

Delete number and retain formulas

I have to delete all the number and retain all the formulas in an excel sheet. How to do it?

A. Just follow the below steps:

Excel 2007 version
1. Select the data range; or Press Ctrl+A to select the entire sheet
2. Home tab >> Editing section >> Find & Select >> Constants >> Choose the constants you want to select >> example Numbers, Text etc.
3. Click Ok
4. Press Delete (to remove the selected constants)

No comments:

Post a Comment