Hi Roy,
Do you have grouped sheets turned on,  if you do you have been destroying
loads of data on several sheets at the same time.  To ungroup right click
on a worksheet tab and    then  Ungroup Sheets.    If you don't see
ungroup sheets then fortunately that is not the problem.

The usual cause of grayed out menus is having sheet or workbook
protection turned on.     More details in
  Grayed Out Options
   http://www.mvps.org/dmcritchie/excel/grayedout.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel    [site changed  Nov. 2001]
My Excel Pages:  http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:        http://www.mvps.org/dmcritchie/excel/search.htm