Formulas

The UK's most regular instructor-led training courses.
Training information: advanced excel ms training · Excel courses · Microsoft Excel Training London
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version 2007

1 post

ReplyWed 1 Jul 2009, 15:55Delegate Marissa said...

Marissa has attended:
Excel Intermediate course

Formulas

How do you hide a formula within a cell?

Version	Date	Location	Places available	Book	Next place rate (£)
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2007	Fri 19 Mar 2010	Bloomsbury	0	FULL
2003	Wed 24 Mar 2010	Limehouse	7		£212	£217
2007	Fri 26 Mar 2010	Rochester (Hoo)	0	FULL
2007	Mon 29 Mar 2010	Bloomsbury	3		£235	£240
2003	Wed 31 Mar 2010	Southwark	7		£219	£224
2007	Tue 6 Apr 2010	Limehouse	5		£235	£240
Full Schedule: See all 70 Excel Advanced course dates. Bookings currently available until 22nd December 2010.

2,024 posts

ReplyThu 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.

· Data Basics Using Excel
· How Teachers Are Using Microsoft Excel To Enhance Learning in the Classroom
· Let Excel look after the pennies, and the pounds will take care of themselves
· How Many Different Ways Can You Sum In Excel 2007?
· Customized Financial Excel Courses in London

Please browse our web site to find out more about
advanced excel ms training and other Microsoft training courses.