BetterSolutions.com
BetterSolutions.com
FREE Consultation
Contact Us
Documentation
Microsoft Office Word
VBA Programming
C# Programming
JavaScript Programming
Add-ins
Bespoke Add-in Development
Office Add-ins for Excel
Office Add-ins for Word
Consultancy
Office JS Add-ins and Scripts
Macros, Templates and EUDAs
Workflow Modernisation
Support
Answers, Insight and Guidance
Training
Trusted Microsoft 365 Partner
Excel
Add-ins
Best Practices
Cells Ranges
Charts
Conditional Format
Data Analysis
Data Validation
Dates Times
Search Excel ...
Functions
User Defined
Formulas
Formatting
Illustrations
Importing
Layout
Macros
Our Services ...
Named Ranges
Office Scripts
Options
Pivot Tables
Protection
Python
Reviewing
Ribbon
Find Add-ins ...
Rows Columns
Shortcut Keys
Tables
Templates
Track Changes
Workbooks
Worksheets
XML
Contact Us ...
Word
Add-ins
Bookmarks
Building Blocks
Bullets
Characters
Charts
Content Controls
Design
Search Word ...
Documents
Fields
Illustrations
Importing
Layout
Macros
Mailings
Numbering
Our Services ...
Options
Outlines
Pages
Paragraphs
Protection
References
Reviewing
Ribbon
Find Add-ins ...
Sections
Shortcut Keys
Styles
Tables
Templates
Text Boxes
Track Changes
XML
Contact Us ...
PowerPoint
Add-ins
Animation
Bullets
Characters
Charts
Design
Handouts
Illustrations
Search PowerPoint ...
Importing
Layout
Macros
Notes
Numbering
Options
Outlines
Paragraphs
Our Services ...
Presentations
Protection
References
Reviewing
Ribbon
Sections
Shortcut Keys
Slide Show
Find Add-ins ...
Slides
Tables
Templates
Text Boxes
Track Changes
Transitions
Video
XML
Contact Us ...
Outlook
Add-ins
Address Book
Alerts
Appointments
Calendar
Contacts
Events
Exchange
Search Outlook ...
Folders
Forms
Groups
HTML
Illustrations
Importing
Journal
Macros
Our Services ...
Mail
Meetings
Notes
OneDrive
OneNote
Options
People
Proofing
Find Add-ins ...
Ribbon
Rules
Search
SharePoint
Shortcut Keys
Tasks
Web Client
XML
Contact Us ...
VBA
Add-ins
Arrays
Best Practices
Class Modules
Collections
Controls
Databases
Data Types
Search VBA ...
Dates Times
Debugging
Enumerations
Error Handling
Events
Files Directories
Functions
Macros
Our Services ...
MsgBox
Numbers
Office Scripts
Options
References
Ribbon
Shortcut Keys
SQL
Find Add-ins ...
Strings
Subroutines
Syntax
Userforms
Variables
Visual Basic Editor
Web Interaction
XML
Contact Us ...
JS
Arrays
Custom Functions
Data Types
Dates Times
Debugging
Dialog Boxes
Error Handling
Excel API
Search JavaScript ...
Express Backend
Fluent UI
Functions
HTML Pages
Microsoft Graph
Node JS Runtime
Numbers
Objects
Our Services ...
Office Add-ins
Office Events
Office Manifest
Office Scripts
Office Store
Outlook API
PowerPoint API
React Library
Find Add-ins ...
Ribbon Commands
Strings
Syntax
Task Panes
TypeScript
Visual Studio Code
Word API
Yeoman Generator
Contact Us ...
C#
.NET Library
Arrays
Best Practices
Classes
Collections
Databases
Data Types
Dates Times
Search C# ...
Debugging
Excel Interop
Error Handling
Files Directories
Generics
Interfaces
MessageBox
Numbers
Our Services ...
Projects
Serialization
Strings
Structures
Syntax
Threading
Variables
VBA Migration
Find Add-ins ...
Visual Studio
VSTO Add-ins
Web Add-ins
Web Development
Web Services
Windows Forms
WPF Forms
XML
Contact Us ...
Services
Contact
Microsoft Excel Help and Support
Microsoft Excel
#
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
' Symbol
- Symbol
-- Unary Operator
! Symbol
" Double Quotation (Strings)
# Error Values
# Errors
######
#BLOCKED! Error
#BUSY! Error
#CALC! Error
#CONNECT! Error
#DIV/0! Error
#DIV/0! Hiding
#FIELD! Error
#GETTINGDATA Error
#N/A Error
#NAME? Error
#NULL! Error
#NUM! Error
#PYTHON! Error
#REF! Error
#SPILL! Error
#TIMEOUT!
#UNKNOWN! Error
#VALUE! Error
$ in Cell References
$ in Formulas
$ Number Format
$ Symbol
$B$4 References
% Increase
% Symbol
% Symbol in Formulas
& Symbol
£ Symbol
&[Date]
() Parentheses
-(cell)
* Symbol (multiply)
* Symbol (wildcard character)
/ Symbol (divide)
? Symbol (wildcard character)
@ Before Functions
@ Implicit Intersection
@=
@Vlookup
[Book 2.xls]
[Protected]
[Read Only]
[Repaired]
^ Symbol
_Filter - Named Range
_FilterDatabase - Named Range
_Print_Area - Named Range
_xldudf Prefix
_xlfn = Unsupported Function
_xlfn Prefix
_xlfn.FILTER
_xlfn.SINGLE
_xlfn.STOCKHISTORY
_xlfn.TEXTSPLIT
_xlfn.UNIQUE
_xlfn.XLOOKUP
{} Symbols
~ Symbol (wildcard characters)
£ Symbol
+ Formula
+ Symbol
+(cell)
< - less than
<> - not equal to
= Formula
= Symbol
=IF(
=RAND()
> - greater than
00-01-00 Date
1,048,576 Rows
1000 Separator
1024 Characters
15 Significant Digits
16,384 Columns
17 Digit Numbers
1904 Date System
24 Hour Time Format
255 Character Limit
256 Columns
2D Rotation
3 Level Drop-Down List
3 Star Rating Icon Sets
32,767 Characters
360 Day Year
3D Cell References
3D Charts
3D Charts - Floor
3D Charts - Wall
3D Clustered Bar Chart
3D Clustered Column Chart
3D Effects
3D Elevations - Charts
3D Formulas
3D Functions
3D Lookups
3D Maps
3D Models
3D Named Ranges
3D Ranges
3D References
3D References - Multiple Sheets
3D Referencing
3D Rotation - Charts
3D Scatter Plot
3D Stacked Bar Chart
3D Stacked Column Chart
3D Sum
3D SumIF
3D Trendlines
3D View - Charts
3D VLookup
3D Workbook
64-Bit
65,536 Rows
#
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
© 2026 Better Solutions Limited.
All Rights Reserved.
© 2026
Better Solutions Limited
Updated: 30 May 2026
▲
30 May 2026
▲