In Pages I've inserted a table, which I assume is a small Numbers like table. Column D is set to a formula which simply multiplies columns B and C together. If I click on a row and Insert Below, then the formulas and cell formatting are not copied down. How do I make this happen automatically? It's a pain to reset things for every row I add there.
Hi Gargoyle,
Tables in Pages are similar to Tables in Numbers. Here is an example with a Header Row (Row 1), a Footer Row (Row 5) and a Header Column (Column A):
Formula in Cell D2
=Cost each ChairĂ—Number ordered Chair
Pages by default uses the labels in Header Rows and Header Columns as Cell references. Numbers (usually) uses the Column (A, B, C, D) label and Row 1, 2, 3, 4, 5) label as Cell references.
To Fill the formula down from D2 to D4, drag the yellow dot (Fill Handle) down.
To add another row containg the formula, click in a cell in Row 4 and press option down arrow.
Fill in the details in Columns A, B and C
The formula in D5 calculates the cost for that Row.
Formula in Footer Cell D6
=SUM(Cost)
Created in Pages 5.5.3 on OS X Yosemite 10.10.3
Regards,
Ian.
Hi Gargoyle,
Tables in Pages are similar to Tables in Numbers. Here is an example with a Header Row (Row 1), a Footer Row (Row 5) and a Header Column (Column A):
Formula in Cell D2
=Cost each ChairĂ—Number ordered Chair
Pages by default uses the labels in Header Rows and Header Columns as Cell references. Numbers (usually) uses the Column (A, B, C, D) label and Row 1, 2, 3, 4, 5) label as Cell references.
To Fill the formula down from D2 to D4, drag the yellow dot (Fill Handle) down.
To add another row containg the formula, click in a cell in Row 4 and press option down arrow.
Fill in the details in Columns A, B and C
The formula in D5 calculates the cost for that Row.
Formula in Footer Cell D6
=SUM(Cost)
Created in Pages 5.5.3 on OS X Yosemite 10.10.3
Regards,
Ian.
Ian, thank you for the great response! The only issue I'm having with your example is the D6. I've clicked in D7 on my table, which is the last row, and put =SUM(Cost) but it gives an error.
Hi Gargoyle,
Pages 5.5.3
Is D7 in your example (D6 in my example) a Footer Row?
Click on the table to make it active, then Menu > Format > Table >Footer Rows > 1
As you add more Body Rows, the formula in the Footer Row will automatically include them.
Cheers!
Ian.
This thread finally got me playing around with tables in Pages. I see you can do with tables in Pages things not yet possible with Numbers tables, such as reversing direction. Also, paginating across pages so you know what it will look like when printed even as you're working on it.
To my surprise it seems that Pages tables can do everything that Numbers do. Other than when you need multiple sheets with "tabs" at the top, why not just use Pages!??
SG
Hi SG,
Pages and Numbers are both part of iWork. Many similarities.
One difference you will see in Pages is that a Table (or any object) is by default, Move with Text.
To drag it around as in Numbers, select the object then Format Panel > Arrange > Stay on Page
Also have a play with Text Wrap.
Pages is a word processor, not the canvas we get in Numbers! (unless you start with a Page Layout template such as a newsletter with text boxes).
It takes a bit of getting used to, and I prefer Numbers for easy manipulation of objects.
Regards,
Ian.
Hi Ian,
Thanks for the pointers. I was astonished to discover Pages apparently makes available all the formulas and functions that Numbers does. It might be a natural place to do "print-oriented" spreadsheet work. (I'm thinking of all those questions about the limitations of printing in Numbers).
SG
Hi SG,
I'm thinking of all those questions about the limitations of printing in Numbers
And Jerry and Barry were correct (years ago) when they recommended copy and paste from Numbers to Pages for easy print layout 🙂.
For your next trick,
Pages Preferences > Rulers >
Golly gosh, how refreshing to be able to help Pages for Mac users in the Numbers for Mac forum!
Regards,
Ian.
Formulas in table inside Pages
