Viewing multiple sheets at once in a single Numbers spreadsheet

Thanks for this. Sounds like I might buy (or perhaps borrow!) one of these Epson machines, when I find some time, as ever! ;-)

I completely agree, putting several spreadsheets on one page rather than having them on separate ‘sheets’ in the same document.

But that raises an interesting question, I’ve never considered…
In Numbers, is it possible to view several sheets from the same spreadsheet doc at the same time?

AFAICT on checking just now, there doesn’t seem to be a way of doing so. Which is annoying, as often you might want to check two (or more) sheets at the same time, to do comparisons and check details are correct. :slightly_frowning_face:

1 Like

It wouldn’t surprise me if there is a way to do this but I don’t know what it is.

You can copy a table from a separate sheet to another sheet but it remains a copy from that point in time (doesn’t update with changes to the original sheet - not much use really). What I often do is create multiple sheets and then reference relevant cells to a summary sheet.

For example to calculate my tax, I’ll create an income sheet, an expenses sheet, a jobs sheet, shares sheet, rental income sheet etc and then pull the totals onto my summary sheet. The totals are referenced across tables and are updated as each sheet is updated, becoming like a ‘dashboard’ of what I’ve done.

Yeah there must surely be a way to view 2+ sheets at the same time, by now…or maybe not?

TBH, I’m a little surprised Apple didn’t see this as something people would find very useful. :person_shrugging:

1 Like

That is an interesting question. My guess is Apple does not think it is necessary, because Numbers is oriented toward multiple discrete tables on the same sheet, which in my mind is like what you’re looking for. If I have two tables on one sheet, and each of them has its own coordinate system that starts at A1, I refer to cells in one table similarly to the Excel method of one table per sheet.

So with that way of thinking, the answer to your question is “Yes.” It’s just a different way of implementing it.

(Example: to calculate my home’s energy use for the solar project we’re doing, I could make lookup tables and various references on different sheets in Excel, and roll up the results on the front sheet. In Numbers, I created different tables all on one sheet, and created a summary table in the upper left hand corner. I can scale things so just that table will print or as I do more often open in Preview as a PDF.)

I do similar too (one sheet with several tables). But I don’t think that fully answers it, as Apple has built the Numbers app with an obvious option to use separate sheets within one document, which may suit many users in how they need/want to handle the info in certain documents.

So one has to wonder why Apple wouldn’t consider displaying more than one sheet at a time on screen a pretty obvious great user experience that users would want to do, in order to see different aspects of a document when making cross-sheet references and similar.

Maybe they think it wouldn’t be implementable very well on iOS/iPadOS, so macOS doesn’t get it either. :person_shrugging:

I guess the answer is we will never know, and/or come back in X years when it’s maybe perhaps added, lol! :face_with_diagonal_mouth:

1 Like