Benches Uncategorized

5

How do you anchor (link) from one cell to anoth...

apple Verified

Imported from the Apple Support Forums via the Wayback Machine 🔗

Going in circles here. With Excel you can anchor (link) a cell to a separate or different sheet. Is that possible with Numbers? All I see is the hyperlink to web or email. Not very straight forward. Seeking confirmation. Standing by. Thankyou

5 replies

Sign in or join Beachball Help to reply.

  1. 0

    Apple Support Community member

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Hi!

    To reference to a cell in teh same file, but in a other sheet user the following format:

    sheet::table::cell

    sheet: the name of the sheet
    table: the name of teh table in the sheet
    cell: the cell reference in the table (e.g. B5)

    See also page 90 in the manual.

    Or simple start to write the formula and click simple an the cell in the other sheet.

    To reference a cell in a other file, there ist in the moment no way, to do it (that I know).

    Hope that will help

    Greetings from Hamburg, Germany
    Bjoern

  2. 0

    Apple Support Community member

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Hi Bjorn,
    Thank you for your reply. Sorry to send this so late. You actually gave me two answers. My original question and also I didn't even know about the manual. I've downloaded it so that will save me a lot of time. Thank you again for your help.

  3. 0

    Apple Support Community member

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    I recently purchased Numbers (in iwork) and have been completely unable to link cells between separate spreadsheets. ( As Bjorn stated, it seems you can link cells between sheets within a single spreadsheet but not between spreadsheets)

    Many of my excel spreadsheets rely on the cell linkage feature and lack of this function greatly reduces Numbers capability.

    Does anyone no of a workaround or update?

  4. 0

    Apple Support Community member

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Hello

    I would be surprised if something change on this feature.

    Numbers is a new kind of spreadsheet.

    What you made with different spreadsheets may be done now in a single document.

    But perhaps you didn't take care that a Numbers document may embed many sheets and that each sheet may embed many tables.

    Once again, Apple think different, for those which are not reluctant to change old habits.

    Yvan KOENIG (from FRANCE mercredi 24 octobre 2007 17:45:41)

  5. 0

    Apple Support Community member

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Hi WhatNow!

    You are absolute welcome. I am glad that I can help.

    Greetings from Hamburg