Skip to main content
Skip table of contents

Sheet reference

Refer to cells in the other table using the following notation.

<Sheet number>!<R1><C1>:<R2><C2>

<Sheet number> ← sequential number from the top table which starts from 1

<Rx> ← row number which starts from 1

<Cx> ← column string which starts from A

Header is excluded from the cell position target.
1!a1 will have the value 1.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.