Press the "Office" button in the top left-hand corner of the application and select "Excel Options" to open the Popular tab in Excel to switch the character set for all subsequent Excel workbooks.

Tips More complex default value setting requires Excel Macro scripts to be written, for example, setting a different default value depending on the value of other columns in the spreadsheet.