On the Edit tab in the dialog box of the ribbon command File | Options 
, you can change settings for editing worksheet cells:
After input, move selection ...
This option determines the direction in which the cell frame (the dark frame that indicates the current cell on the screen) moves when you type something in the cell and press the Enter key↵.
Height of the input field
Here, you can set whether the single-line input field for formulas in the Edit toolbar should expand so that you can see the complete content even for long formulas. For more information, see Edit toolbar.
In-cell editing
This option is enabled by default. This means that you can edit the contents of a cell directly in the worksheet after pressing the F2 key. If you disable this option, the cell contents can only be edited in the Edit toolbar (displayed above the spreadsheet) after pressing F2.
Automatic percent input
This option determines how PlanMaker reacts when you type numbers into cells that contain percentages or are formatted with the "Percent" number format. If enabled, a percent sign is automatically added to your input.
Autocomplete cells
While you type text in a cell with this option enabled, PlanMaker automatically makes suggestions from the existing text entries found in the cells above and below this cell.
Example: You have entered the values "New York", "Rio", and "Tokyo" in a column. If you now go to the cell below these entries and type the letter "N", the program will automatically suggest "New York". If you type the letter "T", "Tokyo" will be suggested, etc.
To accept the suggestion, press the Enter key↵. To reject it, simply continue typing or press the Del key.
If you do not want PlanMaker to make suggestions while you are typing, you can always disable this option.
Left arrow key never exits cell editing
Use this option to specify what should happen when you navigate to a cell, type in a value and press the left arrow key ß:
▪On: The text cursor is moved to the left (within your input).
▪Off: The cell frame is moved to the left. This means that the value you enter is accepted, and the cell to the left of the current cell is made the active cell.
Warning if a formula contains errors
If you enter a formula that contains an error (for example, a closing parenthesis is missing), PlanMaker issues an error message when you press Enter↵. If you do not want that to happen, disable this option.
Note: Regardless of this option, incorrect formulas are generally replaced by the text #NULL! when you save the document.
Formula tooltip
If this option is enabled and you enter an arithmetic function in a cell, a tooltip providing information about the required function parameters appears below the cell.
Expand tables automatically
As described in the section Tables in worksheets, the ribbon command Insert | Table enables you to create "Tables in worksheets".
This option has the following effect on such tables:
▪On: When you enter something in one of the cells directly to the right of the table, the table is automatically expanded by another column. The same applies to rows: When you type something in a cell directly below the table, another row is added automatically.
▪Off: The table is not expanded automatically.
Number separators
Here, you can set which characters to use as the decimal separator and thousands separator for numbers.
Explanation: The decimal separator is the character that is placed in a number with decimal places (for example, the period in 17.50). The thousands separator is the character that can be used to group long digits (for example, the commas in 1,000,000).
▪If you select System default, PlanMaker automatically determines the decimal separator and thousands separator from your current system settings. (This is the default setting.)
▪If you switch to Custom, PlanMaker lets you specify a custom decimal separator and thousands separator.
Warning: If you specify custom settings that are incorrect, calculations may return invalid or wrong results!
If you select several cells, their sum is automatically displayed in the status bar per "Online calculation". However, you can also specify other calculation methods here. You can even select several calculation options, the results of which are then displayed next to each other in the status bar.
Tip: You can also set the options for "Calculation in status bar" directly in the status bar itself. To do so, click in the status bar – at the point where the result of the calculation is displayed.