Click on File->Options then in the "Advanced" section, there's a checkbox for
"Allow editing directly in cells". I assume this got unchecked. This assumes you're using Excel 2007 or later. 2003 and earlier have a similar setting, but getting to it is slightly different.