How do I set a default font size in Exel

J

JAS

To save the bother of changing the font size from 10 to 8 in every cell, I
would like to set the default font as 8.
 
G

Gord Dibben

For all new workbooks.

Tools>Options>General>Standard Font>Size.

For existing workbooks, right-click on any sheet tab and "select all sheets"
to group the sheets.

CTRL + a to select all cells on the active sheet

Change the font to 8. Select a single cell.

Ungroup the worksheets...............select any of the non-active sheet tabs
to clear the grouping.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Centered text that does not stay centered 0
Open my default template when right click, select New MS Word doc within a folder 0
Set as Default Template not working 0
How to modify and updte specific styles for specific paragraphs across the document 0
Need help modifying code 0
How can the font and size of (all) citation numbers be altered? 1
How does one change the font name with VBA? 0
Word Template and Normal Style 1

Top