Excel spilled range operator (#) allows formulas to automatically ... First, as well as referencing a spilled range in the same worksheet, you can also reference a spilled range in another sheet. For ...