In previous versions of Excel, all cells could be made to display their formulas but in 2007 I can find how to do that.