Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Mail Systems
Eclipse Documentation

How To Guides
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Problem Solutions
Privacy Policy




OpenOffice Calc 3.x Guide
Previous Page Home Next Page

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 blank summary sheet. We want to place the reference for the checking account balance in cell B3.

Blank summary

To make the cell reference in cell B3, select the cell and follow these steps.

  1. Click on the = icon next to the input line. The icons change and an equals sign appears in the input line as shown below.
  2. Equal sign in input line
  3. 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.
  4. Click on the checking account tab
  5. Click on cell F3 (where the balance is) in the Checking Account sheet.
  6. Return to the original sheet.
  7. The phrase ‘Checking Account’.F3 should appear in the input line as shown below.
  8. Cell reference selected
  9. Click the green checkmark in the input line to finish.
  10. The Summary sheet should now look like the figure below.
  11. Finished checking account reference

OpenOffice Calc 3.x Guide
Previous Page Home Next Page

  Published under the terms of the Creative Commons License Design by Interspire