Want to highlight a helpful answer? Upvote!
Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >
Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >
Is there a way to remove all sheet references from formulas in a sheet that has been copied and then pasted from one sheet to another?
I have several scenarios (one per sheet) all identical except differing data. They must to be in the same workbook. Can this be accomplished in Numbers without every cell being manually edited?
Tachyon,
In Numbers:
Documents contains sheets
Sheets contain tables, text, graphics
Tables contains cells
cells contain text, numbers, formulas
Based on this Numbers-centric terminology are you copying a sheet to another document? Copying a table to another sheet?
If the table name is unique Numbers does not need the sheet name to resolve which table you are referring to. If you have more than one table with the same name then Numbers uses the Sheet/Table combination to locate a table.
]I have several scenarios (one per sheet) all identical except differing data.
You could consider setting up one sheet the way you like it. Then Duplicate and Rename.
SG
This is very good to know. Now is this same option possible with the iCloud version?
I am attempting to copy the entire contents of one sheet within a workbook (document) onto another sheet within the same workbook (document) - btw, we are using Numbers on iCloud.
within a sheet select all using the menu item "Edit > Select All", then copy (using the menu item "Edit > Copy", then switch to the destination sheet, paste. If there are conflicting table names Numbers will change names as needed.
If you post screenshot of a specific situation it may be easier to provide a specific answer.
This is very good to know. Now is this same option possible with the iCloud version?
That's a good question! I can't find the option to duplicate a sheet in Numbers for iCloud. And if on sheet 1 you select all tables (with some formulas in a table referring to cells in another table on that sheet), copy, add a new sheet, and paste the tables there, the tables appear as expected but the formulas still refer to cells in tables in sheet 1 instead of the corresponding tables on the new sheet. You might want to give Apple feedback on that.
In general I've found setting up documents is much easier on the Mac (and to a lesser extent the iPad) than at icloud.com iCloud is good for sharing documents and making some edits, and now syncs documents smoothly between the Mac and iOS, but it's not all that good for settng up documents. You can duplicate sheets easily both on the Mac and in Numbers for iOS to create your scenarios, and Numbers for iCloud will display them properly with the correct cell references.
SG
SG,
Just before I posted this question, I had contacted Apple Support to ask it I was just not seeing the normally available option to Dublicate a Sheet. They didn't know how to accomplish what I was attempting to do and suggested I post in the Apple Support Community.
This is good that you are able to confirm what I have found. I was intentional in not using the term "dublicate sheet" as I was hoping someone like yourself would add additional insight to the problem -- As you did. Thank you!
I only have EXcel on my Mac and I thought I'd try using the version of Numbers Apple provides on iCloud to test the waters, so to speak.
Wayne, SG nailed it. and provided the exact answer I was hoping for. It is simple and just not possible (at this time) with the iCloud version but it is a simple menu option on the installed version.
Thank you for your willingness to help.
I only have EXcel on my Mac and I thought I'd try using the version of Numbers Apple provides on iCloud to test the waters, so to speak.
Your comment prompted me to try the 'Upload Spreadsheet' feature in iCloud Numbers.
To my surprise it does a decent job on Excel spreadsheets. So if you don't (yet) have Numbers for the Mac you could set up your scenarios on different sheets in an Excel workbook and Upload the workbook.
SG
removing sheet references in formulas
