workbook fonts

[Icehearted]

Is there a piece of code someone could give me to make all my fonts in a
workbook the same? this workbook has about 20 sheets and i don't want to go
in and manually do font changes.

any help is kindly appreciated.

 

[Gord Dibben]

Select sheet1.

Right-click on that sheet tab and "select all sheets"

CTRL + a to select all cells.

Change the font on sheet1 and will be done to all sheets.

DO NOT FORGET to ungroup the sheet after you're done.


Gord Dibben MS Excel MVP

 

[Icehearted]

thank you! that was amazingly easy

Select sheet1.

Right-click on that sheet tab and "select all sheets"

CTRL + a to select all cells.

Change the font on sheet1 and will be done to all sheets.

DO NOT FORGET to ungroup the sheet after you're done.


Gord Dibben MS Excel MVP




.