Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Keeping Formulas!!!
- Thread starter jatolo
- Start date
Can you explain what data you want to delete? If it's constants entered in a certain range, then select the range that includes the data, do Edit/Goto/Special/Constants and then hit the Delete key.
As for hiding formulae, you can format cells to be locked and hidden ( Format/Cells/Protection ) before protecting the sheet ( Tools/Protection/Protect sheet ). Remember to format any input cells as unprotected before protecting the sheet itself.
Cheers, Glenn.
Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.
As for hiding formulae, you can format cells to be locked and hidden ( Format/Cells/Protection ) before protecting the sheet ( Tools/Protection/Protect sheet ). Remember to format any input cells as unprotected before protecting the sheet itself.
Cheers, Glenn.
Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.
- Status
Similar threads
- Locked
- Question
- Locked
- Question