Referencing a Cell in Another Sheet

āĻāĻ•āϟāĻŋ āĻĒāĻžāϤāĻž āĻ•āĻ•ā§āώ⧇ āφāĻĒāύāĻŋ āĻ…āĻ¨ā§āϝ āĻĒāĻžāϤāĻžāϰ āϰ⧇āĻĢāĻžāϰ⧇āĻ¨ā§āϏ āĻĻ⧇āĻ–āĻžāϤ⧇ āĻĒāĻžāϰāĻŦ⧇āύāĨ¤

āĻāĻ•āχ āĻĒāĻĻā§āϧāϤāĻŋāϤ⧇, āĻ…āĻ¨ā§āϝ āύāĻĨāĻŋ āĻĨ⧇āϕ⧇ āĻāĻ•āϟāĻŋ āĻ•āĻ•ā§āώ⧇ āϰ⧇āĻĢāĻžāϰ⧇āĻ¨ā§āϏ āϤ⧈āϰāĻŋ āĻ•āϰāĻž āϝāĻžāĻŦ⧇ āϝāĻž āύāĻĨāĻŋāϟāĻŋ āχāϤāĻŽāĻ§ā§āϝ⧇ āĻāĻ•āϟāĻŋ āĻĢāĻžāχāϞ āĻšāĻŋāϏ⧇āĻŦ⧇ āϏāĻ‚āϰāĻ•ā§āώāĻŋāϤ āφāϛ⧇ āϤāĻž āĻĒā§āϰāĻĻāĻžāύ āĻ•āϰ⧇āĨ¤

āĻāĻ•āχ āύāĻĨāĻŋāϤ⧇ āĻāĻ•āϟāĻŋ āϘāϰ āϰ⧇āĻĢāĻžāϰ⧇āĻ¨ā§āϏ āĻ•āϰāϤ⧇

  1. Open a new, empty spreadsheet. By default, it has only a single sheet named Sheet1. Add a second sheet clicking on + button to the left of the sheet tab in the bottom (it will be named Sheet2 by default).

  2. āωāĻĻāĻšāĻžāϰāϪ⧇āϰ āĻŽāĻžāĻ§ā§āϝāĻŽā§‡, āĻĒāĻžāϤāĻž ā§§ āĻāϰ āϘāϰ A1 āĻ āύāĻŋāĻŽā§āύ⧋āĻ•ā§āϤ āϏ⧂āĻ¤ā§āϰ āϏāĻ¨ā§āύāĻŋāĻŦ⧇āĻļ āĻ•āϰāĻžāύ :

    =Sheet2.A1

  3. āĻ¸ā§āĻĒā§āϰ⧋āĻĄāĻļā§€āĻŸā§‡āϰ āύāĻŋāĻŽā§āύ⧇ āĻĒāĻžāϤāĻž ⧍ āĻŸā§āϝāĻžāĻŦ āĻ āĻ•ā§āϞāĻŋāĻ• āĻ•āϰ⧁āύāĨ¤ āĻāĻ–āĻžāύ⧇ āϘāϰ A1 āĻ āĻ•āĻžāĻ°ā§āϏāĻžāϰ āϏ⧇āϟ āĻ•āϰ⧁āύ āĻāĻŦāĻ‚ āĻĒāĻžāĻ ā§āϝ āĻ…āĻĨāĻŦāĻž āϏāĻ‚āĻ–ā§āϝāĻž āϏāĻ¨ā§āύāĻŋāĻŦ⧇āĻļ āĻ•āϰāĻžāύāĨ¤

  4. āϝāĻĻāĻŋ āφāĻĒāύāĻŋ āĻĒāĻžāϤāĻž ā§§ āĻ āĻĢ⧇āϰāϤ āϝāĻžāύ, āφāĻĒāύāĻŋ āĻāĻ–āĻžāύ⧇ āϘāϰ A1 āĻ āĻāĻ•āχ āĻŦāĻŋāώāϝāĻŧāĻŦāĻ¸ā§āϤ⧁ āĻĻ⧇āĻ–āϤ⧇ āĻĒāĻžāĻŦ⧇āύāĨ¤ āϝāĻĻāĻŋ āĻĒāĻžāϤāĻž t2.A1 āĻāϰ āĻŦāĻŋāώāϝāĻŧāĻŦāĻ¸ā§āϤ⧁ āĻĒāϰāĻŋāĻŦāĻ°ā§āϤāύ āĻšāϝāĻŧ, āϤāĻ–āύ āĻĒāĻžāϤāĻž t2.A1 āĻāϰ āĻŦāĻŋāώāϝāĻŧāĻŦāĻ¸ā§āϤ⧁ āĻ“ āĻĒāϰāĻŋāĻŦāĻ°ā§āϤāύ āĻšāĻŦ⧇āĨ¤

