Just calculate your print space as your paper size minus your margins (top + bottom, or left + right) and divide by your print scale factor. Turn on your rulers and drag guide lines to match your print space so that you can be sure to place elements where they'll not be ignominiously chopped up in little bits when transferred to paper or PDF. Not mentioned above: when laying out your sheet full of tables and charts and pictures and text boxes, you can easily arrange things that don't print out well.
I'd love for Table Categories to come back! Sadly, that was stripped out during the iCloud-enabling rewrite and no longer exists. In the iWork 9 version of Numbers, it had Table Categories, and that was a brilliant way of viewing the same detail. However, I do have one gripe, and one hidden power feature not touched on above, regarding Numbers.įirst, the gripe.
Remember to format your column into Date & Time in your Excel spreadsheet. I've used Excel since it first came out on the Mac back in the '80s, through a couple decades on Windows for Intel and Alpha, and have learned to loathe the ribbon and user-hostile interface it has. This Excel formula to format date is very useful when you are using date.
