You can do it with VBA code. Right click the tab at the bottom of the
worksheet you want to have this functionality, select View Code from the
popup menu that appears and copy/paste this code into the code window that
opened up...

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Target(1).Select
End Sub

Now, go back to that worksheet and try to select multiple cells.

--
Rick (MVP - Excel)


"Marge" wrote in message
...
Is it possible with VBA the make a sheet select only one cell at a
time when you drag the cursor around the sheet instead of the normal
function of selecting a range?