On Wed, 6 May 2009 23:10:38 +0200, "Niek Otten"
wrote:

Set Calculation to Manual. Select the cell and press F2, ENTER.

This workaround is OK if it's a single cell, but there is apparently
no way to recalculate a range of cells all at once without
recalculating the whole worksheet.

This is inconsistent behavior. Excel allows me to do all sorts of
things to the the selected cells.

It's too bad, because Alt-F9 is available and could be used for just
this purpose.

Looks like a design bug.