Is there a way to select multiple sheets together from the same document?
This would allow me to make a single change in one sheet and to get it in the others as well.
[Re-Titled by Moderator]
iMac 24″, macOS 15.3
Numbers doesn’t support selecting multiple sheets simultaneously. Even if it did, changes made in one sheet wouldn’t automatically sync across the others. The easiest option is probably to make your changes in the first sheet and then manually copy-paste them into the other sheets.
Numbers doesn’t support selecting multiple sheets simultaneously. Even if it did, changes made in one sheet wouldn’t automatically sync across the others. The easiest option is probably to make your changes in the first sheet and then manually copy-paste them into the other sheets.
> This would allow me to make a single change in one sheet and to get it in the others as well
What kind of change?
If you're talking about a format or visual change (e.g. color scheme, column widths, formatting, etc.) then you're out of luck.
But if you're talking value changes (e.g. changing the value of a set of cells), then check whether the cells can be built as formulas that reference the same cell on the first sheet. In that way, changing the value on the first sheet will populate the change through the other sheets.
Without knowing your specific use case, it's hard to know if that's an option.
No! It's not about values. Those are already connected with formulas as you say. It was to be able to edit the tables together as graphics and to be able to add a table with links that refer to the various sheets (there are 60 in the document). I did it manually sheet by sheet, but I hoped there was a faster system.
That's what I suspected. Thanks.
Is there a way to select multiple sheets together from the same document?
