excel advanced - Formulas

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

Resolved · Low Priority · Version Standard

Formulas

Lisa has attended:
Excel Intermediate course

by - delegate Lisa [4 posts] (2007 Feb 8 Thu, 09:57) Reply

How do i view the formulas only?

Version	Date	Location	Places available	Book	Next place rate:
Excel Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2002/XP	2008 Sep 10 Wed	Tooting	0	FULL
2003	2008 Sep 10 Wed	Bloomsbury	5	book now	£219	£235
2003	2008 Sep 12 Fri	Southwark	5	book now	£219	£235
2003	2008 Sep 17 Wed	Southwark	0	FULL
2003	2008 Sep 17 Wed	Bayswater	5	book now	£195	£205
2003	2008 Sep 19 Fri	Bloomsbury	6	book now	£214	£230
Full Schedule: See all 125 Excel Advanced course dates. Bookings currently available until 24th November 2009.

RE: Formulas

by - trainer Tracy platinum contributer [586 posts] (2007 Feb 8 Thu, 10:54) Reply

Good morning Lisa,

To answer your question on viewing formulas:-

I can offer you two different options, one using the menu and mouse and the other using the keyboard.

If you go into the Tools menu and down to "Options" this will bring up a dialogue box and if you select the "View" tab at the top, then make sure the Formula box is ticked, this is near to the bottom of the box on the left hand side.

The other shortcut using the keyboard is to press the Ctrl button down and press the button to the left of the number 1 key. When these are held down you can toggle between formulas and numerical answers.

Good luck

Tracy

RE: Formulas

by - delegate Lisa [4 posts] (2007 Feb 8 Thu, 12:53) Reply

Thank you :-)

· How to Create Better Excel Spreadsheets: Part Two
· What's Better Than the Help Function in Excel? Microsoft Training
· Microsoft Excel's Best Kept Secret
· Creating Smarter, Customized Invoices for your Small Business with Microsoft Excel
· Advanced Excel Training - takes you to the next level

Excel tip:

Quickly copy a formula across sheets

Suppose you have a formula in cell Sheet1!B2, say =A1*5%, that you wish to copy to cell B2 on Sheet2, Sheet3 and Sheet4. Instead of using copy and paste, try this: (1) Select Sheet1!B2. (2) Group Sheet1 with the worksheets Sheet2, Sheet3 and Sheet4 by holding down Ctrl and clicking on the tabs of the sheets to group them. (3) Press the F2 key, then immediately press Enter to copy the formula in Sheet1!B2 across the grouped sheets.

Remember to ungroup the sheets afterwards! Right-click on any tab and choose Ungroup Sheets to do that.

View all Excel hints and tips