Novice method? Not that I know of. Give this a try... right click the tab at
the bottom of the worksheet that you want this functionality on, select
"View Code" from the popup menu that appears and copy/paste the following
code into the code window that appears...
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, _
Cancel As Boolean)
Cancel = True
Target.Value = IIf(Target.Value <> "", "", "X")
End Sub
Now, go back to your worksheet and double-click an empty cell to put an "X"
in it, double click any cell with text in it (an "X" or anything else) and
the text will be cleared. Is that what you were looking for?