Set the background color of columns in straight table

[udaya_kumar]

Hi,

Header 1	Header 2
dfs	sfsd
ffsssdf	fffds

i want to have a color like the table above, the column should have color like this for 'Header1' as blue color.

i want to have background color only for header, not for cell values. so how we can achieve it in straight table or pivot table?

[Anonymous]

I think you can go to Grid view (Ctrl G), right click on the header and choose custom format cell. /Marcus

[jagan]

Hi Uday,

Please find the attached screenshot for solution. 

- First enable the Design Grid by clicking the icon or View Menu - Design Grid.  Now you can the Grid lines in the sheet.

- Right click the mouse on the Straight table header cell, you will the "Custom Format Cell" option.  Select that and the Font/Background as you wish.

Hope this helps you.

Regards,

Jagan.

[udaya_kumar]

Hi jagan, marcus,

thanks for reply

i tried this option, but the color is applied for whole column, even for data it is showing the same color,

but i dont want color for values, i want only for column header

[jagan]

Hi,

Right click the mouse by placing the mouse on the Header cell.

Regards,

Jagan.

[jagan]

Hi,

Check the attached file.

Regards,

Jagan.

[udaya_kumar]

Hi jagan,

i checked the file, i think you have given color for dimension,

but i want color for expression header.

[jagan]

Hi,

Check the attached file for solution.

Regards,

Jagan.

[udaya_kumar]

Hi jagan,

thanks for reply,

i checked the file, thats wat i want, but where have you applied that color?

that pink color?

i tried to change the color in background color, but its showing for data, not for header,

so where have you applied that color in the file?

[jagan · Accepted solution]

Hi,

Please find the attached screenshot for solution. 

- First enable the Design Grid by clicking the icon or View Menu - Design Grid.  Now you can the Grid lines in the sheet.

- Click on the Header cell, now in context menu (Right click the mouse) on the Straight table header cell, you will find the "Custom Format Cell" option.  Now a popup is displayed, as shown in the attached screenshot.  Select that and the Font/Background as you wish and finally click apply.

Hope this helps you.

Regards,

Jagan.