| Type | Trick |
| Description | Delete only constants from the selection not formula. |
| Implementation | 1> Select range including Formulas. 2> Press F5 (Function Key) 3> Click on Special 4> Select Constants 5> Press Enter 6> Delete the selected cells or perform other operations e.g. colour format etc. |
| Additional Info / Attachment | |
Thursday, June 2, 2011
Tip-4
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment