SharePoint Online is a powerhouse for list and document management — but sometimes, it’s the smallest things that drive users crazy.
One frequent complaint? You can’t shrink a column’s width as much as you’d expect, especially when you’re only displaying short pieces of information (like U.S. state abbreviations).
Here’s the real story behind the column width “issue” in SharePoint Online, and what you can actually do to fix or work around it.
Why You Can’t Manually Shrink Column Widths (Fully)
In modern SharePoint lists, Microsoft enforces a minimum column width.
Even if you only have two-letter values like “CA” or “NY”, you won’t be able to manually drag the column smaller than a certain default size.
Important:
- This limitation applies across all modern list experiences.
- It’s a design choice to maintain usability and accessibility (but yes, it can be extremely frustrating).
So even though you can drag the column headers to some extent, you’ll eventually hit a floor where it refuses to get any narrower.
Partial Solution: Shrink the Column’s Visual Width with JSON Formatting
If you’re looking for a clean, non-invasive way to make a column appear smaller, JSON column formatting is your friend.
Here’s how to do it:
- Open your SharePoint list.
- Click the dropdown next to your target column > Column Settings > Format this column.
- In the formatting pane, select Advanced mode.
- Paste the following JSON code:
jsonCopyEdit{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
"elmType": "div",
"attributes": {
"class": "sp-field-severity--good"
},
"style": {
"width": "60px",
"overflow": "hidden",
"white-space": "nowrap",
"text-overflow": "ellipsis",
"text-align": "center"
},
"children": [
{
"elmType": "span",
"txtContent": "@currentField"
}
]
}
- Click Save.
What This Does:
- Centers the text.
- Restricts the visible width of the column data.
- Cuts off overflow gracefully with ellipsis (…) if necessary.
👉 Heads up: This only affects the display of the data — it does not allow the actual column header frame to shrink past SharePoint’s enforced minimum width.
Why JSON Formatting is (Usually) Enough
Using JSON to visually compress the data solves 90% of the real-world problems:
- Your list looks cleaner.
- Users aren’t distracted by tons of wasted space.
- No permissions or admin access needed.
- No need to mess around with custom code or dangerous JavaScript injections.
It’s a simple, elegant workaround — without getting tangled in SharePoint development projects.
What About Full Control? (SPFx Extensions)
If you must have complete control over column sizes — including header and slider behavior — there’s only one realistic method:
➡️ Build a custom SharePoint Framework (SPFx) List View Command Set extension.
This is a much heavier lift:
- Requires professional development skills (Node.js, SPFx, TypeScript).
- Needs tenant app catalog deployment.
- Potentially risky if not maintained properly after Microsoft updates.
Bottom line?
Building a full SPFx solution just to tweak a few columns is like bringing a tank to a knife fight. It’s overkill unless you’re developing a full custom application anyway.
Other Workarounds (That Might Not Work for You)
| Option | Reality Check |
|---|---|
| Inject JavaScript into the page | Often blocked by modern SharePoint security settings |
| Use a Modern Script Editor web part | Works on some tenants, requires admin approval |
| Move back to Classic experience | Loses too many modern features, not recommended |
TL;DR: Here’s What You Should Do
| If You Want… | Do This |
|---|---|
| Quick, simple visual fix | Use JSON formatting (code above) |
| Full manual control over widths | Build a custom SPFx extension (complex) |
| Manual resize like Excel | Not possible yet in SharePoint Online |
Final Thoughts
Microsoft has made huge strides with SharePoint Online, but column width flexibility still lags behind.
While JSON formatting offers a quick win, it’s not a perfect substitute for full manual control.
At the moment, shrinking the visible content and accepting the minimum width constraint is the easiest and safest approach.
If you’d like to see better native support for column resizing, make your voice heard through Microsoft’s official feedback channels — it’s the only way to push changes for future updates.
✅ Pro Tip: Bookmark this guide — you’ll likely be asked about “narrowing columns” again if you manage SharePoint for your organization.
(And now you’ll know exactly what to say.)