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. 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. Click Layout, and then select Flip horizontally.Lately, I’ve noticed that some things in Excel look strange, when I have them on my second monitor. Mirror printing: Reverse an image or document for printing iron-on transfers. If prompted during printing, follow any instructions to manually load and flip the paper.Īdd or remove a border: Click Layout, and then click the Border menu to select a border width or select None for borderless prints. Select a binding type from the settings options or from the Layout menu. Two-sided printing (duplexing): Turn on the Double-sided or Two-Sided setting. Print quality: From the Quality or Print Quality menu or slider, select Best, Normal, or Draft. The setting might also be available in the File > Page Setup > Paper Size menu. Paper size: Select the paper from the Paper Size menu on the main dialog if present, or click Paper Handling, select Scale to fit paper size, and then select the paper in the Destination Paper Size menu.Ĭustom paper size: Click Manage Custom Sizes in the Paper Size menu, if available. Paper type (photo, plain, specialty): Select the paper type in Media & Quality to ensure the printer properly applies the ink to the paper you loaded in the printer. The Presets menu also includes color and black and white options. Color or black and white: Enable or turn off Print in Color or Black & White.
0 kommentar(er)
