microsoft-excel-courses - excel

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft-excel-courses - Excel

microsoft-excel-courses - Excel

resolvedResolved · Low Priority · Version Standard

Christopher has attended:
Excel Introduction course
Excel Intermediate course
Excel Advanced course

Excel

Where is the Format Table in the Excel 2003?

RE: Excel

Hi Christopher

Thank you for your question.

In Excel 2003, to use the Table AutoFormat, select the data you wish to format; then go to Format - AutoFormat. Select the AutoFormat you wish to use and click OK.

I hope this helps.
Amanda


 

Excel tip:

Display Functions on Worksheets

Functions in Excel can be difficult to recall their format/syntax

For example, you want to use the =PMT function.

Enter =PMT, then select keystroke, CTRL+SHIFT+A.

This usful memory jog, will display the arguments of a function on a worksheet, allowing the user to proceed with the generation of the function



View all Excel hints and tips


Server loaded in 0.09 secs.