Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel course in london - Formula

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

excel course in london - Formula

Resolved · Low Priority · Version Standard

Reply Thu 19 Jul 2007, 14:37Delegate Martin said...

Martin has attended:
Excel Advanced course
Excel VBA Intro Intermediate course

Formula

How to use formula audit

For upcoming training course dates see: Pricing & availability

Reply Fri 20 Jul 2007, 06:37Trainer Tracy said...

RE: formula

Hi Martin,
There is a formula auditing toolbar, which shows where the values in your formula orginate from and which cells are affected by them. (Trace Dependants, Trace Precedence). There is also a Watch window where you can view the contents, formula and value of one cell by scrolling through others.

I hope that answers your question, if there was anything more specific please let me know.

Tracy

Excel articles

· How To Create Formulas In Excel
· That's The Wonder Of Autofill
· Why Excel Has More Cloud Coverage
· Excel Offers A More Relaxing Way To Work Out
· MS Excel: Excel At Making The Most Of Your Christmas

Excel tip:

Repeating headings on spreadsheets that print on more than one page

By default when you print a spreadsheet out and it prints on more than one page, the headings at the top and the side of the spreadsheet don't appear on all the pages following page 1.

To get Excel to repeat headings on all pages when printing, go to File - Page Setup - Sheet, then select the rows to repeat at the top of pages, and the columns to repeat at the side of pages by clicking on the red arrows at the right side of the two boxes under the 'Print titles' area. Then click OK.

If you view your spreadsheet in Print Preview, you should see the headings being repeated on each page.

View all Excel hints and tips