Welcome!
Technical support
About this manual
System requirements
Installation and program startup
Installing on Windows
Installing on macOS
Installing on Linux
Installing on Android devices
Installing on iOS devices
Application window
Title bar
User interface: Ribbon
User interface: Classic menus
User interface on Android/iOS
Context menu
Edit toolbar
Document tabs
Worksheet register
Status bar
Basics
The structure of a spreadsheet
Moving within a worksheet
Entering data
Deleting data
Undoing changes
Starting a new document
Opening a document
Printing a document
Saving a document
Exiting the application
The PlanMaker tour
Some theory to begin with
First steps with PlanMaker
Entering values and formulas
Going three-dimensional
Changing the layout of worksheets
Charts
Outlook
Editing worksheets
Entering data in cells
Undoing changes
Repeating commands
Selecting cells and cell content
Selecting in the Windows, Mac or Linux version
Selecting in the Android/iOS version
Deleting cells and cell content
Deleting the content of cells
Deleting whole cells
Deleting empty rows
Deleting duplicate rows
Inserting new cells
Inserting copied cells
Moving and copying
Paste (special)
Filling cells automatically
Working with multiple worksheets
Creating new worksheets
Working with the worksheet register
Managing worksheets
Calculating in three dimensions
Naming cell ranges
Assigning and editing names for cell ranges
Defining names automatically from the selection
Creating a list of all named ranges
Using named ranges
Applying names to existing formulas
Transposing cells
Splitting text into multiple columns
Sorting cells
Filtering cells by their content
AutoFilter
Special filter
Analyzing sheets
Displaying formulas instead of results
Syntax highlighting
Watch window for cell content
Formula auditing
Displaying the relationships between cells
Detecting errors in calculations
Detecting invalid data in cells
Updating sheets
Using comments
Goal seek
Scenarios
Creating scenarios
Showing scenarios
Managing scenarios
Merging scenarios
Creating a scenario summary
Consolidating data
Consolidating data by position
Consolidating data by labels
Editing and updating consolidations
Tables in worksheets
Creating tables in worksheets
Ribbon tab "Table"
Removing tables from worksheets
Editing tables in worksheets
Formatting tables in worksheets
Using the total row of tables in worksheets
Tables in worksheets and cell references
Pivot tables
Creating a new pivot table
Creating a pivot table with existing data
Creating a pivot table with imported data
Starting with the pivot table field list
Exercises using the field list
Working with the field list: Fields section
Working with the field list: Areas section
Further options in the field list
Configuring pivot tables with the field list
Field settings (Row/column labels area)
Value settings (Values area)
Pivot table settings
Defer layout update
Sorting and filtering pivot tables
Grouping pivot tables
Updating pivot tables and changing data range
Deleting, copying, moving pivot tables
Freezing rows and columns
Inserting special characters
Formatting worksheets
Cell size
Changing cell sizes via the mouse
Changing cell sizes via commands
Showing and hiding rows/columns
Number format
List of all number formats
Working with custom number formats
Structure of a custom number format
Borders
Shading
Alignment
Protection
Character format
Font and font size
Text styles
Font color
Superscripts and subscripts
Letter spacing and character pitch
Kerning
Resetting the character formatting
Paragraph format (text frames only)
Paragraph indents (text frames only)
Line spacing (text frames only)
Paragraph alignment (text frames only)
Spacing above/below a paragraph (text frames only)
Character styles
Creating character styles
Applying character styles
Changing character styles
Scope of character styles
"Normal" character style
"Based on" character styles
Cell styles
Applying cell styles
Creating cell styles
Changing cell styles
"Normal" cell style
Document templates
Creating document templates
Using document templates
Changing document templates
"Normal.pmvx" document template
AutoFormat
Conditional formatting
Creating new formatting rules
Types of conditional formatting
Managing formatting rules
Removing conditional formatting
Input validation
Settings for input validation
Detect invalid data
Format painter
Page setup
Set page format
Setting page format options
Setting up headers and footers
Adjusting page breaks manually
Searching and replacing
Search
Replace
Repeating a search/replace
Advanced search options
Jumping to specific cell addresses
Jumping to specific elements of a table
Objects
Objects – basic procedures
Inserting objects
Selecting objects
Object mode
Changing position and size of objects
Rotating and flipping objects
Changing the order of objects
Duplicating objects
Changing the names of objects
Aligning and distributing objects
Grouping objects
Hiding objects
Changing the AutoShape of objects
Combining shapes
Editing shapes retroactively
Changing object properties via the dialog box
Object properties, Format tab
Object properties, Fill tab
Object properties, Lines tab
Object properties, Shadow tab
Object properties, 3D tab
Object properties, Effects tab
Object properties, Properties tab
Object properties, AutoShapes tab
Additional tabs
Changing the default settings for objects
Text frames
Inserting text frames
Changing text frame properties via the ribbon tab
Changing text frame properties via the dialog box
Changing the text area
Pictures
Inserting pictures
Scanning pictures
Inserting pictures from the gallery/camera (Android and iOS)
Changing picture properties via the ribbon tab
Changing picture properties via the dialog box
OLE objects
Inserting OLE objects
Editing OLE objects
Editing links to OLE objects
Changing OLE object properties via the ribbon tab
Changing OLE object properties via the dialog box
Using the SoftMaker Equation Editor
Drawings
Inserting drawings
Adding text to AutoShapes
Changing drawing properties via the ribbon tab
Changing drawing properties via the dialog box
AutoShapes tab (available only for AutoShapes)
Inner text tab (available for AutoShapes with text added)
Text tab (available only for TextArt objects)
Transformation tab (available only for TextArt objects)
Charts
Inserting charts
Editing charts
Changing the chart type
Changing the arrangement of data series
Showing/hiding chart elements
Showing/hiding axes and axis titles
Showing/hiding chart titles
Showing/hiding data labels
Showing/hiding error bars
Showing/hiding gridlines
Showing/hiding the legend
Showing/hiding lines
Showing/hiding the trendline
Showing/hiding up/down bars
Editing chart elements
Chart area
Plot area
Walls (three-dimensional charts only)
Floor (three-dimensional charts only)
Corners (three-dimensional charts only)
Data series and data points
Trendlines
Category axis (X axis)
Value axis (Y axis)
Series axis (Z axis)
Axis title
Chart title
Gridlines
Legend
Changing chart properties via the dialog box
Chart properties, Format tab
Chart properties, Properties tab
Chart properties, Chart type tab
Chart properties, Data source tab
Chart properties, Series tab
Chart properties, Elements tab
Chart properties, 3D view tab
Chart properties, Radar tab
Updating charts
Moving charts to another worksheet
Saving charts as pictures
Forms
Working with form objects
Inserting form objects
Editing form objects
Using and evaluating form objects
Form objects and Excel macros and scripts
Form objects in detail
Checkboxes
Changing the properties of checkboxes
Radio buttons
Changing the properties of radio buttons
Dropdown lists
Changing the properties of dropdown lists
Listboxes
Changing the properties of listboxes
Pushbuttons
Changing the properties of pushbuttons
Spinners
Changing the properties of spinners
Scrollbars
Changing the properties of scrollbars
Labels and groupboxes
Changing the properties of labels and groupboxes
Options of the contextual ribbon tab "Object"
Language tools
Setting the language
Spell check
Manual spell check
Check spelling as you type
Editing user dictionaries
Hyphenation
Hyphenation in text frames
Hyphenation in table cells
Research
SmartText
Creating SmartText entries
Inserting SmartText entries
Editing SmartText entries
Document management
Quick paths
Document summary
File manager
Searching with the file manager
Backup copies (file versions)
Outlines
Grouping cells
Showing/hiding grouped cells
Changing outline settings
Internet functions
Using hyperlinks
Saving documents in HTML format
Outputting documents
Print preview
Printing a document
Exporting a document as a PDF file
Sending a document by e-mail
Protecting cells and documents
Sheet protection
Step 1: Setting up protection settings for cells
Step 2: Enabling sheet protection
Disabling sheet protection
Workbook protection
Enabling workbook protection
Disabling workbook protection
Document protection
Enabling document protection
Disabling document protection
Working with other file formats
Saving and opening files in other file formats
Notes on the text format
Notes on the Excel format
Opening and saving Excel files
Differences between PlanMaker and Excel
Working with Arabic text
Enabling extended support for Arabic text
Changing the text direction in table cells
Changing the text direction in text frames
Changing the direction of worksheets
Scripts (BasicMaker)
Working with multiple documents
Creating or opening a document
Switching between open documents
Arranging documents on the screen
Closing a document
Customizing PlanMaker
Changing PlanMaker settings
Settings, View tab
Settings, General tab
Settings, Edit tab
Settings, Appearance tab
Settings, Language tab
Settings, Files tab
Settings, Backup tab
Settings, System tab
Settings, Fonts tab
"Manage" button
Export/import settings
Changing document properties
Document properties, Summary tab
Document properties, Colors tab
Document properties, Statistics tab
Document properties, Options tab
Document properties, Calculate tab
Document properties, Protection tab
Document properties, Fonts tab
Changing worksheet properties
Customizing the document display
Zoom level
Full screen view
Customizing the ribbon
Showing and hiding the ribbon
Customizing icons and groups in the ribbon
Changing the position of the Quick access toolbar
Customizing icons on the Quick access toolbar
Customizing toolbars
Showing and hiding toolbars
Positioning toolbars on the screen
Managing toolbars
Customizing toolbar icons
Using the toolbar menu
Creating user-defined icons
Customizing shortcut keys
Editing lists for automatic filling
Installing additional dictionaries
Installing additional SoftMaker dictionaries
Installing Hunspell dictionaries
Choosing a different dictionary for a language
Formulas and functions
Formula basics
Operators in formulas
Entering formulas
Relative versus absolute cell references
External cell references
Entering external cell references
Updating and managing external cell references
Error values
Working with arrays
Working with database functions
Functions from A to Z
ABS (absolute value)
ACOS (arccosine)
ACOSH (inverse hyperbolic cosine)
ACOT (arccotangent)
ACOTH (inverse hyperbolic cotangent)
ADDRESS (cell address as text)
AND (logical AND function)
AREAS (number of areas)
ASIN (arcsine)
ASINH (inverse hyperbolic sine)
ATAN (arctangent)
ATAN2 (arctangent 2)
ATANH (inverse hyperbolic tangent)
AVEDEV (average deviation)
AVERAGE (arithmetic mean)
AVERAGEA (arithmetic mean)
AVERAGEIF (average if condition is true)
AVERAGEIFS (average if conditions are true)
B (compatibility function)
BASE (convert decimal number into another base)
BESSELI (modified Bessel function In(x))
BESSELJ (Bessel function Jn(x))
BESSELK (modified Bessel function Kn(x))
BESSELY (Bessel function Yn(x))
BETADIST (beta distribution)
BETA.DIST (beta distribution)
BETAINV (percentiles of the beta distribution)
BETA.INV (percentiles of the beta distribution)
BIN2DEC (binary number to decimal number)
BIN2HEX (binary number to hexadecimal number)
BIN2OCT (binary number to octal number)
BINOMDIST (binomial distribution)
BINOM.DIST (binomial distribution)
BINOM.DIST.RANGE (binomial distribution)
BINOM.INV (binomial distribution)
CEILING (round up to a multiple of base)
CELL (information about a cell)
CHAR (character from ANSI code)
CHIDIST (chi-square distribution)
CHIINV (percentiles of the chi-square distribution)
CHISQ.DIST.RT (chi-square distribution)
CHISQ.INV.RT (percentiles of the chi-square distribution)
CHISQ.TEST (chi-square test for independence)
CHITEST (chi-square test for independence)
CHOICE (x>0, x=0, x<0?)
CHOOSE (choose value from list)
CLEAN (remove non-printable characters)
CODE (ANSI code of a character)
COLUMN (column number of cells)
COLUMNS (number of columns in a range)
COMBIN (combinations)
COMPLEX (create complex number)
CONCAT (concatenate strings from list)
CONCATENATE (concatenate text strings)
CONFIDENCE (confidence interval)
CONFIDENCE.NORM (confidence interval)
CONVERT (unit conversion)
CORREL (correlation coefficient)
COS (cosine)
COSH (hyperbolic cosine)
COT (cotangent)
COTH (hyperbolic cotangent)
COUNT (number of cells filled with numbers)
COUNTA (number of cells filled)
COUNTBLANK (number of blank cells)
COUNTIF (count if condition is true)
COUNTIFS (count if conditions are true)
COUNTP (PlanMaker 97 compatibility function)
COVAR (population covariance)
COVARIANCE.P (population covariance)
COVARIANCE.S (sample covariance)
CREATEDATE (date the document was created)
CRITBINOM (binomial distribution)
CUMIPMT (cumulative interest)
CUMPRINC (cumulative principal)
CURRENCY (format number as currency)
DATE (create a date value)
DATEDIF (date difference)
DATEVALUE (convert text into date value)
DAVERAGE (database function)
DAY (day of a date)
DAYS (days between two dates)
DAYS360 (days between two dates)
DAYSP (compatibility function)
DAYSPERMONTH (days per month)
DAYSPERYEAR (days per year)
DB (fixed-declining balance depreciation)
DCOUNT (database function)
DCOUNTA (database function)
DDB (double-declining balance depreciation)
DEC2BIN (decimal number to binary number)
DEC2HEX (decimal number to hexadecimal number)
DEC2OCT (decimal number to octal number)
DECIBEL (decibel value of two quantities)
DECIMAL (convert number from any base into decimal)
DECIMALS (fractional part of a number)
DEGREES (convert radians to degrees)
DELTA (test for equality)
DEVSQ (average square deviation)
DGET (database function)
DMAX (database function)
DMIN (database function)
DOLLARDE (convert to dollar price decimal)
DOLLARFR (convert to dollar price fraction)
DPRODUCT (database function)
DSTDEV (database function)
DSTDEVP (database function)
DSUM (database function)
DVAR (database function)
DVARP (database function)
EDATE (date before/after n months)
EFFECT (effective interest rate)
EOMONTH (end of month in n months)
ERF (Gaussian error function)
ERFC (complement to Gaussian error function)
ERROR.TYPE (error type)
EUROCONVERT (convert EU currencies)
EVEN (round up to next even number)
EXACT (compare texts)
EXP (power of e)
EXPONDIST (exponential distribution)
EXPON.DIST (exponential distribution)
FACT (factorial)
FACTDOUBLE (double factorial)
FALSE (logical value FALSE)
FDIST (F distribution)
F.DIST.RT (F distribution)
FILENAME (file name of the document)
FIND (search for text)
FINV (percentiles of the F distribution)
F.INV.RT (percentiles of the F distribution)
FISHER (Fisher transformation)
FISHERINV (inverse of the Fisher transformation)
FIXED (format number as text with fixed decimals)
FLOOR (round down to a multiple of base)
FORECAST (forecast using linear regression)
FORMULATEXT (display formula contained in cell)
FREQUENCY (frequency)
FTEST (F-test)
F.TEST (F-test)
FV (future value)
FVSCHEDULE (future value)
GAMMA (gamma function)
GAMMADIST (gamma distribution)
GAMMA.DIST (gamma distribution)
GAMMAINV (percentiles of the gamma distribution)
GAMMA.INV (percentiles of the gamma distribution)
GAMMALN (logarithm of the gamma function)
GAUSS (standard normal distribution)
GCD (greatest common divisor)
GEOMEAN (geometric mean)
GESTEP (number greater or equal to threshold value?)
GETPIVOTDATA
GROWTH (values of an exponential regression)
HARMEAN (harmonic mean)
HEX2BIN (hexadecimal number to binary number)
HEX2DEC (hexadecimal number to decimal number)
HEX2OCT (hexadecimal number to octal number)
HLOOKUP (look up row-wise)
HOLIDAY (dates of movable Christian holidays)
HOUR (hour)
HYPERLINK (hyperlink)
HYPGEOMDIST (hypergeometric distribution)
HYPGEOM.DIST (hypergeometric distribution)
IF (if-then-else condition)
IFS (first condition met)
IFEMPTY (return a value if cell is empty)
IFERROR (return a value upon encountering error)
IFNA (return defined value for #N/A)
IMABS (absolute value of a complex number)
IMAGINARY (imaginary coefficient of a complex number)
IMARGUMENT (angle of a complex number)
IMCONJUGATE (conjugate a complex number)
IMCOS (cosine of a complex number)
IMDIV (division of complex numbers)
IMEXP (exponential of a complex number)
IMLN (natural logarithm of a complex number)
IMLOG10 (base-10 logarithm of a complex number)
IMLOG2 (base-2 logarithm of a complex number)
IMNEG (negative value of a complex number)
IMPOWER (power of a complex number)
IMPRODUCT (product of complex numbers)
IMREAL (real coefficient of a complex number)
IMSIN (sine of a complex number)
IMSQRT (square root of a complex number)
IMSUB (difference of complex numbers)
IMSUM (sum of complex numbers)
INDEX (cell in a particular row/column of a range)
INDIRECT (create reference from text)
INT (round down to nearest integer)
INTERCEPT (intercept point of a regression line)
INTERSECTION (intersection of two ranges)
IPMT (interest payment)
IRR (internal rate of return)
ISBLANK (is empty?)
ISERR (is an error value other than #N/A?)
ISERROR (is an error value?)
ISEVEN (is an even number?)
ISFORMULA (is a formula?)
ISLOGICAL (is a logical value?)
ISNA (is not available?)
ISNONTEXT (is no text?)
ISNUMBER (is numeric?)
ISNUMBERP (PlanMaker 97 compatibility function)
ISODD (is an odd number?)
ISOWEEK (ISO week number)
ISOWEEKNUM (ISO week number)
ISPMT (interest payment)
ISREF (is a valid reference?)
ISTEXT (is text?)
KURT (kurtosis)
LARGE (k-th largest number)
LASTPRINTED (date last printed)
LASTSAVED (date last saved)
LCM (least common multiple)
LEN (length)
LEFT (left part of a text string)
LINEST (statistics of a linear regression)
LN (natural logarithm)
LOG (logarithm)
LOG10 (base-10 logarithm)
LOGEST (statistics of an exponential regression)
LOGINV (percentiles of the lognormal distribution)
LOGNORMDIST (lognormal distribution)
LOGNORM.DIST (lognormal distribution)
LOGNORM.INV (percentiles of the lognormal distribution)
LOOKUP (search cell range)
LOWER (convert text to lower case)
MATCH (relative position in a range)
MAX (maximum)
MAXA (maximum)
MAXIFS (conditional maximum)
MDETERM (matrix determinant)
MEDIAN (Median)
MID (part of a text string)
MILLISECONDS (milliseconds)
MIN (minimum)
MINA (minimum)
MINIFS (conditional minimum)
MINUTE (minute)
MINVERSE (inverse matrix)
MIRR (modified internal rate of return)
MMULT (product of matrices)
MOD (remainder of a division, Excel method)
MODE (most frequently occurring value)
MODE.SNGL (most frequently occurring value)
MODP (remainder of a division, PlanMaker method)
MONTH (month of a date)
MROUND (round to a multiple of base)
MSOLVE (solution of matrix equation Ax=B)
MULTINOMIAL (multinomial coefficient)
N (convert value into number)
NA (error value #N/A)
NEG (negative value)
NEGBINOMDIST (negative binomial distribution)
NEGBINOM.DIST (negative binomial distribution)
NETWORKDAYS (number of workdays)
NOMINAL (nominal interest rate)
NORMDIST (normal distribution)
NORM.DIST (normal distribution)
NORMINV (percentiles of the normal distribution)
NORM.INV (percentiles of the normal distribution)
NORMSDIST (standard normal distribution)
NORM.S.DIST (standard normal distribution)
NORMSINV (percentiles of the standard distribution)
NORM.S.INV (percentiles of the standard distribution)
NOT (logical NOT function)
NOW (current date and time)
NPER (number of periods)
NPV (net present value)
NUMBERVALUE (convert text to a number, locale)
OCT2BIN (octal number to binary number)
OCT2DEC (octal number to decimal number)
OCT2HEX (octal number to hexadecimal number)
ODD (round up to next odd number)
OFFSET (shifted reference)
OR (logical OR function)
PEARSON (Pearson correlation coefficient)
PERCENTILE (percentiles of a data set)
PERCENTILE.EXC (percentiles of a data set)
PERCENTILE.INC (percentiles of a data set)
PERCENTRANK (percent rank in a data set)
PERCENTRANK.EXC (percent rank in a data set)
PERCENTRANK.INC (percent rank in a data set)
PERIOD (duration of fixed-interest investments)
PERMUT (permutations)
PHI (standard normal distribution)
PI (pi)
PMT (payment)
POISSON (Poisson distribution)
POISSON.DIST (Poisson distribution)
POLYNOMIAL (polynomial coefficient)
POWER (power)
PPMT (payment on the principal)
PROB (probability)
PRODUCT (product)
PROPER (convert text to upper/lower case)
PV (present value)
QUARTILE (quartiles of a data set)
QUARTILE.EXC (quartiles of a data set)
QUARTILE.INC (quartiles of a data set)
QUOTIENT (quotient of a division)
RADIANS (convert degrees to radians)
RAND (random value)
RANDBETWEEN (random value)
RANK (rank in a data set)
RANK.AVG (rank in a data set)
RANK.EQ (rank in a data set)
RATE (interest rate per period)
REPLACE (replace text in a text string)
REPT (repeat text string)
RIGHT (right part of a text string)
ROMAN (Roman numeral)
ROOTN (n-th root)
ROUND (round to n digits)
ROUNDDOWN (round down to n digits)
ROUNDUP (round up to n digits)
ROW (row number of cells)
ROWS (number of rows in a range)
RRI (interest for fixed-interest investments)
RSQ (square of Pearson)
SEARCH (search for text)
SECOND (second)
SERIESSUM (sum of a power series)
SHEET (index of a worksheet)
SHEETNAME (name of a worksheet)
SHEETNUMBER (compatibility function)
SHEETS (number of worksheets)
SIGN (sign of a number)
SIN (sine)
SINH (hyperbolic sine)
SKEW (skewness of a distribution)
SLN (straight-line depreciation)
SLOPE (slope of a linear trend)
SMALL (k-th smallest number)
SORTM (sort)
SORTV (sort)
SQRT (square root)
SQRTPI (square root of x*Pi)
STANDARDIZE (standardized value)
STDEV (standard deviation of a sample)
STDEVA (standard deviation of a sample)
STDEVP (standard deviation of entire population)
STDEV.P (standard deviation of entire population)
STDEVPA (standard deviation of entire population)
STDEV.S (standard deviation of a sample)
STEYX (standard error of a linear regression)
SUBSTITUTE (replace text in a text string)
SUBTOTAL (calculations without hidden cells)
SUM (Sum)
SUMIF (sum if condition is true)
SUMIFS (sum if conditions are true)
SUMPRODUCT (sum of products)
SUMSQ (sum of squares)
SUMX2MY2 (sum of x^2 - y^2)
SUMX2PY2 (sum of x^2 + y^2)
SUMXMY2 (sum of (x - y)^2)
SWITCH (categorize initial value)
SYD (sum-of-years’ digits depreciation)
T (convert value into text string)
TAN (tangent)
TANH (hyperbolic tangent)
TDIST (t-distribution)
T.DIST (t-distribution)
T.DIST.2T (t-distribution two-tailed)
T.DIST.RT (t-distribution right-tailed)
TEXT (convert number into text string)
TEXTJOIN (concatenate strings with separators)
TIME (create time)
TIMEDIFF (time difference)
TIMEVALUE (convert text into time)
TINV (percentiles of the t-distribution)
T.INV (percentiles of the t-distribution left-tailed)
T.INV.2T (percentiles of the t-distribution two-tailed)
TODAY (current date)
TRANSPOSE (transpose matrix)
TREND (values of a linear regression)
TRIM (remove spaces from text)
TRIMMEAN (mean without marginal values)
TRUE (logical value TRUE)
TRUNC (truncate a number)
TTEST (t-test)
T.TEST (t-test)
TYPE (type of a value)
UPPER (convert text to upper case)
USERFIELD (output user info)
VALUE (convert text into a number)
VAR (variance of a sample)
VARA (variance of a sample)
VARP (variance of entire population)
VAR.P (variance of entire population)
VARPA (variance of entire population)
VAR.S (variance of a sample)
VLOOKUP (look up column-wise)
WEEKDAY (weekday)
WEEKNUM (week number)
WEIBULL (Weibull distribution)
WEIBULL.DIST (Weibull distribution)
WORKDAY (date after x workdays)
XIRR (internal rate of return)
XNPV (net present value)
XOR (logical XOR function)
YEAR (year of a date)
ZTEST (z-test)
Z.TEST (z-test)
Appendix
Ribbon commands and corresponding menu commands
Shortcut keys
Shortcut keys in Windows and Linux versions
Shortcut keys in Mac version
Command-line parameters