Home » Brother International Manuals » Typewriters » Brother International WP7550JPLUS » Manual Viewer

Brother International WP7550JPLUS Owner's Manual - English - Page 113

CURSOR, Spreadsheet

Get Brother International WP7550JPLUS PDF manuals and user guides

View all Brother International WP7550JPLUS manuals

Add to My Manuals
Save this manual to your list of manuals

Page 113 highlights

Fill Sort This function is useful when you want to quickly number rows or columns, or when you need numbers in a range in order to check how math functions are working. Columns are filled from top to bottom. Rows are filled from left to right. In the case of a range, the first column is filled first, then the second, etc. 1. Move the cursor to a corner of the range of cells that you want to fill and press MENU and select Edit; then select Fill from the function menu. The machine asksyou to specify thethe range. Proceed as with the Leftfunction. After the range is specified, the FILL window appears: STARTING VALUE. JUMPING VALUE: . ENDING VALUE: I Type number and press RETURN. 2. Use CURSOR UP and CURSOR DOWN to move the cursor to the desired setting. Use the numeric keys to enter the specifications. Press RETURN when finished. • STARTING VALUE: The first number of the arithmetic progression. • JUMPING VALUE: The difference between two successive values, • ENDING VALUE: The value that the arithmetic progression cannot exceed. The cells are filled up to the ENDING VALUE (or the closest value less than it) or up to the last cell of the range, whichever comes first. Example: If the STARTING VALUE is 5, the JUMPING VALUE is 4, and the ENDING VALUE is 26 __you will get the numbers: 5, 9, 13, and 17. (Because 21 is higher than the ENDING VALUE, it is not included.) This function is used to rearrange your worksheet. When you update a worksheet, you usually add data at the end of the file. To facilitate later reference, however, you need some logical organization. Alphabetical order is commonly used. The sorting feature explained here will save you time and effort in the organization of your data. 1, Move the cursor to a corner of the range of cells that you want to sort and press MENU and select Edit; then select Sort from the fill-lc-6cm menu. The machine asks you to specify thethe range. Proceed as with the Left function, but be careful to select all the information of the rows. For example, if you have data in columns A to E and you select only columns A to D in your range, the cells in column E will not be moved along with the cells in columns A to D and it will be impossible to reverse this situation automatically. After the range is specified, an arrow cursor appears above the worksheet. A message willaskyou to move the arrow cursor to select the column ofthe range according to the data to be sorted. Move cursor to primary sort column and press RETURN. Spreadsheet 105

