De Formatando rapidamente vários documentos para o Word 2007 (espero que para o Excel possa ser um pouco semelhante):
- Display the Developer tab of the ribbon and then click on the Document Template tool.
- In the Templates and Add-ins window, click on the Attach button.
- Use the controls in the Attach Template dialog box to locate and select the template you want attached to your document, then click Open.
- The Attach Template dialog box disappears and the name of the template you selected appears in the Document Template box.
- Select the Automatically Update Document Styles check box to make sure that the styles in the template are applied to your document.
- Click on OK.
If you don't see the Developer tab necessary for step 1, then you need to make the tab visible. You do that by clicking the Office button and then clicking the Word Options button. In the resulting Word Options dialog box, the Popular option should be selected at the left. Make sure the Show Developer Tab in Ribbon check box is selected and click OK.
Para versões mais antigas do Word, consulte o artigo acima.
Ainda será necessário abrir cada documento para usar o método acima.