how to select multiple text boxes in excel for formatting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rob - 26 Dec 2004 22:47 GMT

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?

Reply to this Message

Debra Dalgleish - 26 Dec 2004 22:52 GMT

To select multiple objects on the sheet --
Click on one object
Hold the Ctrl key, and click on additional objects

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
Select the Commands tab
Select the Drawing Category
Drag the 'Select Multiple Objects' tool onto one of your toolbars
Click Close

Then, click the Select Multiple Objects button, and select any or all
objects on the worksheet.

> 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?

Signature

Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Reply to this Message

Paul B - 26 Dec 2004 22:56 GMT

Rob, select one and hold down the Ctrl key and select the other ones

Signature

Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

Reply to this Message