Export only one sheet of a Numbers spread sheet on ios

I am trying to export only one sheet of a 12 sheets numbers file from my iphone to a pdf file. Before anyone suggest using the print settings option If i set the printing options to only this sheet and then in the export dialog I choose print settings i get all the sheets. regardless so this method isnt working.


Any ideas on how to do that?

Posted on Apr 8, 2018 5:10 AM

Reply
2 replies

Apr 10, 2018 11:26 AM in response to Gon Paran

Export will always work on the whole workbook, I have done this to make a copy of a single sheet for someone before, basically copy everything from the sheet into a new single sheet workbook.


1-If any formulas refer to other sheets, you will need to copy and then paste over them with values/results

2-Select all items in the page you want (you can tap in a blank area and "select all" if you want)

3-copy (tap one of the selected items and choose "copy")

4-Tap spreadsheets at the top left.

5-Tap Create Spreadsheet to make a new blank spreadsheet

6- in new spreadsheet, tap once in an empty area and choose"Paste"

You might need to delete the default empty table from the new workbook


Jason

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Export only one sheet of a Numbers spread sheet on ios

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.