How to Print sheet larger font

Copper Contributor

How can i print a sheet in excel at 150% of actual font size?

2 Replies

@Ina_andrea 

You can do this with VBA

 

Private Sub Workbook_BeforePrint(Cancel As Boolean)
Sheet1.PageSetup.Zoom = 150 'Zoom to 150%
End Sub

 

 

Hope I was able to help you with this info.

 

NikolinoDE

I know I don't know anything (Socrates)

Was the answer useful? Mark them as helpful!

This will help all forum participants.

Thankyou for your help. @NikolinoDE