Caption

[#1]

Hi all,

I am finished building some sheets to find out the caption lettertype is a little bit to big.

Is it possible to change all the captionlettertypes of the list boxes, pivot tables etc I created into a smaller lettertype at once?

kind regards

[alexandros17]

Right click on your sheet caprion and then in the menu list that appears select tabrow properties, then in fosnt choose the dimension

Hope it helps

[#3]

oh sorry I mean the captions of all my list boxes pivot ttables etc

[MK_QSL]

Like This ...

[MK_QSL]

You can create a theme on any one single list box and apply to all...

[alexandros17 · Accepted solution]

Go in Settings -> document properties -> fonts, select your font and dimension and click the button apply to all objects

[munna1317]

hi manish this will change only TAB name not all the objects in sheet

[munna1317]

hi alessandro saccone , this will effect inside front of sheet objects but not Header name

[#9]

indeed I see that now. Isn't it possible to change the header caption all the same time? Alot can be achieved with ctr+a but then i have to do that in every sheet

[munna1317]

hi alessandro saccone , ya Cntrl +A and we have to go for properties and font there we have to change the requirement