How to select multiple text box at a time in Microsoft Excel

[DEvOTeEL]

Sponsored Links

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.

[GALIENA]

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.

[DanielaA]

You can do that by Ctrl key. It is very easy. Just click on one Text box and then hold the Ctrl key from keyboard. Now you can scroll the page and keep clicking on text box you have. You can group them all to single object by right clicking on them and clicking on Group objects.