excel training courses - Formula

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

Resolved · Low Priority · Version Standard

Formula

Anna has attended:
Excel Intermediate course
Excel Advanced course

by - delegate Anna [2 posts] (2007 Jun 28 Thu, 12:43) Reply

How do i view the formula only?

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Oct 13 Mon + 14 Tue	Bayswater	0	FULL
2003	2008 Oct 23 Thu + 24 Fri	Southwark	0	FULL
2003	2008 Oct 30 Thu + 31 Fri	Bloomsbury	1	book now	£495	£495
2003	2008 Nov 3 Mon + 4 Tue	Bayswater	4	book now	£475	£485
2003	2008 Nov 17 Mon + 18 Tue	Southwark	5	book now	£450	£485
2003	2008 Nov 26 Wed + 27 Thu	Bloomsbury	6	book now	£450	£485
Full Schedule: See all 40 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: formula

by - trainer Tracy platinum contributer [586 posts] (2007 Jun 29 Fri, 10:32) Reply

Hi Anna,

Thanks for the question.

There are two ways, you can use the menu and go to Tools>Options>View tab and tick against the Formula box. Alternatively you can hold down the Control button and the button to the left of the number 1 on your keyboard and that will switch the formulas on or off.

Let me know if that works!!

Tracy

· How to check for and reduce errors in Microsoft Excel
· Customized Financial Excel Courses in London
· Microsoft Excel's Best Kept Secret
· Crazy Things People Have Done With Excel
· Microsoft Excel Cheat Sheet: Tips and Shortcuts