I took over an Excel workbook from a colleague who had it formatted by default to 12 points.
I have made sure that in Tools/Options/General 10points is listed and have formatted the 5 sheets so they are 10 points.
However, when I copy data from a 10 point sheet and paste into my 10 point formatted page it arrives as 12 points and has to be reduced.
If I do a Paste Special/Values then it does go in as 10 points.
There is an underlying "12 points" default that I would like to reduce to 10 points. This is also shown by the fact that Insert/New Sheet brings it in as 12 points and any text box that is applied has 12 point text as default.
Would welcome suggestions as how to get the workbook to a "genuine" 10points.
Tony Beckett - Rutland, UK