How to format multiple text boxes in excel

[Raju Chacha]

I am trying to select multiple text boxes for formatting the font but seem unable to select all of them other than to click on each one individually. Is there an easy way to select all of the text boxes at once? If you guys have any ideas or suggestions then please do the reply, any of the reply will be thanks.

[GALIENA]

To select multiple objects on the sheet, Click on one object Hold the Ctrl key, and click on additional objects and To select all the objects on the sheet Choose Edit>Go To, click Special Select Objects, click OK or to work with specific objects, you can add the 'Select Multiple Objects' tool to one of your toolbars: Choose Tools>Customize and Select the Commands tab and then Select the Drawing Category Drag the 'Select Multiple Objects' tool onto one of your toolbars and then Click Close Then, click the Select Multiple Objects button, and select any or all objects on the worksheet.