Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a bunch of really old system manuals that need to be updated, but I can't for the life of me imagine opening each one up and applying the styles, ensuring font remains same, size color, etc.

I have a template saved (header and footer with logo, etc) and want to apply the standard header and footer across multiple documents.


share|improve this question
Do you hope to apply the same template to Word Documents and Excel files? I don't think that's possible. – pavium Dec 16 '09 at 12:09
the solution can be something arround VBA scripting, (ALT+F11 to get started) but how much files do you have ? – user8228 Dec 16 '09 at 15:50
Since I can't post an answer I'll just point out in a comment that you do not need to use the developer tab in Word 2010. You can instead do the following, go to: File | Options | Add-Ins | Manage: Templates | Go | Attach... | Choose the file | Check: Automatically update document styles | OK. Then you're done. – Håkon K. Olafsen Feb 3 at 18:38

From Quickly Formatting Multiple Documents for Word 2007 (I hope that for Excel it may be somewhat similar):

  1. Display the Developer tab of the ribbon and then click on the Document Template tool. Word displays the Templates and Add-Ins dialog box.
  2. Click on the Attach button. Word displays the Attach Template dialog box, which looks very much like a standard Open dialog box.
  3. Use the controls in the dialog box to locate and select the template you want attached to your document.
  4. Click on Open. The Attach Template dialog box disappears and the name of the template you selected appears in the Document Template box.
  5. Select the "Automatically Update Document Styles" check box to make sure that the styles in the template are applied to your document.
  6. 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.

For older versions of Word, please see the above article.

You'll still need to open each document in order to use the above method.

share|improve this answer
See the comment by @Håkon K. Olafsen on the original question for a way to do it without Developer tab – yosh m Mar 17 at 10:08

In Word 2010, you need to go to the Options dialog box, click the Customize Ribbon item and choose Developer tab on the right side. This displays the Developer tab.

I thought this was pretty obscure. Imagine having to go to the Developer tab to attach a template! It should be on the Page Layout tab.

share|improve this answer
Yes I've found the configuration of Word 2007 to be somewhat haphazard! – Jeb Apr 15 '13 at 14:27
See the comment by @Håkon K. Olafsen on the original question for a way to do it without Developer tab – yosh m Mar 17 at 10:07

You must log in to answer this question.

protected by Community May 28 '13 at 18:57

Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).

Would you like to answer one of these unanswered questions instead?

Not the answer you're looking for? Browse other questions tagged .