0
1
I'm using Microsoft Excel for Mac 2011 and by default, a new spreadsheet has a font size of 12 for cells. On a 4k screen resolution, font size 12 is a bit small, so I have selected the whole spreadsheet and updated every cell to now be font 16, however, whenever I paste a hyperlink, the font size on the cell becomes 12. Similarly, whenever I apply the preset format from the ribbon for Green background "Good" it also becomes font size 12.
How can I change the default font size for this spreadsheet to be 16? Similarly, is there a way to change the default for all new spreadsheets to be 12?
WilliamKF
Posted 2014-06-04T19:24:42.400
Reputation: 6 916
1
I think changing your default zoom would be a better idea than changing font sizes - this way, people you send your Excel docs to who don't have 4K monitors will still be able to read them.
– Pockets – 2014-06-04T20:01:28.3901
To change all new spreadsheets to 12, go to Excel > Preferences > General > Standard Font > '12'. To change the hyperlink pasting font, follow this articles instructions, the template being an excel document with your desired customisations. Use the first 4 instructions on this link - it tells you how to make the template customisations. I think this is what you want.
– ᔕᖺᘎᕊ – 2014-06-04T20:13:26.513Did my suggestion eventually work? – ᔕᖺᘎᕊ – 2014-06-14T10:55:13.093
@shub Thus far I've only tried the change for all new spreadsheets which works even for setting hyperlinks for new spreadsheets, but I'm not sure how to apply that to existing ones. – WilliamKF – 2014-06-14T22:52:17.150
Ah... OK, I also do not know how to apply them to existing ones. Sorry – ᔕᖺᘎᕊ – 2014-06-15T09:32:23.687