You are working in a Notion database and you cannot drag rows to a new position. The usual drag handle does not appear, or dragging does nothing. This happens because Notion databases that have an active sort applied lock the manual row order. The sort rule overrides any manual arrangement you try to make. This article explains why a sort prevents row reordering and shows you how to regain the ability to move rows freely.
Key Takeaways: Reordering Rows in a Sorted Notion Database
- View menu > Sort > Remove sort: Removing all sort rules restores the manual drag-and-drop row order.
- Drag handle (six dots icon): This handle appears only when no sort is active and the view is set to table or board.
- Add a manual Order property: Create a Number property called Order to assign custom positions even while a sort is active.
Why a Sort Rule Prevents Manual Row Reordering
Notion databases are built on a structured data model. Every column is a property, and every row is a database item. When you apply a sort to a view, Notion reads the values of the sort property for every row and arranges them in ascending or descending order. This arrangement is computed dynamically. The drag-and-drop action, which sets a manual position, conflicts with the computed sort order. Notion prioritizes the sort rule over manual positioning to keep the view consistent. As long as any sort rule is active, the manual position is disabled.
The manual position is stored as a hidden internal property. When you drag a row, Notion writes a value to that hidden property. A sort rule ignores that hidden property and uses the visible property you selected instead. The result is that your drag action has no visible effect. The row snaps back to its sorted position.
This behavior applies to table view, board view, and gallery view. List view and calendar view do not support manual row ordering at all, so the issue does not arise there. The fix is the same regardless of the view type: remove the sort or use a workaround property.
Steps to Remove a Sort and Reorder Rows Manually
- Open the view menu
In the top-right corner of your database, click the view name (it says Table, Board, or Gallery). A dropdown menu opens. - Select Sort
In the dropdown, click Sort. A submenu appears showing all active sort rules. If no sort rules are listed, the view has no sort applied. - Remove every active sort rule
Click the X icon next to each sort rule to delete it. If more than one rule exists, remove all of them. The database view updates to show rows in their default order, which is the order they were created. - Drag a row to a new position
Hover over the left edge of any row. The six-dot drag handle appears. Click and hold the handle, then drag the row up or down. Release the mouse to place the row in the new position. - Reapply the sort if needed
After you finish rearranging rows, you can add the sort rule back. Open the view menu again, click Sort, and add the same property and order you used before. The rows snap to the sorted order, and your manual positions are lost. To keep manual order visible, do not reapply the sort.
Alternative Method: Use a Manual Order Property
If you need to keep a sort active and still control row order, create a dedicated Order property. This method works with any view and keeps the sort rule intact.
- Add a Number property
Click the + icon in the last column header of your database. Name the property Order and set the property type to Number. - Assign numbers to each row
Click into the Order cell for each row and type a number. Use 1 for the first row, 2 for the second, and so on. You can leave gaps between numbers to insert rows later. - Sort by the Order property
Open the view menu, click Sort, and add a sort rule for the Order property. Choose Ascending. The rows now appear in the order you defined by the numbers. - Reorder rows by editing numbers
To move a row to a new position, change its Order value. For example, to move a row between positions 2 and 3, change its Order to 2.5. Then sort the view again. The row appears in the desired spot.
If Notion Still Does Not Allow Row Reordering
Drag handle is missing after removing the sort
The drag handle appears only in table view and board view. If you are using gallery view, list view, or calendar view, the handle does not appear. Switch to table view or board view temporarily to reorder rows, then switch back to your preferred view.
Rows snap back after dragging
This usually means a sort rule is still active. Open the view menu and check Sort again. Remove all rules even if you think you already removed them. Also check if a filter is applied. Filters do not prevent reordering, but they can hide rows, making it look like a drag failed.
Database is a linked view of another database
Linked database views inherit the sort rules of the source database. Open the original database, remove the sort there, then reorder rows in the original. The linked view will update to show the new order. You cannot reorder rows inside a linked view directly.
Manual order resets after refreshing the page
If you removed the sort, dragged rows, and then refreshed the browser, the manual order should persist. If it does not, check whether the view has a group applied. Grouping can override manual order. Remove all groups from the view, reorder rows, then reapply the group.
| Item | Sort Active | No Sort |
|---|---|---|
| Drag-and-drop rows | Disabled | Enabled |
| Manual Order property | Works as a workaround | Not needed |
| View types that support drag | None | Table, Board |
| Sort rule persistence | Remains active | Removed |
Rows cannot be manually reordered in any view while a sort rule is active. Removing the sort restores drag-and-drop. Creating an Order property lets you keep a sort and still define row positions. Use the view menu to check for active sort rules before trying to drag rows.