Horizon Icon

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.

Cell Edit

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.

Comment Entry

The comment will appear in the balloon when you place your mouse pointer on the cell in the calendar.

Comment Display

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.

Cell Edit

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.

move demo

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.

copy demo

See also

Referencing Other Cells
Relative References
Repeating Cells
Functions
Cell Topics