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 » Formulas

	98.1 % recommend us
	More live stats...

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

Training information:

Formulas

Resolved · Low Priority · Version 2003

Reply Thu 4 Jun 2009, 15:53Delegate Sue said...

Sue has attended:
Excel Introduction course
Excel Intermediate course

Formulas

where do I find the formula bar

For upcoming training course dates see: Pricing & availability

Reply Fri 5 Jun 2009, 13:55Trainer Rajeev said...

RE: formulas

Dear Sue

Thank you for attending Excel 2007 Intermediate course!! I hope you enjoyed the course and benefited from it.

The Formula bar is the long white bar situated just above the Column letters.

If some one has hidden it then you can choose View tab on the Ribbon and then on the Show/hide group tick the Formula bar option.

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT

Fri 12 Jun 2009: Automatically marked as resolved.

Excel articles

· What's In A Number? Make Figures Mean More Via Excel
· Tracking In Excel 2003
· Tell AutoFill What To Do And It Will Oblige
· Using Find And Replace In Excel
· Microsoft Excel Cheat Sheet: Tips and Shortcuts

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

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