Difference between revisions of "Documentation/OOo3 User Guides/Calc Guide/Referencing other sheets"
(New page: {{DISPLAYTITLE:Referencing other sheets}} {{Documentation/CG3Ch9TOC |ShowPrevNext=block |PrevPage=Documentation/OOo3_User_Guides/Calc Guide/Using multiple sheets |NextPage=Documentation/OO...) |
|||
(4 intermediate revisions by one other user not shown) | |||
Line 5: | Line 5: | ||
|NextPage=Documentation/OOo3_User_Guides/Calc Guide/Referencing other documents | |NextPage=Documentation/OOo3_User_Guides/Calc Guide/Referencing other documents | ||
}} | }} | ||
− | On the ''Summary ''sheet'' ''we display the balance from each of the other sheets. If you | + | On the ''Summary ''sheet'' ''we display the balance from each of the other sheets. If you copy the example above onto each account, the current balances will be in cell F3 of each sheet. |
There are two ways to reference cells in other sheets: by entering the formula directly using the keyboard or by using the mouse. We will look at the mouse method first. | There are two ways to reference cells in other sheets: by entering the formula directly using the keyboard or by using the mouse. We will look at the mouse method first. | ||
== Creating the reference with the mouse == | == Creating the reference with the mouse == | ||
− | On the ''Summary'' sheet, set up a place for all five account balances, so we know where to put the cell reference. The figure below shows a | + | On the ''Summary'' sheet, set up a place for all five account balances, so we know where to put the cell reference. The figure below shows a summary sheet with a blank Balance column. We want to place the reference for the checking account balance in cell B3. |
[[Image:CG3Ch9F6.png|thumb|none|500px|''Blank summary'']] | [[Image:CG3Ch9F6.png|thumb|none|500px|''Blank summary'']] | ||
Line 25: | Line 25: | ||
[[Image:CG3Ch9F8.png|thumb|none|500px|''Click on the checking account tab'']] | [[Image:CG3Ch9F8.png|thumb|none|500px|''Click on the checking account tab'']] | ||
− | <li>Click on cell F3 (where the balance is) in the ''Checking Account'' sheet. | + | <li>Click on cell F3 (where the balance is) in the ''Checking Account'' sheet. The phrase <nowiki>‘Checking Account’.F3</nowiki> should appear in the input line as shown below.</li> |
− | |||
− | |||
[[Image:CG3Ch9F9.png|thumb|none|500px|''Cell reference selected'']] | [[Image:CG3Ch9F9.png|thumb|none|500px|''Cell reference selected'']] | ||
Line 38: | Line 36: | ||
== Creating the reference with the keyboard == | == Creating the reference with the keyboard == | ||
− | From the figure above, you can deduce how the cell reference is constructed. The reference has two parts: the sheet name and the cell | + | From the figure above, you can deduce how the cell reference is constructed. The reference has two parts: the sheet name (''<nowiki>’Checking Account’</nowiki>'') and the cell reference (''F3''). Notice that they are separated by a period. |
− | + | {{Note| The sheet name is in single quotes because it contains a space, and the mandatory period (.) always falls outside any quotes.}} | |
So, you can fill in the Savings Account cell reference by just typing it in. Assuming that the balance is in the same cell in the ''Savings Account'' sheet, F3, the cell reference should be ''<nowiki>=’Savings Account’.F3</nowiki>''. | So, you can fill in the Savings Account cell reference by just typing it in. Assuming that the balance is in the same cell in the ''Savings Account'' sheet, F3, the cell reference should be ''<nowiki>=’Savings Account’.F3</nowiki>''. | ||
− | + | [[Image:CG3Ch9F11a.png|thumb|none|500px|''Savings account reference]] | |
− | |||
{{CCBY}} | {{CCBY}} | ||
[[Category: Calc Guide (Documentation)]] | [[Category: Calc Guide (Documentation)]] |
Latest revision as of 20:41, 6 July 2018
< {{#switch:Previous Page | Previous Section = Previous Section | Next Section = Next Section | Previous Page = Previous Page | Next Page = Next Page | }} | {{#switch:Next Page | Previous Section = Previous Section | Next Section = Next Section | Previous Page = Previous Page | Next Page = Next Page | }} > |
On the Summary sheet we display the balance from each of the other sheets. If you copy the example above onto each account, the current balances will be in cell F3 of each sheet.
There are two ways to reference cells in other sheets: by entering the formula directly using the keyboard or by using the mouse. We will look at the mouse method first.
Creating the reference with the mouse
On the Summary sheet, set up a place for all five account balances, so we know where to put the cell reference. The figure below shows a summary sheet with a blank Balance column. We want to place the reference for the checking account balance in cell B3.
To make the cell reference in cell B3, select the cell and follow these steps.
- Click on the = icon next to the input line. The icons change and an equals sign appears in the input line as shown below.
- Now, click on the sheet tab for the sheet containing the cell to be referenced. In this case, that is the Checking Account sheet as shown below.
- Click on cell F3 (where the balance is) in the Checking Account sheet. The phrase ‘Checking Account’.F3 should appear in the input line as shown below.
- Click the green checkmark in the input line to finish.
- The Summary sheet should now look like the figure below.
Creating the reference with the keyboard
From the figure above, you can deduce how the cell reference is constructed. The reference has two parts: the sheet name (’Checking Account’) and the cell reference (F3). Notice that they are separated by a period.
The sheet name is in single quotes because it contains a space, and the mandatory period (.) always falls outside any quotes. |
So, you can fill in the Savings Account cell reference by just typing it in. Assuming that the balance is in the same cell in the Savings Account sheet, F3, the cell reference should be =’Savings Account’.F3.
Content on this page is licensed under the Creative Common Attribution 3.0 license (CC-BY). |