I think it’s the display zooming that Excel has trouble with. That’s a bit small for me to read, so I’ve got the size of text, apps and other items set at 125% zoom. My second monitor is set at the recommended resolution – 1920 x 1080. But I’ve found a better solution now! Monitor Display Settings So that’s what I had been doing, when things looked strange in Excel, on the second monitor. The listbox is almost as wide as the UserForm.With the UserForm open, if I drag it to my primary monitor, everything looks fine.
#How to split my screen so excel is on both screens full#
The listbox should be the full width of the UserForm, but it’s about an inch narrower.There should be a scroll bar at the right side of the listbox, but it isn’t showing.There are a couple of things that look strange in this UserForm: All 12 months are in the list, but only the first 5 month names are visible. Here’s a screen shot of the UserForm listbox, opened on my second monitor. Note: This option setting was introduced in Microsoft Office 2016. The problem details and solution steps are below. Things should look okay after you restart Excel.In Excel options, General category, User Interface Options, choose Optimize for compatibility (application restart required).
Here’s the quick fix that’s working for me, and I hope it solves Excel display issues for you too. Finally, I tried a quick fix, and it seems to be working! Change an Excel Option
But, if I drag that UserForm to my other monitor, the scroll bar magically reappears. For example, an Excel UserForm listbox doesn’t show its scroll bar. Lately, I’ve noticed that some things in Excel look strange, when I have them on my second monitor.
0 kommentar(er)
