excel for web screen is very large

%3CLINGO-SUB%20id%3D%22lingo-sub-2305204%22%20slang%3D%22en-US%22%3Eexcel%20for%20web%20screen%20is%20very%20large%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2305204%22%20slang%3D%22en-US%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Emy%20excel%20for%20web%20screen%20is%20very%20large%20all%20tabs%20are%20so%20large%20that%20you%20cant%20see%20the%20data%2C%20how%20to%20change%20it%3F%20i%20couldnt%20find%20any%20option%2C%20am%20using%20chrome%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Capture.PNG%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F276580iD4DEB09782841BD5%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Capture.PNG%22%20alt%3D%22Capture.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2305204%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2305243%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20for%20web%20screen%20is%20very%20large%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2305243%22%20slang%3D%22en-US%22%3ECtrl%2BF1%20collapse%2Fpin%20the%20ribbon.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2305789%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20for%20web%20screen%20is%20very%20large%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2305789%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F258847%22%20target%3D%22_blank%22%3E%40chahine%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EYou%20can%20also%20try%20it%20with%20VBA%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3EPrivate%20Sub%20Workbook_Open()%0A%20%20%20Select%20Case%20Application.UserName%0A%20%20%20%20%20%20%20%20Case%20Pc1_server%0A%20%20%20%20%20%20%20%20%20%20%20%20ActiveWindow.Zoom%20%3D%2082%0A%20%20%20%20%20%20%20%20Case%20%22Username%22%0A%20%20%20%20%20%20%20%20%20%20%20%20ActiveWindow.Zoom%20%3D%20100%0A%20%20%20End%20Select%0AEnd%20Sub%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2306836%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20for%20web%20screen%20is%20very%20large%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2306836%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722750%22%20target%3D%22_blank%22%3E%40Nikolino%3C%2FA%3E%26nbsp%3B%2C%20VBA%20doesn't%20work%20with%20Excel%20for%20web.%3C%2FP%3E%3C%2FLINGO-BODY%3E
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

4 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