Workbook - Copy Workbook Document

Ribbon bar. Select the Workbook tab. In the Clipboard group, click Copy Item(s) to copy the selected workbook item (and its children) to the Clipboard.

Classic menus. On the Workbook menu, select Copy Workbook document to copy the selected workbook item (and its children) to the Clipboard.

You can also access this option by right-clicking on any item in the workbook tree and selecting Copy Workbook document from the shortcut menu.