Manual PlanMaker - SoftMaker: Official Home Page

1 Manual PlanMaker 1987-2018 SoftMaker Software GmbH Manual PlanMaker Contents iii Contents Welcome! 21 Technical support .. 22 About this Manual .. 23 System requirements .. 23 Installation and program startup 25 Installing under Windows .. 25 Installing under macOS .. 26 Installing under 27 Installing on an Android device .. 27 Screen elements 31 Title bar .. 31 Menu bar .. 32 Standard toolbar .. 33 Formatting toolbar .. 33 Edit toolbar .. 34 Ribbon .. 34 Document tabs .. 35 Document .. 36 Worksheet register .. 36 Status bar .. 37 PlanMaker basics 39 The structure of a spreadsheet.

2 39 Moving around in a worksheet .. 41 Entering data .. 41 Deleting data .. 42 Undoing changes .. 42 Starting a new 42 Opening a document .. 43 Printing a document .. 45 Saving a document .. 45 Exiting PlanMaker .. 46 iv Contents Manual PlanMaker The PlanMaker Tour 47 Five minutes of theory .. 47 First steps with PlanMaker .. 48 Entering values and formulas .. 49 Going three-dimensional .. 53 Changing the layout of worksheets .. 53 Charts .. 55 Outlook .. 56 Editing worksheets 57 Entering data in cells .. 60 Undoing changes .. 63 Repeating commands.

3 64 Selecting cells and cell contents .. 64 Selecting in the Windows, Mac, and Linux version .. 65 Selecting in the Android version .. 67 Deleting cells and cell contents .. 68 Deleting the contents of cells .. 68 Deleting whole cells .. 69 Deleting empty rows .. 70 Deleting duplicate rows .. 71 Inserting new cells .. 71 Moving and copying cells .. 72 Pasting cells selectively .. 74 Filling cells automatically .. 79 Working with multiple worksheets .. 85 Creating new worksheets .. 86 Working with the worksheet 86 Managing worksheets .. 87 Calculating in three dimensions.

4 89 Naming cell ranges .. 89 Assigning names to cell ranges .. 90 Deleting and renaming names .. 91 Defining names automatically from the selection .. 92 Creating a list of all named ranges .. 93 Putting named ranges to use .. 93 Applying names in existing 94 Sorting cells .. 95 Transposing cells .. 97 Distributing text into multiple columns .. 98 Filtering cells by their contents .. 99 Special filter .. 99 Manual PlanMaker Contents v AutoFilter .. 102 Analyzing tables .. 104 Displaying formulas instead of results .. 105 Syntax highlighting .. 105 Watch window for cell contents.

5 107 Formula auditing .. 108 Displaying the relationships between cells .. 110 Selecting the cells related to a Detecting errors in calculations .. 112 Detecting invalid data in cells .. 112 Updating tables .. 113 Inserting comments .. 114 Goal-seeking .. 115 Scenarios .. 117 Creating scenarios .. 118 Viewing scenarios .. 119 Managing 120 Merging scenarios .. 120 Creating a scenario summary .. 121 Consolidating data .. 122 Consolidating data by position .. 123 Consolidating data by labels .. 125 Modifying and updating consolidations .. 127 Tables in tables.

6 128 Creating tables in tables .. 130 Removing tables in tables .. 131 Editing tables in tables .. 132 Formatting tables in tables .. 134 Using the total row of tables in tables .. 137 Tables in tables and cell references .. 138 Freezing rows and columns .. 140 Inserting special characters .. 141 Formatting worksheets 145 Cell size .. 147 Changing cell sizes using the mouse .. 147 Changing cell sizes using menu commands .. 147 Hiding rows or columns .. 148 Number format .. 149 List of all number formats available .. 151 Working with user-defined number formats.

7 154 Structure of a user-defined 156 Borders and lines .. 161 vi Contents Manual PlanMaker Shading .. 164 Alignment .. 166 Protection .. 169 Character format .. 169 Typeface and font size .. 171 Text styles .. 171 Text color .. 173 Superscript and subscript .. 173 Letter spacing and character pitch .. 174 Kerning .. 174 Removing character formatting .. 175 Paragraph format (text frames only) .. 175 Paragraph indents (text frames only) .. 176 Line spacing (text frames only) .. 176 Paragraph alignment (text frames only) .. 178 Spacing above/below a paragraph (text frames only).

8 179 Character 179 Creating character styles .. 180 Applying character styles .. 180 Modifying character styles .. 181 The character style Normal .. 182 Creating linked character styles .. 182 Cell styles .. 183 Applying cell styles .. 184 Creating cell styles .. 184 Modifying cell styles .. 186 The cell style Normal .. 186 Document templates .. 187 Creating document templates .. 187 Using document templates .. 188 Modifying document templates .. 188 The document template .. 188 AutoFormat .. 189 Conditional 189 Creating a new conditional formatting rule.

9 190 Types of conditional formatting rules .. 191 Managing conditional formatting rules .. 195 Removing conditional formatting .. 197 Input validation .. 198 Transfer formatting .. 204 Page setup .. 205 Page format .. 206 Additional page setup options .. 207 Headers and footers .. 210 Manual PlanMaker Contents vii Page breaks .. 213 Search & replace 215 Search .. 215 Replace .. 216 Search again & replace 217 Search and replace options .. 217 Jumping to specific cell addresses .. 219 Jumping to specific contents of a table .. 220 Objects (pictures, drawings, etc.)

10 223 Objects basic procedures .. 223 Inserting objects .. 224 Selecting objects .. 224 Object mode .. 224 Changing position and size of objects .. 227 Rotating and flipping objects .. 227 Aligning and distributing objects .. 228 Duplicating objects .. 229 Changing the properties of objects .. 229 Object properties, Format tab .. 229 Object properties, Filling tab .. 230 Object properties, Lines tab .. 233 Object properties, Shadow tab .. 234 Object properties, 3D tab .. 235 Object properties, Effects tab .. 236 Object properties, Properties tab .. 236 Additional tabs.