We’re thrilled to launch drag and drop row movement, a long standing popular feature request allowing you to manually reorder rows in worksheets.
Let’s take a look!
Drag and drop row movement
Row movement works by selecting one or more rows and dragging the row header region:
All formulas and formula dependencies automatically adjust to the new row positions as shown above.
Drag and drop row movement in hierarchies
Row movement works in hierarchies and Gantt views as well.
When a parent row is moved, all child rows move with it:
When a child row is moved, it inherits the indentation of its upper sibling wherever it is dropped:
NOTE: Row movement in grouped views is not yet available but coming soon.
major important update!!