Entering data
Tabulys infers the type of what you type: text, numbers, booleans, percentages, currency, fractions, dates, times, or formulas beginning with =. Numbers, dates and times are typed in the regional format of your language, as in Excel: in English 1,234.5 and 1/15/2024, in Italian 1.234,5 and 15/01/2024, with month names and the TRUE and FALSE words of the language. Formulas stay in English, with commas between arguments.
- Select a cell and start typing to overwrite its contents.
- Press F2 to edit the existing contents in place instead of replacing them.
- Or double-click the cell, or click the cell that is already selected: editing starts with the cursor where you clicked.
- Confirm with Enter to move down, Shift+Enter to move up, or Tab to move right.
- Shift+Tab confirms and moves left. After a series of Tab presses, Enter moves to the next row in the column where you started.
- When the rows above form a table that ends in the current column, Tab moves on its own to the start of the next row; press Right Arrow to go past the edge of the table.
- Press Esc to cancel the edit and keep the previous value.
- Press Delete to clear the contents of the selection.
Tip Type a value like 50%, 0 1/4 or a date and Tabulys applies the matching number format automatically. In a cell already formatted as a percentage, typing 12 gives 12%. Start with an apostrophe, or format the cell as Text, to keep what you type as text: '00123 stays 00123. The formula bar and F2 show the value in the same regional format, so confirming it again changes nothing.