Forum home » Delegate support and help forum » Microsoft Excel Training and help » Tables

	98.1 % recommend us
	More live stats...

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

Training information:

Tables

Resolved · Low Priority · Version 2003

Reply Fri 9 May 2008, 09:16Delegate Helen said...

Helen has attended:
Excel Advanced course

Tables

How do I present tables nicely

For upcoming training course dates see: Pricing & availability

Reply Mon 12 May 2008, 00:58Trainer Tracy said...

RE: Tables

Hi Helen,

I suggest you use any of the options in your formatting toolbar. An even easier way is to use the Autoformat option. Make sure your active cell is in the table, go to Format menu and AutoFormat then take your pick.

Good luck

Tracy

Excel articles

· Features of Microsoft Excel that assist in Analysis of Financial Data
· Preparing to Pivot: Why all Excel users should know about Pivot Tables
· Improve Performance Of Your Excel Macros
· 3 Reasons why Your Small Business Office Needs Microsoft Excel Training
· So Can You Really Sort On Colours In Excel 2007?

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

Excel tip:

Pivot table grouping

If you want to group items in a pivot table together, simply highlight the labels for the fields either with the shift key (if adjacent)or with the contral key if they are not next to each other.
Right click and choose group. Give the cell a name.

When you double click on this cell it will either expamd or collapse your grouped area

View all Excel hints and tips

All prices offered for business users and exclude VAT. E&OE · Terms & conditions · Privacy policy