Managing Sheets in Workbook Improvements

Version: 2023

Type: Features

Category: Data Handling

Subcategory: Worksheet

Jira: ORG-25184

  • Shift+Select or Ctrl+Click sheet tabs to select multiple sheets. Then:

Drag them to another book to move them there..

Drag to workspace to move them to a new book.

There is also Move to New Book or Selected Book in Navigate Worksheets dialog.

Set system variable @SDMS=0 to roll back to old behavior so multi-sheet will not be allowed to drag.

  • Drag and drop multiple sheets in Object Manager to reorder them.

  • Auto scroll sheets when keeping dragging sheet tabs in one direction as in Excel. In older versions, it would be impossible to drag a sheet to a certain location since the sheets couldn’t auto scroll.