excel for web screen is very large

Iron Contributor



my excel for web screen is very large all tabs are so large that you cant see the data, how to change it? i couldnt find any option, am using chromeCapture.PNG

4 Replies
Ctrl+F1 collapse/pin the ribbon.



You can also try it with VBA


Private Sub Workbook_Open()
   Select Case Application.UserName
        Case Pc1_server
            ActiveWindow.Zoom = 82
        Case "Username"
            ActiveWindow.Zoom = 100
   End Select
End Sub



I would be happy to know if I could help.



I know I don't know anything (Socrates)

@NikolinoDE , VBA doesn't work with Excel for web.

Yes you are right, unfortunately in the heat of the moment I overlooked it again. What would I do without your support? :) ... thx