You Need to Know What the Hash Sign Does in Excel Formulas Frontpage Excel spilled range operator (#) allows formulas to automatically adjust to changes in the spilled range size.