Excel Tips Tutorial: How to Merge Styles and Themes of Old and New Excel Versions 2003 2007 2010 2013
How to Update Excel Files Created in Older Versions of Excel
Excel has updated the newer versions of Excel with new formatting options and default themes. For example, when Excel introduce the 2007 version they also introduced some new fonts styles that weren’t available in the 2003 or older versions. Excel has also updated the default themes. For example, in Excel 2003 the default font was 10 pt Arial, however the default font in Excel 2007, 2010 and 2013 is 11pt Calibri. Suppose you wanted to open an Excel file created in an older version of Excel but you wanted to update the theme to the default of the new Excel version. To do this simply follow the steps below.
Step 1: Open a new Excel workbook with the newest version of Excel.
Step 2: Now open the Excel file that was created with the older version. You will notice that even though you have opened the old Excel file in the new Excel version, the old formatting is still applied to the cells. This is what you are wanting to change.
Step 3: Click on the Home tab and in the Styles group click the Cell Styles command and view the Cell Styles drop-down menu. From the drop-down menu click on Merge Styles which is located at the very bottom of the menu. The Merge Styles dialog box will appear.
Step 4: In the Merge Styles dialog box select Book 1 and click OK. Now the Excel file that was created in an older version is updated with the default theme of the newer version.
NOTE: Any formatting that you created such as bold or italicized font will be removed. You will just have to add them back once you have merged styles.