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)
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