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

Tables

ResolvedVersion 2007

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

Jane has attended:
Excel Intermediate course
Word Intermediate course

Tables

what are tables in excel?

Tue 10 Mar 2009, 15:34 Trainer 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.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Quickly copy a formula across sheets

Suppose you have a formula in cell Sheet1!B2, say =A1*5%, that you wish to copy to cell B2 on Sheet2, Sheet3 and Sheet4. Instead of using copy and paste, try this: (1) Select Sheet1!B2. (2) Group Sheet1 with the worksheets Sheet2, Sheet3 and Sheet4 by holding down Ctrl and clicking on the tabs of the sheets to group them. (3) Press the F2 key, then immediately press Enter to copy the formula in Sheet1!B2 across the grouped sheets.

Remember to ungroup the sheets afterwards! Right-click on any tab and choose Ungroup Sheets to do that.

View all Excel hints and tips

Tables

Tables

RE: tables

Excel articles

Excel tip:

Quickly copy a formula across sheets