Numbers (Spreadsheet App) Question – Multiple Views
Posted November 3rd, 2012 @ 02:55pm by Erik J. Barzeski
Simply put, how can I create a document with two views of the same table?
I'd like this table:
To have a printable view that looks a bit like this:
(Not that it matters but you can click for larger versions of each of those images.)
The second table (which I'd like within the same file - if it's on a separate Sheet that's fine) eliminates a few columns, reorganizes them, resizes them, and changes some cell sizes (font sizes, widths, heights). The second table should grow (or shrink as I add or subtract rows from the first table.
Is this possible? If so, how?
Donate Life
Posted 04 Nov 2012 at 5:13pm #
I have done this (in Excel) by making a table with every cell having a function setting it equal to the value in the other table. Start with a number of rows you don't expect to exceed for a while (even if many of them are blank) and then put a conditional format somewhere to indicate when that limit is exceeded.
Posted 04 Nov 2012 at 8:26pm #
Yeah, I'm thinking that's probably the cheating way to do it, but I wonder if there's another way - like a way of setting up another "view" or something.
Posted 05 Nov 2012 at 1:51pm #
I so want this! It seems like such an obvious feature. Why don't we have it?
Posted 07 Nov 2012 at 5:35pm #
Having a data table and various views and reports on it is a database function--not something that spreadsheets are geared to do.