Font formatting performance in Excel 2007 <p>I have macro which sets font for whole range to size 9:</p> <pre><code>Range("A1:Z20000").Font.Size = 9 </code></pre> <p>When I run it on Excel 2010 or 2013 it takes approximately 1 second to process (there's almost no formatting on range). But when I run it on Excel 2007 it takes 15+ seconds to process this single line of code. I couldn't find any article regarding this, but obviously MS fixed it in newer versions of Office (Excel). </p> <p>Is there a way to set font size for a big range (500,000+ cells) in Office 2007 without killing performance?</p>