Formatting Issues

Fix Incorrect Excel Column Widths for One User

Huma Ashraf ChHuma Ashraf Ch Nov 14, 2026 868 views

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.
Before you start

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.

Solution 1Recommended

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%.

1
Open display settings

Right-click the Windows desktop and select Display settings, or open Settings > System > Display.

2
Change the scale

Under Scale or Scale and layout, select 100%. If multiple displays are connected, first select the display used for Excel.

3
Restart Windows

Open Start > Power > Restart to apply the change, then sign back in.

4
Check the workbook

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.

Set Windows Display Scaling to 100% and Restart
Accessibility consideration: A scale of 100% may make text and controls harder to see. If needed, use Excel's zoom slider to enlarge the worksheet, or consider the other troubleshooting steps before deciding which display setting works best.
Free Microsoft Office alternative

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.

View spreadsheets and adjust column widths in WPS Spreadsheets.Open and edit Microsoft Excel formats, including XLS and XLSX.Use a familiar spreadsheet interface for an easier transition from Excel.Work with a free, lightweight Office alternative.
microsoft office alternative - wps office

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.