
Working with Cells
To create a new cell, click once on a date box in the calendar. The background of the date box turns the same color as the active category. Now click on the 'Add Cell' button on the toolbar, or double click on the date box again. A new cell appears in the date box, with the edit field active. Type in a value or some text and press 'enter' or 'return'.
To create a value cell, just enter a number in the edit field. The value will be formatted as a dollar amount, unless you have changed the setting for the category.
You can add a comment to any cell clicking the 'Comment' button in the toolbar. An empty text balloon appears next to the cell. You can type a comment in here and the balloon will expand to hold your text.
The comment will appear in the balloon when you place your mouse pointer on the cell in the calendar.
To create a simple equation, make a new cell, and enter an ‘equals’ sign as the first character. Now enter a formula or expression. When you press Return, Horizon evaluates the expression, and displays the answer in the cell on the calendar. Horizon understands +. -. *, / and brackets for precedence.
To change the value of an existing cell, click once to edit it, or click once in the date box to select it, and click on the 'Edit Cell' button in the toolbar. The value or equation will appear in the edit field. Make your changes and press return.
To delete a cell, make sure you have the cell's category selected. Then click once in the day of the cell to select that day, and click on the 'Delete Cell' button in the toolbar. You can also click once on the cell to edit it, then clear all text from the edit box. Press Return, and the cell will disappear.
If you change your mind in the middle of an edit, click on the 'Cancel Edit' button on the toolbar, or press 'Esc'. The edit box will clear, and all changes will be canceled.
To move a cell to a different date, click and hold, then drag it to the new location. Drop the cell on the new location.
Copy works the same as move. Just hold the alt/option key while dragging, and you can drag a copy of the cell to a new location.
See also
Referencing Other Cells
Relative References
Repeating Cells
Functions
Cell Topics