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

Style, Functions

Page 117 highlights

Style Functions Edil Block UrKlet Bold Fixed Currency Percent Formula Texl No Display All Off Sheet While using the above functions, press CANCEL at any time to go to the previous screen. Use the Style functions from the function menu to modify the appearance of a range of cells. Underline: Switches underlining on/off Bold: Switches bold face attribute on/off. Fixed: Controls the number of decimal places. Currency: Automatically adds a $ symbol to numeric results in a range. Percent: Automatically adds a % symbol to numeric results in a range. Formula Text: Allows you to display the formulas, rather than their results. This is useful, for example, when you want to show someone how you have set up a particular worksheet, No Display: Switches the display of selected cells on/off. This is useful when some cells of the worksheet are used for intermediate calculations. You can hide these cells and show only what is necessary. MI Off: Cancels all settings made with the above functions and restores the default settings. Style notes • Bold and Underline can both be applied to the same cell, and together with one of the other settings as well. • The other settings, from Fixed to All Off exclude each other. For example, a cell cannot be set to Percent and Currency at the same time. If you apply Percent to a cell that was set to Currency, the $ symbol disappears and a % symbol appears. However, it is possible to set Formula Text or No Display in addition to either Fixed, Currency or Percent. For example, when No Display is set along with Percent and if the No Display setting is cancelled, the % symbol will appear again. • Underline draws a line across the entire cell regardless of its contents. This function is used to separate tows of the worksheet. • All Style functions apply to empty cells. If you set an empty cell to Bold and Percent, a numeric value entered later in that cell will be bold and will have a percent symbol. Spreadsheet 109

  • 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

Style
Functions
Edil
Block
Sheet
UrKlet
Bold
Fixed
Currency
Percent
Formula
Texl
No
Display
All
Off
While
using
the
above
functions,
press
CANCEL
at
any
time
to
go
to
the
previous
screen.
Style
notes
Use
the
Style
functions
from
the
function
menu
to
modify
the
appearance
of
a
range
of
cells.
Underline:
Switches
underlining
on/off
Bold:
Switches
bold
face
attribute
on/off.
Fixed:
Controls
the
number
of
decimal
places.
Currency:
Automatically
adds
a
$
symbol
to
numeric
results
in
a
range.
Percent:
Automatically
adds
a
%
symbol
to
numeric
results
in
a
range.
Formula
Text:
Allows
you
to
display
the
formulas,
rather
than
their
results.
This
is
useful,
for
example,
when
you
want
to
show
someone
how
you
have
set
up
a
particular
worksheet,
No
Display:
Switches
the
display
of
selected
cells
on/off.
This
is
useful
when
some
cells
of
the
worksheet
are
used
for
intermediate
calculations.
You
can
hide
these
cells
and
show
only
what
is
necessary.
MI
Off:
Cancels
all
settings
made
with
the
above
functions
and
restores
the
default
settings.
Bold
and
Underline
can
both
be
applied
to
the
same
cell,
and
together
with
one
of
the
other
settings
as
well.
The
other
settings,
from
Fixed
to
All
Off
exclude
each
other.
For
example,
a
cell
cannot
be
set
to
Percent
and
Currency
at
the
same
time.
If
you
apply
Percent
to
a
cell
that
was
set
to
Currency,
the
$
symbol
disappears
and
a
%
symbol
appears.
However,
it
is
possible
to
set
Formula
Text
or
No
Display
in
addition
to
either
Fixed,
Currency
or
Percent.
For
example,
when
No
Display
is
set
along
with
Percent
and
if
the
No
Display
setting
is
cancelled,
the
%
symbol
will
appear
again.
Underline
draws
a
line
across
the
entire
cell
regardless
of
its
contents.
This
function
is
used
to
separate
tows
of
the
worksheet.
All
Style
functions
apply
to
empty
cells.
If
you
set
an
empty
cell
to
Bold
and
Percent,
a
numeric
value
entered
later
in
that
cell
will
be
bold
and
will
have
a
percent
symbol.
Spreadsheet
109