excel computer course london - Formulas

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

Resolved · Low Priority · Version Standard

Formulas

Lan has attended:
Excel Intermediate course
Powerpoint Intermediate Advanced course

by - delegate Lan [5 posts] (2007 Nov 13 Tue, 17:11) Reply

how do i display formulas in cells as opposied to the fomula bar

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2009 Jan 8 Thu + 9 Fri	Bloomsbury	4	book now	£485	£490
2003	2009 Jan 22 Thu + 23 Fri	Southwark	0	FULL
2003	2009 Jan 29 Thu + 30 Fri	Bayswater	4	book now	£475	£485
2007	2009 Feb 5 Thu + 6 Fri	Bloomsbury	5	book now	£485	£490
2003	2009 Feb 19 Thu + 20 Fri	Southwark	6	book now	£450	£485
2003	2009 Feb 26 Thu + 27 Fri	Bayswater	8	book now	£335	£365
Full Schedule: See all 44 Excel VBA course dates. Bookings currently available until 18th March 2010.

RE: Formulas

by - trainer Pete platinum contributer [867 posts] (2007 Nov 14 Wed, 09:25) Reply

Hi Lan, Thank you for your post, I hope you have enjoyed the courses that you have attended with Best Training. In answer to your question.
To display all formulas in a Worksheet you can use the toggle button combination (Toggle on and off) CTRL+Pipe key (the pipe key is found immediatly above the Tab key next to the number 1 key.)
If you just want to display the formula in the selected cell then try a double click on the cell, this will open the cell in Edit mode and display the formula. Hope that answers your post, Pete.

· Basic Excel Training
· 3 Ways that MS Excel Courses Can Drastically Improve Productivity for Teachers
· Microsoft Excel Training Course
· Tips for Transitioning to Excel 2007
· Reporting and Analysis with Excel