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

In order to enter data in a cell, navigate to the desired cell with the arrow keys or mouse, and simply start typing.

To complete your entry, press the Enter key↵.

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

Alternatively, you can enter data via 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 F2 key. Alternatively, simply double-click on the cell.

Notes on entering numbers

▪Always enter numbers with the decimal separator specified in your computer's regional settings, for example, either the decimal comma usually used in Europe (0,7) or the decimal point used in the USA, UK and Ireland (0.7).

▪Numbers can also be entered in scientific (exponential) notation. For example, 4E03 corresponds to 4 * 10^3, which equals 4000. Alternatively: 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 worksheet cells at any time using the command group Number. For example, you can set PlanMaker to display numbers as percentages or as a currency with a currency symbol. For more information, see Number format.

Notes on entering dates and times:

▪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 a date with the year represented by only its last two digits, it is interpreted as follows:

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

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

Note: Dates and times are always stored as numbers in spreadsheets so that calculations can be performed with them. The number 0 represents 1/1/1900, the number 1 stands for 1/2/1900, etc. The time is stored in the decimal places of the number.

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

Tip: Use the key combination Ctrl+. (colon) 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 either TRUE or FALSE there.

Notes on entering calculations:

▪Formulas must always begin with the 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 example, =SUM(2, 5).

▪For more information on performing calculations, see Formulas and functions.

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

Notes on entering text:

▪Text can be easily typed into a cell.

▪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. If, for example, you enter '42 (including the single quotation mark), PlanMaker will treat this as text and not as a number.

▪Tip: If you have entered some text entries directly below each other in a column, 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: Furthermore, when you type text into a cell, PlanMaker automatically makes suggestions from the existing text entries found in the cells above and below this cell.