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

While, using, these, functions, press, cancel, function., Spreadsheet

Page 111 highlights

Using the Menu Functions The following functions can be found under the menu bar at the top of the screen. This bar can be reached by pressing MENU. File Ll Edit Slyle n Save File Open File far Dual Quit Close File File Management Use the File functions from the function menu to open, save, or close your files, and to return to the MAIN MENU. These functions work exactly the same way as with the Word Processing application. Please refer to "File" on page 38 for details. Edit File PM Style LurF Center Right Search Replace Fill Sort Select While using these functions, you can press CANCEL at any time to cancel the function. Use the Edit functions from the function menu to make the same changes in the appearance or contents of many cells, to rearrange the worksheet, or to extract part of the information. Left: Aligns alphanumeric data to the left in the desired range of cells. Center: Centers alphanumeric data in the desired range of cells. Right: Aligns alphanumeric data to the right in the desired range of cells. Search: Searches for occurrences of a specified string of characters. Replace! Searches for occurrences of a specified string of characters and allows for automatic replacement with another string. Fill: Fills a selected range with a specified arithmetic progression. Sort: Sorts a specified group of rows. Select: Selects rows according to specified conditions; the selection can be written in the worksheet and printed. Left, Center, and Right affect only cells containing alphanumeric data over the selected range; numeric cells and empty cells will not change. Left, Center, and Right change the corresponding format marks C, A, ") in the input area of the affected cells. When the alphanumeric result of a cell is produced by a function like @REPEAT, or @IF, the format mark is not added, but the characters in the cell can be highlighted. Spreadsheet 103

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • 31
  • 32
  • 33
  • 34
  • 35
  • 36
  • 37
  • 38
  • 39
  • 40
  • 41
  • 42
  • 43
  • 44
  • 45
  • 46
  • 47
  • 48
  • 49
  • 50
  • 51
  • 52
  • 53
  • 54
  • 55
  • 56
  • 57
  • 58
  • 59
  • 60
  • 61
  • 62
  • 63
  • 64
  • 65
  • 66
  • 67
  • 68
  • 69
  • 70
  • 71
  • 72
  • 73
  • 74
  • 75
  • 76
  • 77
  • 78
  • 79
  • 80
  • 81
  • 82
  • 83
  • 84
  • 85
  • 86
  • 87
  • 88
  • 89
  • 90
  • 91
  • 92
  • 93
  • 94
  • 95
  • 96
  • 97
  • 98
  • 99
  • 100
  • 101
  • 102
  • 103
  • 104
  • 105
  • 106
  • 107
  • 108
  • 109
  • 110
  • 111
  • 112
  • 113
  • 114
  • 115
  • 116
  • 117
  • 118
  • 119
  • 120
  • 121
  • 122
  • 123
  • 124
  • 125
  • 126
  • 127
  • 128
  • 129
  • 130
  • 131
  • 132
  • 133
  • 134
  • 135
  • 136
  • 137
  • 138
  • 139
  • 140
  • 141
  • 142
  • 143
  • 144
  • 145
  • 146
  • 147
  • 148
  • 149
  • 150
  • 151
  • 152
  • 153
  • 154
  • 155
  • 156
  • 157
  • 158
  • 159
  • 160
  • 161
  • 162
  • 163
  • 164
  • 165
  • 166
  • 167
  • 168
  • 169
  • 170
  • 171
  • 172
  • 173
  • 174
  • 175
  • 176
  • 177
  • 178
  • 179
  • 180
  • 181
  • 182
  • 183
  • 184
  • 185
  • 186
  • 187
  • 188
  • 189
  • 190
  • 191
  • 192
  • 193
  • 194
  • 195
  • 196
  • 197
  • 198
  • 199
  • 200
  • 201
  • 202
  • 203
  • 204
  • 205
  • 206
  • 207
  • 208
  • 209
  • 210
  • 211
  • 212
  • 213
  • 214
  • 215
  • 216
  • 217
  • 218
  • 219
  • 220
  • 221
  • 222
  • 223
  • 224
  • 225
  • 226
  • 227
  • 228
  • 229
  • 230
  • 231
  • 232
  • 233
  • 234
  • 235
  • 236
  • 237
  • 238
  • 239
  • 240
  • 241
  • 242
  • 243
  • 244
  • 245
  • 246
  • 247
  • 248
  • 249
  • 250
  • 251
  • 252

Using
the
Menu
Functions
The
following
functions
can
be
found
under
the
menu
bar
at
the
top
of
the
screen.
This
bar
can
be
reached
by
pressing
MENU.
File
Ll
Edit
Slyle
n
Save
File
Open
File
far
Dual
Quit
Close
File
File
Management
Edit
File
PM
Style
LurF
Center
Right
Search
Replace
Fill
Sort
Select
While
using
these
functions,
you
can
press
CANCEL
at
any
time
to
cancel
the
function.
Use
the
File
functions
from
the
function
menu
to
open,
save,
or
close
your
files,
and
to
return
to
the
MAIN
MENU.
These
functions
work
exactly
the
same
way
as
with
the
Word
Processing
application.
Please
refer
to
"File"
on
page
38
for
details.
Use
the
Edit
functions
from
the
function
menu
to
make
the
same
changes
in
the
appearance
or
contents
of
many
cells,
to
rearrange
the
worksheet,
or
to
extract
part
of
the
information.
Left:
Aligns
alphanumeric
data
to
the
left
in
the
desired
range
of
cells.
Center:
Centers
alphanumeric
data
in
the
desired
range
of
cells.
Right:
Aligns
alphanumeric
data
to
the
right
in
the
desired
range
of
cells.
Search:
Searches
for
occurrences
of
a
specified
string
of
characters.
Replace!
Searches
for
occurrences
of
a
specified
string
of
characters
and
allows
for
automatic
replacement
with
another
string.
Fill:
Fills
a
selected
range
with
a
specified
arithmetic
progression.
Sort:
Sorts
a
specified
group
of
rows.
Select:
Selects
rows
according
to
specified
conditions;
the
selection
can
be
written
in
the
worksheet
and
printed.
Left,
Center,
and
Right
affect
only
cells
containing
alphanumeric
data
over
the
selected
range;
numeric
cells
and
empty
cells
will
not
change.
Left,
Center,
and
Right
change
the
corresponding
format
marks
C,
A,
")
in
the
input
area
of
the
affected
cells.
When
the
alphanumeric
result
of
a
cell
is
produced
by
a
function
like
@REPEAT,
or
@IF,
the
format
mark
is
not
added,
but
the
characters
in
the
cell
can
be
highlighted.
Spreadsheet
103