Section	Page
Front Cover	1
FCC Notice	2
Table of Contents	3
1 Getting Started	9
How to Use This Manual	9
Parts of Your Whisperwriter	10
Main Unit	10
Monitor	11
Optional Modem	11
Precautions	12
Set Up	13
Attaching the Monitor Stand	13
Connecting the Equipment	14
Feeding Paper	15
Manual Paper Feeding (no cut sheet feeder)	15
Optional CF-710 Cut Sheet Feeder	16
Installing the Optional Cut Sheet Feeder	16
Automatic Papaer Feeding (with cut sheet feeder)	18
Precautions when Using the Cut Sheet Feeder	19
Manual Paper Feeding (with cut sheet feeder)	20
Removing the Optional Cut Sheet Feeder	21
Resinstaling the Paper Support	22
Ink-Jet Cartridge	22
Installing/Replacing an Ink-Jet Cartridge	23
Installing the first Ink-Jet Cartridge	23
Replacing a used Ink-Jet Cartridge	24
Cleaning the Print Head	26
Cleaning the Print Cartridge Nozzles and Contacts	26
CLeaning the Bracket Contacts in the Printer	27
Diskettes	28
Inserting and Removing a Diskette	28
Initializing (Formatting) New Diskettes	29
Write-Protecting Your Diskettes	30
Backing Up a Diskette	30
Keyboard	31
Character Keys and Cursor Keys	31
Keypad Keys	32
Function Keys	33
Operation Overview	34
Main Menu Screen	34
Application Description	34
Starting an Application	35
Function Menus	35
Dual Display	35
Clip Baord	36
Help Windows	36
Supplemental Programs	36
Self-Demo	36
Tutorial	36
Graphic Art Print (WP-7550J-Plus only)	36
Frame Print (WP-7550J-Plus only)	36
2 Word Processing	39
Starting Word Processing	39
Creating a New File	39
Editing an Existing File	39
The Input/Edit Screen	40
Basic Typing	42
Word Wrap Function	42
Hyphen Function	42
Types of Spaces	42
Paragraph Break	43
Page Break	43
Tab and Paragraph Indent	43
Typing Different Characters	43
Basic Editing	45
Cursor Movement	45
Inserting Text	46
Deleting Text	46
Using the File Functions	46
Tips for Using Files	47
Open File	47
Save File	48
Open File for Dual	48
Quit	49
Close File	50
Saving a File	50
File Name Convertions	50
File Management	51
Using the Edit Functions	52
Centering	52
Right Margin Flush	53
Justify	53
Search	54
Replace	55
Header/Footer	56
Editing Headers and Footers	56
Auto Page Numbering	56
Style	57
Hyphen Scan	57
Merge Code	58
Using the Merge Code Function	59
Insertig Merge Symbols in your Document	59
Using the Style Functions	60
Type Style Change	60
Font and Size	61
Margins and Tabs	62
Using tabs to create a table	63
Using a tab to create a Paragraph indent	63
Using a tab to create a line indent	63
Line Spacing	64
Multi-Column	64
Typing text in multi-column pages	65
Copy Format	66
Delete Format	66
Page Setup	66
Using the Block Functions	68
Move	68
Copy	69
Delete	69
Copy to/ Paste from Clip Board	70
Type Style Change / Type Style Add / Font and Size	70
Using the Graphics Functions	71
Create New Chart	71
Deleting Data	72
Chart Examples	73
Final points	75
Edit Chart	75
Line Framing	76
Editing a frame	77
Copy Graphic	78
Delete Graphic	78
Using the Option Functions	79
Abbreviated Phrase Maintenance	79
Understanding the Abbreviated Phrase Memory	79
Creating and editing an Abbreviated Phrase File	80
Check All	82
Misspelled words	82
Redundant words	84
Capitalization mistakes	84
Check During Typing ON/OFF (Spell Check)	84
User Dictionary Maintenance	84
Understanding the User Dictionary	84
Adding a word to the User Dictionary	85
Editing the User Dictionary	86
Auto Letter Layout	87
Type Thesaurus	87
Edit Thesaurus	88
Using the Screen Functions	89
Change Screen	89
Scale Line ON/OFF	89
Function Mark ON/OFF	89
Split Size	89
Using the Print Functions	91
Printing a Document	91
Using Layout to Preview a Document	93
3 Spreadsheet	95
What is a Spreadsheet	95
Starting the Spreadsheet Application	96
The Input/Edit Screen	97
Moving Around the Screen	98
Entering and Editing Data	99
Inputing Alphanumeric and Numeric Data	100
Format Marks	101
Maximum Length of Data	101
Performing Calculations	102
Direct Numbers	102
Formulas	103
Order of Calculation of a Formula	104
Using Math Functions	105
Range of cells	105
Inputing a range	106
Spreadsheet Functions	107
Using the Menu Functions	111
File	111
Edit	111
Left	112
Center	112
Right	112
Search and Replace	112
Fill	113
Sort	113
Select	114
Style Functions	117
Style notes	117
Underline	118
Bold	118
Fixed	119
Currency	119
Percent	120
Formula Text	121
No Display	121
All Off	122
Block Functions	122
Absolute and relative adddresses	122
Move	123
Copy (a range of cells)	123
Copy (one cell to other cells)	124
Clear	125
Copy to Clip Board / paste from the Clip Board	125
Sheet Functions	126
Column Width	126
Title	128
Insert	129
Delete	130
Recalc	131
Range Protect	131
Worksheet Protect	132
Calculation Method	132
Options	134
Abbreviated Phrase Maintenance	134
Check All	134
User Dictionary Maintenance	134
Screen Functions	135
Change Screen	135
Split Size	135
Print Functions	136
Setting the Print Options	136
Print Area	136
Print Point	137
Print Quality	137
Print Frozen Title	137
Cut Sheet Feeder	137
Page Setup	137
Printing	138
4 Addressbook	139
Starting Addressbook	139
Addressbook Screens	140
The View Screen	140
The Data Input Screen	141
Working with Addressbook	141
File	141
The Input Funcitons (View Screen)	142
New Record	142
Top Record	142
Bottom Record	142
The Record Functions (View Screen)	142
Move	143
Copy	143
Delete	144
Copy to Clip Board / Paste from Clip Board	144
Insert	144
The Label Functions (View Screen)	144
Insert Label	145
Delete Label	145
Chanage Label Name and Width	146
The Edit Functions (View Screen)	146
Sort Records	146
Select records	147
The Screen Function (View Screen)	148
The Print Function (View Screen)	148
Printing Labels	148
Changing label settings	150
Printing a list	150
Changing Page Setup	151
Changing label print settings	152
To start printing	152
To Stop Printing	153
Selecting records for merge printing	153
The Jump Functions (Data Input Screen)	154
Search	154
The Label Functions (Data Input Screen)	155
The Option Functions (Data Input Screen)	155
The Screen Function (Data Input Screen)	155
Return to View Screen	155
5 Template	157
Opening a Template File	157
6 Typewriter	159
Starting the Typewriter application	159
Input / Edit screen	160
Hot Zone	161
Basic Typing	161
Edit Functions	161
Auto Return On / Off	162
Find Position	162
Style Functions	163
Options Functions	163
Feeder Function	163
Exit Funciton	164
7 Communication	165
About Modems	165
Using Communications	166
Using a Communication Parameter File	167
Opening a Communication File	167
About Communications Files	168
Communication Functions	169
File Functions	169
CompuServe	169
New Set Up	171
Open File	173
Save File	174
Quit	175
Phone Functions	175
Dial	176
Auto Log-In	177
Recording Auto Log-In	177
Executing Auto Log-In	178
Disconnect	178
Transfer Functions	178
Send WP Text	178
Receive ASCII File	180
Character Code Table	183
Transmitting Control Codes	184
8 File Management	187
Starting the File Management Application	187
Making a Backup Copy of a Diskette	189
File Functions	190
File Copy	190
File Delete	191
Rename	191
Retrun to Main Menu	192
Disk Functions	193
Delete All (Diskettee Delete)	193
Initialize Disk	193
Directory Read	194
Convert Functions	195
Converting Brother Word Processing Files to a PC Format	195
Converting PC Text Files to Brother Word Processing Files	197
Converting Spreadsheet Files into Lotus 1-2-3 Files	199
Converting a Lotus 1-2-3 File into a Spreadsheet File	200
IBM PC Code	201
9 Disk Application	203
Using Graphic Art Print (WP-7550J Plus only)	203
Using Frame Print (WP-7550J Plus only)	206
Tutor / Self Demo	208
10 Auto Letter Layout	209
Creating the Letter	209
Applying Auto Letter Layout	211
From the Word Processor Application	211
From the Main Menu	212
11 Desk Top Reference ( WP-7550J Plus & WP-7550J only)	215
Starting Desk Top Reference	215
Word Reference	216
Jumble	218
User Dictionary Maintenance	219
12 Calculator	221
Starting the Calculator	221
Using Number Lock Mode (NUM LOCK)	221
Inputting Data	222
Order of Calculation	222
Maximum Length of numbers and precision	222
Storing a constant	223
Clearing	223
Returning to the Current Application	223
13 Clip Board	225
Copying Data to the Clip Board	225
Pasting Data from the Clip Board	226
Copy/Paste from Word Processing to Word Processing	227
Copy/Paste from Spreadsheet to Word Processing	227
Copy/Paste from Addressbook to Word Processing	227
Copy/Paste from Word Processing, Addressbook to Spreadsheet	228
Copy/Paste from Spreadsheet to Spreadsheet	228
Copy/Paste from Word Processing or Spreadsheet to Addressbook	228
Copy/Paste from Addressbook to Addressbook	228
Appendix	229
100 Graphic Art Images	229
100 Graphic Art Images	230
Extra character Table	234
Symbol table	234
Troubleshooting	235
Error messages	236
Specifications	237
Compatible accessories	237
Glossary	239

