Hi Linda,

F4 is what you are looking for just click in your cell
reference in the formula bar and hit F4. It cycles through
four options just keep tapping it till you get the
configuration you want.

HTH
Martin