How to Copy a Tab on a Spreadsheet. Workbooks in Microsoft Excel can contain one or more spreadsheets, which are shown as separate tabs. While it's possible to highlight all of the data in a ...