Auto font on Excel

Hi Emily, thanks for your query. A quick and simple fix on a standalone machine would be to go to the Office Button in Excel, Excel Options and then modifying the "When creating new workbooks" properties in the Popular category. This allows you to tweak basic properties like font on a new workbook, but anything else would require settings to be modified via a macro running on startup.

Implementing this company wide would almost certainly involve creating a template, refining properties according to your brand and style guide and then getting IT to upload the template on every machine using a batch file. This will implement branding going forward, but reformatting legacy documents would involve further modules of code. We can help with this, but it is a big project, so do drop us a line if you need further assistance.

Hope this helps,

Anthony