<< Click to Display Table of Contents >> Entering data in cells

In order to enter data into a cell, navigate to the desired cell with the arrow keys or mouse, and begin typing.

To complete your input, press the Enter key↵.

If you made an error during input, press the Esc key instead of the Enter key↵. PlanMaker discards what you just typed and restores the original cell content.

Alternatively, use the following buttons of the Edit toolbar:

▪To accept the input, click on the button.

▪To cancel the input, click on the button.

To subsequently edit the contents of a cell, navigate to the cell and press the key F2. Alternatively, simply double-click on the cell.

Notes on entering numbers

▪Always enter numbers with the decimal separator specified in the country settings of your computer. Either the decimal point commonly used in Europe (0.7) or the decimal point commonly used in the USA (0.7).

▪Numbers can also be entered in scientific (exponential) notation. 4E03, for example, corresponds to 4 * 10^3, which equals 4000. 4E-03 corresponds to 4 * 10^-3, which equals 0.004.

▪Numbers can also be entered as fractions. For example, 2 1/2 corresponds to 2.5.

▪Numbers can also be entered as percentages. For example, 70% corresponds to 0.7.

On the ribbon tab Home, you can change the format of numbers in table cells at any time using the command group Number. For example, you can tell PlanMaker to display numbers as percentages or as a currency with a currency symbol. For more information, see Number format.

Notes on entering dates

▪Dates can be entered in various formats; for example, 09/25/18 or 9/25/2018 etc.

▪You can enter dates between January 1st, 1900 and December 31st, 2500.

▪If you enter the year with only the last two digits, it is interpreted as follows:

▪Times can be entered in numerous formats. For example, you can enter the time 09:30 as follows:

▪You can combine a date and a time in a single cell by typing the date, a space, and the time. For example, when you type in 9/25/18 6:00, PlanMaker knows that you mean the 25th of September 2018 at 6:00 am.

Note: Spreadsheets store dates and times internally as numbers (so that calculations can be carried out with them). The number 0 represents 1/1/1900, the number 1 stands for 1/2/1900, etc. The time is stored in the fractional part of the number.

However, you don't have to worry about this. Simply enter dates and times in your preferred way. PlanMaker automatically converts your input into a number but will display it formatted in date/time format. To learn more about changing the format of dates and times, see Number format.

Tip: Press the shortcut Ctrl+. (period) to enter the current date in a flash and Ctrl+Shift+. to enter the current time.

Notes on entering logical values (Boolean values)

▪To enter a logical value in a cell, type in either TRUE or FALSE.

Notes on entering formulas

▪Formulas must always begin with an equal sign; e.g., =2+5.

▪The command Insert function in the Edit toolbar can be used to easily insert arithmetic functions. Of course you can also input formulas manually.

▪For more information on creating formulas, see Formulas and functions.

▪For descriptions of all arithmetic functions, see Functions from A to Z.

Notes on entering text

▪To input text in a cell, simply type it in.

▪In some rare cases, you may want to "force" PlanMaker to consider a number as text. This can be achieved by putting a single quotation mark in front of the number. For example, when you enter '42 (including the single quotation mark), PlanMaker will treat this as text, not as a number.

▪Tip: When you have entered several text entries in a column (one on top of each other), you can open a dropdown list of these entries by pressing the key combination Alt+Shift+â in a cell directly above or below the entries.

▪Another tip: In addition, while you type text in a cell, PlanMaker automatically makes suggestions from the existing text entries found in the cells above and below this cell.