Data input and referring to cells
Entering data and creating objects
In GeoGebra’s 
Spreadsheet View every cell has a specific name that allows you to directly address each cell.
Example: The cell in column A and row 1 is named A1.
You can use the Spreadsheet cells to create mathematical objects that are directly displayed in the 
Graphics View (e.g. points).
Spreadsheet View every cell has a specific name that allows you to directly address each cell.
Example: The cell in column A and row 1 is named A1.
You can use the Spreadsheet cells to create mathematical objects that are directly displayed in the Graphics View (e.g. points).Task
Enter data into the cells of the Spreadsheet.
Instructions
| 1. | A1 | Enter the number 10 into cell A1.
Hint: Always confirm your input by pressing the Enter key. |
| 2. | B1 | Enter the coordinates (-2, 2) into cell B1.
Note: The point B1 = (-2, 2) is automatically shown in the Graphics View. |
| 3. | 
| Select the Move tool and drag point B1 in the Graphics View.
Note: The Spreadsheet View shows the current position of point B1 in cell B1.
|
| 4. | 
| Delete the content of cell B1. |
Try it yourself...
Cell references
You can refer to another cell by using its name in your new input.
Note: If the content of this cell is modified, the new input adapts automatically.
Task
Enter data by referring to other cells of the Spreadsheet.
Instructions
| 1. | A1 | Change the number in cell A1 to 1.5 and confirm your input. |
| 2. | B1 | Enter the formula = 2 * into cell B1 and then select cell A1 to insert its name into the formula. Confirm your input.
Note: GeoGebra calculates 2 * 1.5 and displays the solution 3 in cell B1.
|
| 3. | A1 | Change the content of cell A1 to 3. Note: The content of cell B1 automatically adapts to your changes. |
| 4. | C1 | Enter the coordinates (A1, B1) into cell C1 and confirm your input.
Hint: Cell C1 now shows the coordinates (3, 6). The corresponding Point C1 is automatically displayed in the Graphics View. |
| 5. | A1 | Change the value of cell A1 to 2.
Note: The coordinates in cell C1 and the corresponding point automatically adapt to your changes.
|
Input Data into the Spreadsheet View
Manual Entry, Commands, and Tracing
Besides manually adding entries into the Spreadsheet View cells, you may use the commands FillColumn, FillRow or FillCells. You can also enter data by using the feature Tracing to Spreadsheet.
Copy Data from the 
Algebra View
With a simple drag and drop operation it is also possible to copy objects from the Algebra View to the Spreadsheet View.
If you drag a list, its elements will be pasted horizontally, starting from the cell in which you release the left mouse button or touchscreen. Pressing the Shift key while dragging opens a dialog window when the mouse button is released, allowing you to choose whether the pasted objects will be Free or Dependent, as well as to choose the vertical placement of the copied objects (check option Transpose).
Copy Data from Other Spreadsheet Software
GeoGebra allows you to import data from other spreadsheet software into the Spreadsheet View.
Spreadsheet View, then choose the Import Data File... option.
Spreadsheet View cells, you may use the commands FillColumn, FillRow or FillCells. You can also enter data by using the feature Tracing to Spreadsheet.
Copy Data from the Algebra View
With a simple drag and drop operation it is also possible to copy objects from the Algebra View to the Spreadsheet View.
If you drag a list, its elements will be pasted horizontally, starting from the cell in which you release the left mouse button or touchscreen. Pressing the Shift key while dragging opens a dialog window when the mouse button is released, allowing you to choose whether the pasted objects will be Free or Dependent, as well as to choose the vertical placement of the copied objects (check option Transpose).
Copy Data from Other Spreadsheet Software
GeoGebra allows you to import data from other spreadsheet software into the Spreadsheet View.
- Select and copy the data you want to import. For example, you may use the keyboard shortcut Ctrl + C (Mac OS: Cmd + C) in order to copy the data to your computer’s clipboard.
- Open a GeoGebra window and show the Spreadsheet View.
- Click on the spreadsheet cell that should contain the first data value (e.g. cell A1)
- Paste the data from your computer’s clipboard into GeoGebra’s Spreadsheet View. For example, you may select a cell and use the keyboard shortcut Ctrl + V (Mac OS: Cmd + V) in order to paste the data into the highlighted spreadsheet cell.
Spreadsheet View, then choose the Import Data File... option.