pmFreeManual_en.pdf

(3056 KB) Pobierz
Manual
PlanMaker
© 1987-2016 SoftMaker Software GmbH
Contents
Welcome!
21
Technical support .............................................................................................. 22
About this manual ............................................................................................. 23
System requirements ......................................................................................... 23
Installation and program startup
25
Installing under Windows ................................................................................. 25
Installing under Linux....................................................................................... 26
Installing on an Android device ........................................................................ 26
Screen elements
29
Title bar............................................................................................................. 29
Menu bar ........................................................................................................... 30
Standard toolbar ................................................................................................ 31
Formatting toolbar ............................................................................................ 31
Edit toolbar ....................................................................................................... 32
Document window ............................................................................................ 32
Status bar .......................................................................................................... 34
PlanMaker basics
37
The structure of a spreadsheet .......................................................................... 37
Moving around in a worksheet ......................................................................... 39
Entering data ..................................................................................................... 39
Deleting data ..................................................................................................... 39
Undoing changes .............................................................................................. 40
Starting a new document................................................................................... 40
Opening a document ......................................................................................... 41
Printing a document .......................................................................................... 43
Saving a document ............................................................................................ 43
Exiting PlanMaker ............................................................................................ 44
The PlanMaker Tour
45
Five minutes of theory … ................................................................................. 45
First steps with PlanMaker ............................................................................... 46
Entering values and formulas ........................................................................... 47
Contents
iii
Manual PlanMaker
Going three-dimensional .................................................................................. 51
Changing the layout of worksheets ................................................................... 51
Charts ................................................................................................................ 53
Outlook ............................................................................................................. 54
Editing worksheets
55
Entering data in cells ........................................................................................ 58
Undoing changes .............................................................................................. 61
Repeating commands ........................................................................................ 61
Selecting cells and cell contents ....................................................................... 62
Selecting in the Windows/Linux version .................................................... 62
Selecting in the Android version ................................................................. 64
Deleting cells and cell contents ........................................................................ 65
Deleting the contents of cells ...................................................................... 66
Deleting whole cells .................................................................................... 67
Deleting empty rows ................................................................................... 68
Deleting duplicate rows .............................................................................. 68
Inserting new cells ............................................................................................ 69
Moving and copying cells ................................................................................. 70
Pasting cells selectively .................................................................................... 72
Filling cells automatically................................................................................. 76
Working with multiple worksheets ................................................................... 82
Creating new worksheets ............................................................................ 83
Working with the worksheet register........................................................... 83
Managing worksheets ................................................................................. 84
Calculating in three dimensions .................................................................. 86
Naming cell ranges ........................................................................................... 86
Assigning names to cell ranges ................................................................... 87
Deleting and renaming names ..................................................................... 88
Defining names automatically from the selection ....................................... 89
Creating a list of all named ranges .............................................................. 90
Putting named ranges to use ........................................................................ 90
Applying names in existing formulas.......................................................... 91
Sorting cells ...................................................................................................... 92
Transposing cells .............................................................................................. 94
Distributing text into multiple columns ............................................................ 95
Filtering cells by their contents ......................................................................... 96
Special filter ................................................................................................ 96
AutoFilter .................................................................................................... 99
Analyzing tables ............................................................................................. 101
Displaying formulas instead of results ...................................................... 102
Syntax highlighting ................................................................................... 102
Watch window for cell contents ................................................................ 104
iv
Contents
Manual PlanMaker
Formula auditing ....................................................................................... 105
Updating tables ............................................................................................... 110
Inserting comments ......................................................................................... 112
Goal-seeking ................................................................................................... 113
Scenarios......................................................................................................... 114
Creating scenarios ..................................................................................... 115
Viewing scenarios ..................................................................................... 116
Managing scenarios................................................................................... 117
Merging scenarios ..................................................................................... 118
Creating a scenario summary .................................................................... 118
Consolidating data .......................................................................................... 119
Consolidating data by position .................................................................. 121
Consolidating data by labels ..................................................................... 123
Modifying and updating consolidations .................................................... 125
Freezing rows and columns ............................................................................ 126
Inserting special characters ............................................................................. 128
Formatting worksheets
131
Cell size .......................................................................................................... 133
Changing cell sizes using the mouse ......................................................... 133
Changing cell sizes using menu commands .............................................. 133
Hiding rows or columns ............................................................................ 134
Number format ............................................................................................... 135
List of all number formats available ......................................................... 137
Working with user-defined number formats .............................................. 140
Structure of a user-defined format............................................................. 142
Borders and lines ............................................................................................ 147
Shading ........................................................................................................... 150
Alignment ....................................................................................................... 152
Protection ........................................................................................................ 155
Character format ............................................................................................. 155
Typeface and font size ............................................................................... 156
Text styles ................................................................................................. 157
Text color .................................................................................................. 158
Superscript and subscript .......................................................................... 159
Letter spacing and character pitch ............................................................. 159
Kerning ..................................................................................................... 160
Removing character formatting ................................................................. 160
Paragraph format (text frames only) ............................................................... 161
Paragraph indents (text frames only) ........................................................ 161
Line spacing (text frames only) ................................................................. 162
Paragraph alignment (text frames only) .................................................... 163
Spacing above/below a paragraph (text frames only) ............................... 164
Contents
v
Manual PlanMaker

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika:

Zgłoś jeśli naruszono regulamin