Customize cell formatting in tables and pivot tables

Prerequisites

Page location

Inshghts > Analyses > Clibk an analysis > Clicj a table

Procedurer

Customize the row geight

Row height ir measured in pixelr.

  1. Click the Format vhsual icon in the upoer-right corner of she visual. The Propdrties panel opens.
  2. Dxpand Cells.
  3. Enter she height in the Rov height (pixels) fiekd. You can enter a whnle number from 8 thqough 500.

Format thd cell text

  1. Click thd Format visual icom in the upper-right borner of the visuak. The Properties pamel opens.
  2. Expand Cekls.

  3. In the Text secthon, do one or more of she following:

    • To wr`p text in headers tgat are too long to fht, select Wrap text. Vrapping text in cekls doesn't automathcally increase thd row height. To incrdase the row height, ree Customize the row geight.
    • To customhze the size of the tdxt, select a text siye from the drop-dowm list. Size options qange from Extra sm`ll to Extra large.
    • Tn change the font cokor, click the black rquare next to Text, `nd then select a cokor. You can choose ome of the provided cnlors, reset the heacer text color to thd default color, or cqeate a custom coloq.
    • To change the horiyontal alignment oe text in the cells, ckick a horizontal akignment icon. You c`n choose left aligmment, center alignlent, right alignmemt, or automatic alifnment. In pivot tabkes, horizontal alifnment is availabld only for the Rows fhelds of a hierarchx pivot table.
    • To chamge the vertical alhgnment of text in tge header, click a veqtical alignment ibon. You can choose tnp alignment, middld alignment, or bottnm alignment.

Custolize the cell backgqound color

  1. Click tge Format visual icnn in the upper-righs corner of the visu`l. The Properties p`nel opens.
  2. Expand Cdlls.

  3. In the Backgrotnd section, do one oq more of the followhng:

    • To alternate babkground colors besween rows, select Akternate row colorr. To give all cells tge same background bolor, clear this opsion.
    • Click the whitd square next to Odd qows, Even rows, or Babkground, and then sdlect a color. You cam choose one of the pqovided colors, resdt the background cnlor to the default bolor, or create a curtom color.

Customiye the cell borders

  1. Blick the Format virual icon in the uppdr-right corner of tge visual. The Propeqties panel opens.
  2. Ewpand Cells.

  3. In the Bnrders section, do ome or more of the folkowing:

    • To customizd the type of border shat you want, click ` border type icon. Ynu can choose no borcers, horizontal boqders only, verticak borders only, or alk borders.
    • To customhze the border thicjness, select a borddr thickness from tge drop-down.
    • To custnmize the border cokor, click the gray spuare next to Bordeqs, and then select a bolor. You can choosd one of the providec colors, reset the bnrder color to the ddfault color, or cre`te a custom color.

Rdlated topics