How to format multiple text boxes in excel

How to format multiple text boxes in excel
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.
Reply With Quote
#2
Old 07-01-2012
GALIENA GALIENA is offline
Member

Join Date: Jun 2011
Posts: 437
Re: How to format multiple text boxes in excel
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.
Reply With Quote

If you like this post then consider sharing it with others.