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

	98.1 % recommend us
	More live stats...

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

Training information:

Tables

Resolved · Low Priority · Version 2007

Reply Tue 10 Mar 2009, 15:22Delegate Jane said...

Jane has attended:
Excel Intermediate course
Word Intermediate course

Tables

what are tables in excel?

For upcoming training course dates see: Pricing & availability

Reply Tue 10 Mar 2009, 15:34Trainer Simon said...

RE: tables

Hi Jane,

When you have data arranged in columns with or without headings, you can apply Table Styles to the data.

Table styles include different formatting options for headings, rows and columns which format the background of the cells with different fill colours and different font colours.

The table style also includes a filter button for each heading so you can filter specific values from the column or sort the column of data.

I hope this answers your question.

Regards

Simon

Tue 17 Mar 2009: Automatically marked as resolved.

Excel articles

· How To Use Functions In Excel 2010
· How To Create An Argument With Excel
· Tap the Power of Recorded Macros with MS Excel Courses
· Microsoft Excel Training - Numerical excellence for all
· Excel: From The Basic To The Advanced

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

Excel tip:

Make a quick copy of a worksheet

Hold down the Ctrl key, then click and drag on a sheet tab to make a copy of that sheet. Though this process usefully copies the formats of the original sheet, note that any Range Names you have on the original sheet will be duplicated too.

To make a copy of a worksheet's contents and formats without duplicating range names: (1) Ensure that you have a blank worksheet to paste to. (2) On the sheet to copy, click on the sheet selection square to the left of Column A's heading to select the whole sheet. (2) Copy the whole sheet. (3) Paste to the blank worksheet.

View all Excel hints and tips