Benches Uncategorized

2

Numbers

apple Verified

Imported from the Apple Support Forums via the Wayback Machine 🔗

I am trying to move a "sheet" from a spreadsheet to start another spreadsheet. When I select the sheet, and "move" it moves the whole spreadsheet not just the sheet.

2 replies

Sign in or join Beachball Help to reply.

  1. 0

    Sheppad

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Dennis, I think that the best way is probably to duplicate the original spreadsheet and then modify the sheet in the new workbook. It's pretty easy to do, if you right click on the file name.

  2. 0

    SGIII

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    A Numbers document or "spreadsheet" (similar to an Excel workbook but the term workbook is not used in Numbers) contains sheets (tabs) which contain tables. Only tables have cells.

    To move a sheet (tab) to another document hover near the sheet name in the tab at the top and choose 'Copy Sheet' from the dropdown menu. Then in the other document activate that same dropdown menu in the tab of an existing sheet and choose 'Paste Sheet.'

    To move a table click in it to activate the "bull-eye" (concentric circles) to its upper left. Click that bulls-eye and command-x to cut the table to the clipboard. Click on the canvas of a sheet where you want that table to go and type command-v to paste.

    SG