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

[aveeeeeee7en]

Hi Vincent

There are 2 ways:

1) Go on particular Sheet & Select all Sheet Objects by Doing Cntrl+A. After that Right Click on Any of the chart and go to Caption> Click on Font > Change the Size as per your requirement.

See the Image for it.

2) Before creating any chart if you make the same captions for every sheet make changes in the Document Settings.

Press Cntrl+Alt+D > Go to Captions Tab > Change the Font Size

Do remember to Check the Show Caption Box present in Sheet Properties - Caption Tab.

Regards

Aviral Nag

[munna1317]

hi guys thxs for discuss