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

5 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
You can click at three dot symbol at top right chrome windows and look for 'zoom', adjust to 100%. as mine it strike to 150%. Good luck!