COMPUTERS & TECHNOLOGY

Save Word configuration and default font

Microsoft Office may be more customisable than you think. Did you know it is possible to save your favourite settings and font styles to avoid time and frustration? You can also back up your preferences to restore them on new machines.

How to modify Default Font and Style using Office 2007-2013

  1. Create a new office document, spreadsheet etc. Click on File > New or File > New Office Document.
  2. On Home tab, in the Style section, right-click the Normal box, and select Modify.
  3. In the Modify Style dialog box, choose your preferred font and size.
  4. Tick the box "Add to template" and then click OK.

The 'Normal' template is saved in a template file called normal.dotm (or .dotx) in Office 2007-2013 or normal.dot in Word 97-2003. If this template file somehow disappears, all Office applications will create a new normal.dotx or normal.dot with Microsoft's default settings.

What this means is you need to make sure your Template folder is regularly backed up. To get there, click the Start button or go to the Windows 8 Search charm, type %appdata%\microsoft\templates, and select the folder that appears.

How to save and restore Ribbon and Quick Access Bar in Office 2010-2013 or Office 365

Click on File (or Office button) then Options in each application (Excel, Word, etc) and select Customize Ribbon or Quick Access Toolbar. Select Import/Export in the lower right hand corner and export all your customisations in one file to a safe place. Ensure you keep the default .exportedUI extension to the file, so you can import that file on a new computer.

Backup all your application settings

It is good practise to back up the entire %appdata% folder, which is probably C:\Users\yourname\AppData. We need to backup the whole folder, because Microsoft Office saves its customisations in many of its sub-folders.

Quick Parts (also called AutoText) preferences are found in the %appdata%\microsoft\document building blocks folder (include all the numbered sub-folders).

Your Autocorrect settings are found in a file with an .acl extension inside %appdata%\microsoft\office. Backup all the .acl files located there.

Copying all the data in those two other folders to the same location on a new machine will restore these other customisations.

<< What have you both hoped for?
Local area natives >>