Forum Discussion

Ina_andrea's avatar
Ina_andrea
Copper Contributor
Nov 17, 2022

How to Print sheet larger font

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

excel

2 Replies

  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor
    Nov 21, 2022

    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.

Resources