I am trying to change the default font from Arial to Calibri. I know there is a way to update the initial font for new books under "Options->General->When creating new workbooks" and this changes the default font to be applied but only when creating a new book or sheet.

However, I will often use other commands such as "Editing->Clear->Clear All/Clear All Formats" and cut and pasting (same thing as dragging blocks of cells around), and in both cases excel defaults to 10-pt Arial font with typical alignment options (text is left, numbers are right aligned).

I have not found any way to change what Excel auto updates the source cells to (where data had been, but was cut or cleared).

Does anyone else find this really annoying and have you been able to identify any options or variable that can be updated to make this work as one might expect?

Regards,