Format an Excel table

Excel provides predefined table styles that you can use to quickly format a table. If the predefined table styles don't meet your needs, you can create and apply a custom table style. Tables include tools to help you analyze your data. However, you can remove table functionality for any table formatting that you apply and keep only the formatting.

Excel-tabel

Do any of the following:

Apply a table style to an existing table

  1. On the sheet, select the whole table that you want to apply a table style to.

  2. On the Tables tab, under Table Styles, click the style that you want.

    Fanen Tabeller i Excel, gruppen Tabeltypografier

    To see more styles, point to a style, and then click Nedadgående pil Mere .

    Bemærk: Table formatting doesn't automatically override existing cell formatting. If you have problems applying table styles, hold down CONTROL , click Table Styles, and then on the contextual menu, click Apply and Clear Formatting.

Shade alternating rows without table functionality

The easiest way to shade alternating rows is first to make them a table. Then you remove the additional table functionality and keep the formatting.

  1. On the sheet, select the rows that you want to shade.

    The cells can be empty or can contain data; if they contain data, the first row becomes the header row.

  2. On the Tables tab, under Table Styles, click the style that you want.

    Fanen Tabeller i Excel, gruppen Tabeltypografier

    To see more styles, point to a style, and then click Nedadgående pil Mere .

    Bemærk: Table formatting doesn't automatically override existing cell formatting. If you have problems applying table styles, hold down CONTROL , click Table Styles, and then on the contextual menu, click Apply and Clear Formatting.

  3. To remove the sort and filter arrows, on the Tables tab, under Tools, click Convert to Range, and then click Yes.

    Fanen Tabeller, gruppen Værktøjer

See also

Create or delete an Excel table

Rename an Excel table

Del Facebook Facebook Twitter Twitter Mail Mail

Var disse oplysninger nyttige?

Fantastisk! Har du mere feedback?

Hvordan kan vi forbedre det?

Tak for din feedback!

×