A number of users have reported Windows 10 screen resolution problems in the past few months. Another common problem is Windows 10 stretched screen problem in which pixels look broken and image looks stretched towards side with text distorted. Fortunately, you can fix Windows 10 stretched screen problem and Windows 10 resolution issues by applying simple steps.
Windows Macro Recorder(v1.0): Freelabs Macro Recorder it's a tool that helps you to automate your computer repetitive tasks by creating timesaving macros that will work with any Windows program. Freelabs Macro Recorder's features include: Record all mouse and keystrokes events of any windows application; Play back recorded macro. Launch VBA Userforms In Correct Window With Dual Monitors. What This VBA Code Does. Having dual monitors is one of the best was to increase efficiency as a data analyst. It was like Christmas when I was able to obtain a second monitor from my friends down in the IT Department.
Fix Windows 10 Stretched Screen and Resolution Issues
Most of the time Windows 10 stretched screen problem occurs because of some random key hits. You can fix this issue by restoring the original recommended pixel display settings.
From Display Settings
Right click on the Desktop and Click on Display Settings.
Now click on “Advanced Settings” button and select the pixel resolution to the “recommended” settings. Mostly, it is set as 1366*768. But you can also get a good resolution at 1260*768. Anything below this would distort the image and text and images would look broke, distorted and fuzzy.
Using Fn Key
Another great way to fix Windows 10 stretched screen problem is by using the Function key (Fn).
Hold the Function key(Fn) from your keyboard and press the space bar.
Now use the space bar to adjust and set the normal setting according to your choice.
Using Slider
You can also set the pixel settings by using the slider from the settings section. You can find this slider by going to the same settings area from Display Settings.
You can move the slider and set the resolution, which suits you best. Mostly 100% is recommended.
Click on Start button in Windows 10 from the bottom left corner and type “Change Screen Resolution” and hit Enter.
Now click on “Advanced Sizing of Text..” button from the center as shown in the image below.
Now click on Adjust Resolution from the left options pane.
Now click on Advanced settings button from the center.
Click on the “List all modes” button.
You will now see a list of different frequencies. Select the one which matches with your resolution (for example 1366*780 or 1280*780) with 60Hz refresh rate.
Click Ok and Apply the settings.
You will see a momentary black screen and the next thing you see will be sharp, perfect screen.
This is how to fix stretched screen Windows 10 issue. These method also resolves the screen resolution problem in Windows 10.
If the problem is not fixed, you can try all the refresh rates and resolutions from the lists ( after clicking list all modes) and see what works for you as screen resolution mostly depends upon the driver and hardware specs.
Don’t Miss: How to Speed Up Windows 10
I hope this solves your issues. In case you are still unable to fix the screen resolution or stretched screen issues in Windows 10, feel free to comment on this post and I will find another solution for you.
What This VBA Code Does
Having dual monitors is one of the best was to increase efficiency as a data analyst. It was like Christmas when I was able to obtain a second monitor from my friends down in the IT Department.
While using my dual monitor setup with Excel, I noticed that some of my add-ins were launching userforms on the monitor that wasn't housing my Excel window. This became very annoying and I soon started investigating why this was happening and how to fix it.
While consulting my good friend Google, I came across some code on The Spreadsheet Page's website that worked perfectly. I tweaked it a little bit (shown below), but the general concept remains the same. Just paste the code below in your userform's code module and you should be good to go!
PrivateSub UserForm_Initialize()
'PURPOSE: Position userform to center of Excel Window (important for dual monitor compatibility)
'SOURCE: www.TheSpreadsheetGuru.com/the-code-vault
'Start Userform Centered inside Excel Screen (for dual monitors)
Me.StartUpPosition = 0
Me.Left = Application.Left + (0.5 * Application.Width) - (0.5 * Me.Width)
Me.Top = Application.Top + (0.5 * Application.Height) - (0.5 * Me.Height)
EndSub
'PURPOSE: Position userform to center of Excel Window (important for dual monitor compatibility)
'SOURCE: www.TheSpreadsheetGuru.com/the-code-vault
'Start Userform Centered inside Excel Screen (for dual monitors)
Me.StartUpPosition = 0
Me.Left = Application.Left + (0.5 * Application.Width) - (0.5 * Me.Width)
Me.Top = Application.Top + (0.5 * Application.Height) - (0.5 * Me.Height)
EndSub
How Do I Modify This To Fit My Specific Needs?
Chances are this post did not give you the exact answer you were looking for. We all have different situations and it's impossible to account for every particular need one might have. That's why I want to share with you: My Guide to Getting the Solution to your Problems FAST! In this article, I explain the best strategies I have come up with over the years to getting quick answers to complex problems in Excel, PowerPoint, VBA, you name it!
I highly recommend that you check this guide out before asking me or anyone else in the comments section to solve your specific problem. I can guarantee 9 times out of 10, one of my strategies will get you the answer(s) you are needing faster than it will take me to get back to you with a possible solution. I try my best to help everyone out, but sometimes I don't have time to fit everyone's questions in (there never seem to be quite enough hours in the day!).
I wish you the best of luck and I hope this tutorial gets you heading in the right direction!
Chris 'Macro' Newman :)