Manual PlanMaker

Manual

PlanMaker

? 1987-2013 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

Screen elements

27

Title bar............................................................................................................. 27 Menu bar........................................................................................................... 28 Standard toolbar................................................................................................ 28 Formatting toolbar ............................................................................................ 28 Edit toolbar ....................................................................................................... 29 Document window............................................................................................ 30 Status bar .......................................................................................................... 31

PlanMaker basics

33

The structure of a spreadsheet .......................................................................... 33 Moving around in a worksheet ......................................................................... 35 Entering data..................................................................................................... 35 Deleting data..................................................................................................... 35 Undoing changes .............................................................................................. 36 Starting a new document................................................................................... 36 Opening a document ......................................................................................... 37 Printing a document .......................................................................................... 39 Saving a document............................................................................................ 39 Exiting PlanMaker ............................................................................................ 40

The PlanMaker Tour

41

Five minutes of theory ... ................................................................................. 41 First steps with PlanMaker ............................................................................... 42 Entering values and formulas ........................................................................... 43 Going three-dimensional .................................................................................. 47

Manual PlanMaker

Contents iii

Changing the layout of worksheets................................................................... 48 Charts................................................................................................................ 50 Outlook ............................................................................................................. 51

Editing worksheets

53

Entering data in cells ........................................................................................ 56 Undoing changes .............................................................................................. 59 Repeating commands........................................................................................ 59 Selecting cells ................................................................................................... 60 Deleting cells and cell contents ........................................................................ 62

Deleting the contents of cells ...................................................................... 62 Deleting whole cells.................................................................................... 63 Deleting empty rows ................................................................................... 64 Deleting duplicate rows .............................................................................. 65 Inserting new cells ............................................................................................ 65 Moving and copying cells................................................................................. 66 Pasting cells selectively .................................................................................... 68 Filling cells automatically................................................................................. 72 Tips and tricks for automatic filling ............................................................ 75 Working with multiple worksheets ................................................................... 77 Creating new worksheets ............................................................................ 78 Working with the worksheet register........................................................... 78 Managing worksheets ................................................................................. 79 Calculating in three dimensions .................................................................. 81 Naming cell ranges ........................................................................................... 82 Assigning names to cell ranges ................................................................... 82 Deleting and renaming names ..................................................................... 83 Defining names automatically from the selection ....................................... 84 Creating a list of all named ranges .............................................................. 85 Putting named ranges to use........................................................................ 85 Applying names in existing formulas.......................................................... 86 Sorting cells ...................................................................................................... 87 Transposing cells .............................................................................................. 89 Distributing text into multiple columns ............................................................ 89 Filtering cells by their contents......................................................................... 90 Special filter ................................................................................................ 91 AutoFilter .................................................................................................... 93 Analyzing tables ............................................................................................... 94 Displaying formulas instead of results ........................................................ 95 Syntax highlighting ..................................................................................... 95 Watch window for cell contents .................................................................. 97 Formula auditing ......................................................................................... 98 Updating tables ............................................................................................... 103

iv Contents

Manual PlanMaker

Inserting comments......................................................................................... 104 Goal-seeking ................................................................................................... 105 Scenarios......................................................................................................... 107

Creating scenarios ..................................................................................... 108 Viewing scenarios ..................................................................................... 109 Managing scenarios................................................................................... 110 Merging scenarios ..................................................................................... 110 Creating a scenario summary .....................................................................111 Consolidating data .......................................................................................... 112 Consolidating data by position .................................................................. 113 Consolidating data by labels ..................................................................... 115 Modifying and updating consolidations .................................................... 117 Freezing rows and columns ............................................................................ 118 Inserting special characters ............................................................................. 120

Formatting worksheets

123

Cell size .......................................................................................................... 125 Changing cell sizes using the mouse......................................................... 125 Changing cell sizes using menu commands .............................................. 125 Hiding rows or columns ............................................................................ 126

Number format ............................................................................................... 127 List of all number formats available ......................................................... 129 Working with user-defined number formats.............................................. 133 Structure of a user-defined format............................................................. 134

Borders and lines ............................................................................................ 139 Shading ........................................................................................................... 142 Alignment ....................................................................................................... 143 Protection........................................................................................................ 146 Character format ............................................................................................. 146

Typeface and font size............................................................................... 147 Text styles ................................................................................................. 148 Text color .................................................................................................. 149 Superscript and subscript .......................................................................... 149 Letter spacing and character pitch............................................................. 150 Kerning ..................................................................................................... 151 Removing character formatting................................................................. 151 Paragraph format (text frames only) ............................................................... 152 Paragraph indents (text frames only) ........................................................ 152 Line spacing (text frames only)................................................................. 152 Paragraph alignment (text frames only) .................................................... 154 Spacing above/below a paragraph (text frames only) ............................... 155 Character styles............................................................................................... 155 Creating character styles ........................................................................... 156

Manual PlanMaker

Contents v

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download