My Excel 2016

Index

Symbols

#All specifier, 192

‘ (apostrophe), 47, 134, 176

* (asterisk)

custom number formats, 149

in filter criteria, 271

in formulas, 176

text filters, 261

wildcard searches, 86

{ } (curly braces), array formulas, 193

#Data specifier, 192

#DIV/0! errors, 199, 230

$ (dollar sign) in cell referencing, 178-179

= (equal sign), in formulas, 176

#Headers specifier, 192

###### in cell, 199

#NAME? errors, 200

# (pound sign), custom number formats, 145

? (question mark)

in filter criteria, 271

text filters, 261

wildcard searches, 86

#REF! errors, 200

[ ] (square brackets), specifiers, 192

@ThisRow specifier, 192

~ (tilde)

in filter criteria, 271

wildcard searches, 87

#Totals specifier, 192

_ (underscore), custom number formats, 148

#VALUE! errors, ...