Change Microsoft Excel Workbook Default Font Forcibly


Microsoft Excel gives an option to change the default font for the new workbooks created after (check here), but it does not effect to the current workbook.

If you have an Excel workbook that you want to change the default font, you can manually select all cells and change the font you want. But, if you create new worksheets, the font will be the old one.

Microsoft Office Open XML Workbook (*.xlsx), the default file type in Microsoft Office Excel 2007 and above, actually is an zip document with extension *.xlsx extension. The file contains many files (most of *.xml) that representing spreadsheets. (see here)

Fortunately, because of the file format, we can change the default font forcibly. You can follow the instruction bellow (assume: you familiar with XML file).

Image

  1. Save and close your Excel (*.xlsx) workbook.
  2. Using compression tool (like 7zip, WinRAR, etc.) to extract the *.xlsx file.
    If you use 7zip, you can right click on your *.xlsx file in Windows Explorer, and then select 7-Zip | Extract files….
  3. Open the directory where the file has just been extracted.
  4. Go to xl directory, and open styles.xml files using your text editor.

    ChangeFontExcel-2

  5. Find the <fonts> tags. You will be find there is an (maybe more than one)  <font> tags.
    <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
    <styleSheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" mc:Ignorable="x14ac" xmlns:x14ac="http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac">
        <fonts count="1" x14ac:knownFonts="1">
            <font>
                <sz val="14" />
                <color theme="1" />
                <name val="Arial" />
                <family val="2" />
            </font>
    	<!-- other fonts -->
        </fonts>
        <!-- other style parameters -->
    </styleSheet>
    
  6. You can edit the value of <name /> and <sz /> tags for font name and size.
  7. Save the styles.xml.
  8. Compress the directory to zip file format, and rename the file extension to *.xlsx.

ChangeFontExcel-7

Your Excel workbook’s default font will be changed.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s