tip

When referencing a sheet with name containing spaces, use single quotes around the name: ='Sheet with spaces in name'.A1


tip

The example uses Calc formula syntax. It is also possible to use Excel A1 or R1C1 formula syntax; this is configured on Formula options page.


āĻ…āĻ¨ā§āϝ āφāϰ⧇āĻ•āϟāĻŋ āύāĻĨāĻŋāϤ⧇ āĻāĻ•āϟāĻŋ āϘāϰ āϰ⧇āĻĢāĻžāϰ⧇āĻ¨ā§āϏ āĻ•āϰāϤ⧇

  1. āĻāĻ•āϟāĻŋ āĻŦāĻŋāĻĻā§āϝāĻŽāĻžāύ āĻ¸ā§āĻĒā§āϰ⧇āĻĄāĻļā§€āϟ āύāĻĨāĻŋ āϞ⧋āĻĄ āĻ•āϰāϤ⧇, āĻĢāĻžāχāϞ - āϖ⧁āϞ⧁āύāĻĒāĻ›āĻ¨ā§āĻĻ āĻ•āϰ⧁āύ

  2. āύāϤ⧁āύ āĻ¸ā§āĻĒā§āϰ⧇āĻĄāĻļā§€āϟ āύāĻĨāĻŋ āϖ⧁āϞāϤ⧇, āĻĢāĻžāχāϞ - āύāϤ⧁āύ āĻĒāĻ›āĻ¨ā§āĻĻ āĻ•āϰ⧁āύāĨ¤ āφāĻĒāύāĻŋ āĻāĻ•āϟāĻŋ āϏ⧂āĻ¤ā§āϰ āφāϰāĻŽā§āĻ­ āĻ•āϰāϤ⧇ āϚāĻžāύ āϏ⧇āϟāĻŋ āύāĻŋāĻ°ā§āĻĻ⧇āĻļ āĻ•āϰāϤ⧇ āĻ•āĻ•ā§āώ⧇ āĻ•āĻžāĻ°ā§āϏāĻžāϰāϟāĻŋ āύāĻŋāĻ°ā§āϧāĻžāϰāĻŖ āĻ•āϰ⧁āύ āϝ⧇āĻ–āĻžāύ⧇ āφāĻĒāύāĻŋ āĻŦāĻšāĻŋāσāĻ¸ā§āĻĨ āĻĄāĻžāϟāĻž āϏāĻ¨ā§āύāĻŋāĻŦ⧇āĻļ āĻ•āϰāĻžāϤ⧇ āĻĒāĻžāϰ⧇āύ āĻāĻŦāĻ‚ āĻāĻ•āϟāĻŋ āϏāĻŽāĻžāύ āϚāĻŋāĻšā§āύ āϏāĻ¨ā§āύāĻŋāĻŦ⧇āĻļ āĻ•āϰāĻžāύāĨ¤

  3. āφāĻĒāύāĻžāϰ āĻŽāĻžāĻ¤ā§āϰ āϞ⧋āĻĄ āĻ•āϰāĻž āύāĻĨāĻŋāϤ⧇ āϏ⧁āχāϚ āĻ•āϰ⧁āύāĨ¤ āĻĄāĻžāϟāĻž āϏāĻš āĻ•āĻ•ā§āώ⧇ āĻ•ā§āϞāĻŋāĻ• āĻ•āϰ⧁āύ āϝāĻž āφāĻĒāύāĻŋ āύāϤ⧁āύ āύāĻĨāĻŋāϤ⧇ āϏāĻ¨ā§āύāĻŋāĻŦ⧇āĻļ āĻ•āϰāĻžāϤ⧇ āϚāĻžāύāĨ¤

  4. āύāϤ⧁āύ āĻ¸ā§āĻĒā§āϰ⧇āĻĄāĻļā§€āĻŸā§‡ āĻĢ⧇āϰāϤ āϝāĻžāύāĨ¤ āχāύāĻĒ⧁āϟ āϰ⧇āĻ–āĻžāϝāĻŧ āφāĻĒāύāĻŋ āĻĻ⧇āĻ–āϤ⧇ āĻĒāĻžāϰ⧇āύ āĻ•āĻŋāĻ­āĻžāĻŦ⧇ LibreOffice Calc āϏ⧂āĻ¤ā§āϰ⧇ āφāĻĒāύāĻžāϰ āϜāĻ¨ā§āϝ āϰ⧇āĻĢāĻžāϰ⧇āĻ¨ā§āϏ āϝ⧁āĻ•ā§āϤ āĻ•āϰ⧇āĨ¤

    The reference to a cell of another document contains the fully qualified name of the other document between single quotes ('), then a hash #, then the name of the sheet of the other document, followed by a period and the name or reference of the cell.

    For example, .

    note

    The path and document name URI must always be enclosed in single quotes. If the name contains single quotes (') they must be escaped using two single quotes (''). Only a sheet name may not be quoted if it does not contain a space or a character that would be an operator or the name would be pure numeric (for example, '123' must be quoted).


  5. āϏāĻŦ⧁āϜ āĻĒāϰ⧀āĻ•ā§āώāύ āĻšā§€āĻšā§āύ⧇ āĻ•ā§āϞāĻŋāĻ• āĻ•āϰ⧇ āϏ⧂āĻ¤ā§āϰ āύāĻŋāĻļā§āϚāĻŋāϤ āĻ•āϰ⧁āύāĨ¤

  6. If you drag the box in the lower right corner of the active cell to select a range of cells, LibreOffice automatically inserts the corresponding references in the adjacent cells. As a result, the sheet name is preceded with a "$" sign to designate it as an absolute reference.

āϝāĻĻāĻŋ āφāĻĒāύāĻŋ āĻāχ āϏ⧂āĻ¤ā§āϰ⧇ āĻ…āĻ¨ā§āϝ āύāĻĨāĻŋāϰ āύāĻžāĻŽ āϏāϤāĻ°ā§āĻ•āϤāĻžāϰ āϏāĻžāĻĨ⧇ āĻĒāϰ⧀āĻ•ā§āώāĻž āĻ•āϰ⧇ āĻĻ⧇āϖ⧇āύ, āφāĻĒāύāĻŋ āϞāĻ•ā§āώ āĻ•āϰāĻŦ⧇āύ āϝ⧇ āĻāϟāĻŋ URLāĻšāĻŋāϏ⧇āĻŦ⧇ āϞ⧇āĻ–āĻž āĻšāϝāĻŧ⧇āϛ⧇āĨ¤ āĻāϰ āĻŽāĻžāύ⧇ āφāĻĒāύāĻŋ āχāĻ¨ā§āϟāĻžāϰāύ⧇āϟ āĻĨ⧇āϕ⧇ āĻāĻ•āϟāĻŋ URL āϏāĻ¨ā§āύāĻŋāĻŦ⧇āĻļ āĻ•āϰāĻžāϤ⧇ āĻĒāĻžāϰ⧇āύāĨ¤

Please support us!