In the case of a traditional spreadsheet, a subset of the table could be displayed in the print sheet, each cell with a reference to the corresponding data sheet cells desired to be printed. Changing data in the Data sheet changes the totals in the Print sheet accordingly. The sheet contains two simple tables with a colored rectangle object in the background.
The Data sheet contains the data not for printing. Using formulas, such as one would use in Excel, data can be easily and automaticallyīelow is a very simple example. One method I use, particularly with printing off invoice or expense type sheets, is to keep the working data on a separate sheet from my print sheet. The OP does not state how their spreadsheet is laid out, but it appears from the brief description that is styled in a traditional manner, which is perfectly acceptable, but this limits how it can be presented for printing. However, this concept of making spreadsheets on canvases can open up many opportunities for print layouts. One can still use a very large data set in a large table as well. (See this Apple Support article on printing with Numbers.) Also, the ability to have several tables on a single canvas allows for more creative use of the space. Setting the print range in Excel only allows for a continuous subset of cells.
For example, placing text, charts or even graphics anywhere on the canvas that seems logical. Instead of merging cells and hiding borders, (which of course can be done with Numbers) Numbers allows more freedom to create a document designed for printing. This allows for placing tables, even those made up of a single cell, anywhere on the canvas needed. Numbers uses "Canvases" instead of large tables of thousands of columns and rows. Apple's Numbers is designed in a fundamentally different way than Microsoft's Excel or other spreadsheet solutions.
0 kommentar(er)