Match case Limit results 1 per page

Fill

This

function

useful

when

you

want

quickly

number

rows

columns,

when

you

need

numbers

range

order

check

how

math

functions

are

working.

Columns

are

filled

from

top

bottom.

Rows

are

filled

from

left

right.

the

case

range,

the

rst

column

lled

first,

then

the

second,

etc.

Move

the

cursor

corner

the

range

cells

that

you

want

fill

and

press

and

select

Edit;

then

select

Fill

from

the

function

menu.

The

machine

asks

you

specify

thethe

range.

Proceed

with

the

Left

function.

After

the

range

specified,

the

FILL

window

appears:

Sort

STARTING

VALUE.

JUMPING

VALUE:

ENDING

VALUE:

<<FILL>>

Type

number

and

press

RETURN.

Use

CURSOR

and

CURSOR

DOWN

move

the

cursor

the

desired

setting.

Use

the

numeric

keys

enter

the

specifications.

Press

RETURN

when

finished.

•

STARTING

VALUE:

The

first

number

the

arithmetic

progression.

•

JUMPING

VALUE:

The

difference

between

two

successive

values,

•

ENDING

VALUE:

The

value

that

the

arithmetic

progression

cannot

exceed.

The

cells

are

filled

the

ENDING

VALUE

(or

the

closest

value

less

than

it)

the

last

cell

the

range,

whichever

comes

first.

Example:

the

STARTING

VALUE

the

JUMPING

VALUE

and

the

ENDING

VALUE

__you

will

get

the

numbers:

13,

and

17.

(Because

higher

than

the

ENDING

VALUE,

not

included.)

This

function

used

rearrange

your

worksheet.

When

you

update

worksheet,

you

usually

add

data

the

end

the

file.

facilitate

later

reference,

however,

you

need

some

logical

organization.

Alphabetical

order

commonly

used.

The

sorting

feature

explained

here

will

save

you

time

and

effort

the

organization

your

data.

Move

the

cursor

corner

the

range

cells

that

you

want

sort

and

press

and

select

Edit;

then

select

Sort

from

the

fill-lc-6cm

menu.

The

machine

asks

you

specify

thethe

range.

Proceed

with

the

Left

function,

but

careful

select

all

the

information

the

rows.

For

example,

you

have

data

columns

and

you

select

only

columns

your

range,

the

cells

column

will

not

moved

along

with

the

cells

columns

and

will

impossible

reverse

this

situation

automatically.

After

the

range

specified,

arrow

cursor

appears

above

the

worksheet.

message

will

ask

you

move

the

arrow

cursor

select

the

column

the

range

according

the

data

sorted.

Move

cursor to primary sort

column

and

press

RETURN.

Spreadsheet

105