This does not get you all the way there, but
Format the first then selct the second and press Ctrl+Y to repeat your
previous format, Selecet the third, Ctrl+Y and so on.
At least saves you the repeat formatting process,

On 19 Feb 2006 06:31:23 -0800, "
wrote:

Hi there,

Have about 10 bubbles here. Need to format data labels of ALL 10
bubbles at the same time. (I wanna select Alignment label position
center, that means moving all 10 data labels to the center of the
bubbles)

Any method that i can do it in one go, without the need to select and
format it one by one ?

Am using excel 2002.

Thanks.