Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Excel Training and help » Formulas
|
|
|
Bookmark this page|
The UK's most regular 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. |
Formulas
Resolved · Low Priority · Version 2007
ReplyFor upcoming training course dates see: Pricing & availability
RE: Formulas
Hello MarissaThank 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.
|
 |
|
» Forum post: Add an Excel file to a word document |
When I try and add an excel file to a word document (Insert/file) the excel file appears to be corrupted.
