kenem

Q: 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

Close

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

  • All replies
  • Helpful answers

Previous Page 2
  • by kenem,

    kenem kenem Nov 9, 2013 2:52 PM in response to Jerrold Green1
    Level 1 (0 points)
    Nov 9, 2013 2:52 PM in response to Jerrold Green1

    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?

  • by Jerrold Green1,Solvedanswer

    Jerrold Green1 Jerrold Green1 Nov 9, 2013 3:11 PM in response to PeterBreis0807
    Level 7 (30,001 points)
    Nov 9, 2013 3:11 PM in response to PeterBreis0807

    Works just like Numbers when doing external table references. Here's an example, where the top table is Table 1.

    Screen Shot 2013-11-09 at 6.11.02 pm.png

    Jerry

  • by Jerrold Green1,

    Jerrold Green1 Jerrold Green1 Nov 9, 2013 6:00 PM in response to Jerrold Green1
    Level 7 (30,001 points)
    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:

    Screen Shot 2013-11-09 at 8.48.20 pm.png

    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

  • by PeterBreis0807,

    PeterBreis0807 PeterBreis0807 Nov 9, 2013 6:38 PM in response to Jerrold Green1
    Level 8 (35,825 points)
    Mac OS X
    Nov 9, 2013 6:38 PM in response to Jerrold Green1

    Jerrold

     

    Will that work across pages/sections?

     

    Peter

  • by Magnus Lewan,

    Magnus Lewan Magnus Lewan Nov 9, 2013 9:26 PM in response to Jerrold Green1
    Level 4 (3,659 points)
    Apple Music
    Nov 9, 2013 9:26 PM in response to Jerrold Green1

    Jerrold,

     

    Excellent! It is a real improvement compared to earlier versions. Imported Word documents with references are no converted properly, but at least one can build something in Pages.

     

    May I ask how you found out? Did you just try, or is there some hidden reference somewhere which I have not found?

  • by Magnus Lewan,

    Magnus Lewan Magnus Lewan Nov 9, 2013 9:28 PM in response to kenem
    Level 4 (3,659 points)
    Apple Music
    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.

  • by kenem,

    kenem kenem Nov 10, 2013 12:47 AM in response to Jerrold Green1
    Level 1 (0 points)
    Nov 10, 2013 12:47 AM in response to Jerrold Green1

    Thank you very much Jerrold, it works perfectly!

     

    It's an obvious, intuitive function and I'm sure that I tried that simple method before - but maybe not.

     

    Anyway thanks again and I can now produce a more elegant document.

     

    I will persevere with Pages 5 and provide some feedback, as suggested.

     

    Ken

Previous Page 2