Changing font size of pivot table

[Anonymous]

Hi all,

I have a requirement which i need to change the font  size of dimension and expression in pivot table . please help me out

Thanks

[mightyqlikers]

Go To properties

-> Font Tab

set the font size of what ever you want.

Regards

Samwise

[Anonymous]

I have tried .its not working

Thanks

[Anonymous]

Hi

i have a pivot table in which i would like to change the font size of both dimensions ,expressions and data as one font size .Hope you understand my requirement

Thanks

[mightyqlikers]

Please share your application

[aveeeeeee7en]

Hi

Try using Custom Format Cells.

Regards

Av7eN

[aveeeeeee7en]

Hi

See the below Snapshot:

Regards

Av7eN

[#8]

Hi,

Try the following steps :

  1. Go to setting -> User preference -> Design -> check the 'Always show the design menu options'

2. Now Right Click on your Pivot table dimension and choose 'Custom Format Cell'

3. Now u play around with the available features.(Change text color,background,text size for dimensions)

Hope this will help!!

Regards

Lathaa

[Anonymous]

Hi Latha ,

Your solution was helpful  but my exact requirement is i want to make my expression labels or Field names to set in bold .

Hope you understand my requirement

Thanks

[#10 · Accepted solution]

Right click on one of the field value. choose - custom format cells and check in Bold .

Regards

Lathaa