Fix Incorrect Excel Column Widths for One User
Question details
A user needs Excel column widths to display correctly when opening shared workbooks.
- Product
- Microsoft Excel for Microsoft 365
- Device & OS
- Windows
- Scenario
- One user opens Excel files stored on a network that display correctly for other users.
- Observed behavior
- The user's Excel shows incorrect column widths and a default width of 8.11 instead of 8.43.
Open the same network workbook on the affected computer and another user's computer to compare the column widths. Check the affected computer's current display scaling setting in Windows Settings.
Set Windows Display Scaling to 100% and Restart
Use this fix when column widths differ for one user and Windows display scaling is above 100%.
Right-click the Windows desktop and select Display settings, or open Settings > System > Display.
Under Scale or Scale and layout, select 100%. If multiple displays are connected, first select the display used for Excel.
Open Start > Power > Restart to apply the change, then sign back in.
Open the network workbook in Excel and compare its column widths with those seen by another user. You can also right-click a column heading and select Column Width to check its value.

Update Office and Test Another Windows Profile
Use these checks if changing display scaling does not resolve the issue or is not suitable for the user.
View and Adjust Spreadsheet Columns with WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for working with spreadsheets. Its Microsoft Office format compatibility makes it easy to try shared workbooks in WPS Spreadsheets without changing the original Excel installation.

Frequently Asked Questions
Why does the same Excel workbook look different for one user?
Display scaling or a Windows profile setting may affect how Excel displays column widths. Compare Windows Settings > System > Display on the affected computer with a computer that displays the workbook correctly.
Where can I check a column's width in Excel?
Right-click the column heading and select Column Width to see its current value. Compare the same column on both computers.
Do I need to restart after changing Windows scaling?
Restart Windows after changing the scale to 100% for this troubleshooting test. In the reported case, restarting corrected both the default and workbook column widths.
What if 100% scaling makes Excel too difficult to read?
Use the zoom slider in Excel to enlarge the worksheet, or return to a comfortable Windows scaling setting and try updating Office and testing another Windows profile.
How do I report the issue to Microsoft?
In Excel, go to File > Feedback > Send a Frown. Describe the affected workbook, display scaling, Excel version, and whether the problem occurs in another Windows profile.




