A named range defined by a cell address range in a spreadsheet comprises a
plurality of cells identified in each dimension by an address, each
dimension comprising two directions. An open named range is specifyed to
the named range in at least one open direction. A hidden named range with
the cell address range of the open named range is expanded by one address
in every direction specified as open. In response to user action, at least
one direction is selected, the cell address range of the hidden named
range is increased by inserting between two consecutive cell addresses, a
new address in selected directions, the open named range is updated with
the cell address range of the hidden named range shortened by one address
in every direction specified as open.