How to Set the Default Cell Value in Excel 2007. Microsoft Excel allows the entry, storage and organization of a large amount of data to be user-friendly.