Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Is it possible to insert a 'Name' in Pages?

I am creating a document in Pages, to replace an MS Word document I have previously used.


It contains 2 tables with formulae based on one set of values. In Word I gave each value a 'name' and used it in the formulae to avoid multiple entires. So far, in Pages, it seems I can only use values in the same table, so I will have to enter the values twice. This makes the document look repetitive.


Does anyone have the answer?


Thanks in hope,

Ken

MacBook Pro, Mac OS X (10.6.8)

Posted on Oct 31, 2013 2:39 PM

Reply
21 replies

Nov 9, 2013 6:00 PM in response to Jerrold Green1

Here's a better example. I was in a bit of a hurry on the last post. First, the graphic:

User uploaded file

There are two tables on this Pages document. The first is a sales log and the second is a summary table that totals the sales in the Amount column of the first table.


To program the Total Sales amount, click in the Total Sales result cell and type an equal sign, and "SUM(".


Next, click on the Bar above the Amount column in the sales log table. That inserts the column name in into the SUM function. Complete the expression by typing the closing parenthesis.


His the return key to exit the expression editor.


Jerry

Nov 9, 2013 9:28 PM in response to kenem

kenem wrote:


Thanks for this Jerrold but...


I cannot see any reference/name when I click on any part of a table. One click selects a cell, column/row or the whole table, but no reference appears. A double click enters the cell.


Have I missed something?

You have to be in the formula editor. (Insert > Function > Formula Editor). But the cursor in the field and click on any table you want.

Is it possible to insert a 'Name' in Pages?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.