Showing Formulas

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

Resolved · Low Priority · Version Standard

Showing Formulas

Astrid has attended:
Excel Advanced course
Excel Intermediate course

by - delegate Astrid [3 posts] (2008 Mar 7 Fri, 15:40) Reply

How do you show all formulas?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 2 Tue	Bloomsbury	3	book now	£210	£215
2003	2008 Sep 4 Thu	Bayswater	4	book now	£195	£205
2007	2008 Sep 4 Thu	Bloomsbury	0	FULL
2003	2008 Sep 9 Tue	Bloomsbury	4	book now	£207	£215
2002/XP	2008 Sep 9 Tue	Tooting	0	FULL
2003	2008 Sep 11 Thu	Southwark	4	book now	£207	£215
Full Schedule: See all 137 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Showing Formulas

by - trainer Rich platinum contributer [711 posts] (2008 Mar 9 Sun, 11:10) Reply

Open the sheet. Hold the control key down and press the key above the tab key on the top left side of your keyboard, its under the escape key, just before the 1. All formulas should be shown

· Advanced level training: Microsoft Excel and the Web
· 3 Reasons why Your Small Business Office Needs Microsoft Excel Training
· Microsoft Excel Training: Not Just for Newbies Anymore
· Fun Things I've Done With Excel
· Microsoft Excel's Best Kept Secret

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

Excel tip:

Quickly insert a function

In Excel 97 and 2000 it was known as the Paste Function dialog box, these days it's known as the Insert Function dialog box. Regardless, one has to choose Insert|Function. or the fx button to open it up. There is, however, a non-mousey way to get hold of the Insert Function dialog box: press Shift+F3 in a blank cell to open the Insert Function dialog.

Press Shift+F3 after a function name and open bracket to open the Function Arguments dialog. For example, type =VLOOKUP( into a cell and press Shift+F3 to obtain a detailed description of VLOOKUP's arguments.

View all Excel hints and tips