Normal font

  • Thread starter Thread starter Dave B
  • Start date Start date
D

Dave B

I'm adding footers to a bunch of worksheets, and every time I add one the
font size is 10 point. Since I want it to be 8 point, I've been changing it
every time by clicking on the font icon (image of letter "A"). I notice
when I change the font format there's a checkbox that says "Normal" that
unchecks itself. Can I make the "Normal" font size 8 point, so I don't have
to keep changin it on every header? Thanks.
 
Dave

The "normal" font is whatever you have selected as the default font under
Tools>Options>General.

NOTE: previously saved workbooks will have "normal" font of whatever was
active in the default font box at the time they were saved.

Another Note: If you select all the sheets before setting the font size, it
will be same on all sheets.

Another solution could be setting the font size in Before_Print code.

Gord Dibben Excel MVP
 
Back
Top