workbook fonts

  • Thread starter Thread starter Icehearted
  • Start date Start date
I

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.
 
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
 
thank you! that was amazingly easy :)

Gord Dibben said:
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




.
Click to expand...
 
Back
Top