Others

Fix SharePoint Column Order Changes Unexpectedly When Dragging

Olivia MillerOlivia Miller Oct 15, 2026 870 views

Question details

Users experience incorrect placement or movement of unrelated columns when attempting to drag and drop columns in a SharePoint list.

How to Fix SharePoint Column Order Changing Unexpectedly When Dragging
Product
Microsoft SharePoint
Device & OS
not provided
Scenario
Organizing and customizing list views in SharePoint.
Observed behavior
Dragging a column places it in the wrong location or unexpectedly shifts other unrelated columns across the list.
Before you start

Ensure you have the necessary list editing permissions, such as Design or Full Control, in your SharePoint site before attempting to modify column settings.

Solution 1Recommended

Manually Set Column Order via List Settings

Bypassing the drag-and-drop interface and using the classic List settings ensures precise control over column placement without interface glitches.

SharePoint's modern interface drag-and-drop feature can sometimes conflict with browser rendering or list formatting. Using the backend settings menu forces the system to assign strict positional values to each column.

1
Access List Settings

Navigate to your SharePoint list and click on the 'Settings' (gear icon) in the top right corner, then select 'List settings' from the dropdown menu.

2
Open Column Ordering

Scroll down the settings page to the 'Columns' section and click on the 'Column ordering' link.

3
Define Column Positions

Use the drop-down numbers provided next to each column name to specify their exact position from left to right.

4
Save Changes

Click 'OK' at the bottom of the page to apply and enforce the new column order across your list view.

View Applied: The manually assigned order will instantly reflect in the default list view for all users.
Free Microsoft Office alternative

Looking for a Seamless Document Management Experience?

While SharePoint handles complex list structures and web hosting online, daily document creation requires reliable desktop software. WPS Office is a free, lightweight, and powerful alternative to Microsoft Office. It provides a familiar user interface and robust tools for documents, spreadsheets, and presentations without the high subscription costs.

  1. 1. Download the Installer: Visit the official WPS Office website to download the free version for your operating system.
  2. 2. Install WPS Office: Run the downloaded file and follow the quick setup wizard to install the software.
  3. 3. Open Your Documents: Launch WPS Office and instantly open your existing Microsoft Office files without losing any formatting.
Fully compatible with Microsoft Word, Excel, and PowerPoint file formats (.docx, .xlsx, .pptx).Lightweight installation that runs smoothly even on older computers and laptops.Familiar, intuitive user interface that requires zero learning curve for Office users.Built-in PDF editing, conversion, and annotation tools for comprehensive document workflow.
microsoft office alternative - wps office

Frequently Asked Questions

Why do my SharePoint columns keep reverting to their old order?

This often happens if you are modifying a personal view rather than the default public view, or if another user with edit permissions is simultaneously changing the list settings. Ensure you are editing the 'All Items' public view.

Can I lock the column order in a SharePoint list?

SharePoint does not have a native feature to completely lock column order for editors on the modern interface, but you can restrict list permissions to 'Read' or 'Contribute' to prevent standard users from modifying the public views.

Are there limits to how many columns I can reorder?

While you can reorder as many columns as you create, SharePoint lists have a row size limit based on data types. Having too many complex columns in a single view might cause performance or rendering issues during drag-and-drop actions.