98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Formulas
Formulas
Resolved · Low Priority · Version 2007
Wed 1 Jul 2009, 15:55Delegate Marissa said...
Thu 2 Jul 2009, 10:05Trainer Amanda said...
RE: Formulas
Hello Marissa
Thank you for your question and welcome to the forum.
Formulas cannot be hidden without having protection applied to the spreadsheet, so if there are other cells in the spreadsheet that you want people to be able to change or edit, then those cells will need to be unlocked (using the same steps 1-4 below, but unchecking the 'Locked' box instead of ticking the 'Hidden' box) before protection is applied (steps 5-6).
1. Select the cells containing the formulas to be hidden.
2. Right-click on a selected cell, and choose the Format Cells option from the shortcut menu.
3. Select the Protection tab and tick the Hidden checkbox.
4. Click OK.
5. Go to the Review tab and click the Protect Sheet button, setting a password if desired.
6. Click OK.
Kind regards
Amanda
Wed 8 Jul 2009: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Calculate difference between two timesFor presenting the result in the standard time format (hours : minutes : seconds . Use the subtraction operator (-) to find the difference between times, and the TEXT function to format the returned value to text in a specific number format. |
