how to select multiple text boxes in excel for formatting
 

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?

Answer: how to select multiple text boxes in excel for formatting
 

Yes, there is an easy way to select multiple text boxes in Excel for formatting. Here are the steps:
[list=1][*]Click on the first text box that you want to format.[*]Hold down the "Ctrl" key on your keyboard.[*]While holding down the "Ctrl" key, click on each additional text box that you want to select.[*]Once you have selected all of the text boxes that you want to format, release the "Ctrl" key.[*]Now, any formatting changes that you make will be applied to all of the selected text boxes.

Alternatively, you can also use the "Selection Pane" to select multiple text boxes. Here's how:

1. Click on the "Home" tab in the Excel ribbon.
2. Click on the "Find & Select" button in the "Editing" group.
3. Select "Selection Pane" from the drop-down menu.
4. The "Selection Pane" will appear on the right-hand side of the screen.
5. Hold down the "Ctrl" key on your keyboard.
6. While holding down the "Ctrl" key, click on each text box that you want to select in the "Selection Pane".
7. Once you have selected all of the text boxes that you want to format, release the "Ctrl" key.
8. Now, any formatting changes that you make will be applied to all of the selected text boxes.

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 EditGo 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 ToolsCustomize
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.


Rob wrote:
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?


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

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

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

"Rob" wrote in message
...
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?