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

Formula, CURSOR, RIGHT, RETURN., Display, Spreadsheet

Page 121 highlights

Formula Text No Display This function makes it possible to display formulas (rather than their result) in cells. Use this feature to print all the formulas you have created. 1. Move the cursor to a corner of the range of cells that you want to display formulas in cells and press MENU and select Style; then select Formula Text from the function menu. 2. Proceed as you would with the Underline function to select the range of cells. After the range is selected, the Formula Text window appears: Formula Texl? Use cursor to select and press RETURN. NB [OFF] ICANCEL) 3. Use CURSOR LEFT and CURSOR RIGHT to select ON, OFF, or CANCEL and press RETURN. • ON: Displays formulas instead of their results. • OFF: Displays the result in any cell that was displaying a formula. • CANCEL: Returns to the previous display. This function is used to hide the contents of cells. Use this function to hide cells used only for intermediate results that do not need to appear in your worksheet. 1. Move the cursor to a corner of the range of cells that you want to hide the contents of cells and press MENU and select Style; then select No Display from the function menu. 2. Proceed as you would with the Underline function to select the range of cells. After the range is selected, the No Display window appears: No Display? Use cursor to select and press RETURN. Nig [OFF) (CANCEL] 3. Use CURSOR LEFT and CURSOR RIGHT to select ON, OFF, or CANCEL and press RETURN. • ON: Changes the display so that the contents of all the cells in the range appear empty. • OFF: Displays the contents of all the cells. • CANCEL: Returns to the previous display. Spreadsheet 113

  • 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

Formula
Text
This
function
makes
it
possible
to
display
formulas
(rather
than
their
result)
in
cells.
Use
this
feature
to
print
all
the
formulas
you
have
created.
1.
Move
the
cursor
to
a
corner
of
the
range
of
cells
that
you
want
to
display
formulas
in
cells
and
press
MENU
and
select
Style;
then
select
Formula
Text
from
the
function
menu.
2.
Proceed
as
you
would
with
the
Underline
function
to
select
the
range
of
cells.
After
the
range
is
selected,
the
Formula
Text
window
appears:
Formula
Texl?
Use
cursor
to
select
and
press
RETURN.
NB
[OFF]
ICANCEL)
3.
Use
CURSOR
LEFT
and
CURSOR
RIGHT
to
select
ON,
OFF,
or
CANCEL
and
press
RETURN.
ON:
Displays
formulas
instead
of
their
results.
OFF:
Displays
the
result
in
any
cell
that
was
displaying
a
formula.
CANCEL:
Returns
to
the
previous
display.
No
Display
This
function
is
used
to
hide
the
contents
of
cells.
Use
this
function
to
hide
cells
used
only
for
intermediate
results
that
do
not
need
to
appear
in
your
worksheet.
1.
Move
the
cursor
to
a
corner
of
the
range
of
cells
that
you
want
to
hide
the
contents
of
cells
and
press
MENU
and
select
Style;
then
select
No
Display
from
the
function
menu.
2.
Proceed
as
you
would
with
the
Underline
function
to
select
the
range
of
cells.
After
the
range
is
selected,
the
No
Display
window
appears:
No
Display?
Use
cursor
to
select
and
press
RETURN.
Nig
[OFF)
(CANCEL]
3.
Use
CURSOR
LEFT
and
CURSOR
RIGHT
to
select
ON,
OFF,
or
CANCEL
and
press
RETURN.
ON:
Changes
the
display
so
that
the
contents
of
all
the
cells
in
the
range
appear
empty.
OFF:
Displays
the
contents
of
all
the
cells.
CANCEL:
Returns
to
the
previous
display.
Spreadsheet
113