excel for web screen is very large

Iron Contributor

Hello

 

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.

@chahine 

 

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.

 

Nikolino

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!