1. A method for automatically completing a remainder portion of a name as it is being entered, comprising: receiving at least a prescribed number of starting characters of a name being entered into a first cell as a reference name to refer to one or more other cells; determining a set of one or more valid reference names that begin with the received starting characters; and providing the set of valid reference names as auto-completion options; wherein a valid reference name is one that identifies using a supported syntax a spreadsheet document or a portion of a spreadsheet document.