Hi Erik
Either
Mark the range of data, go to the white pane to the left of column letter A
and above Row 1, type in the name you wish to use, press Enter.
Or
InsertNameDefine and in the Name pane Enter name required, and in the
Refers to pane enter =$A$1:$D$50 or whatever your range is to be.
Regards
Roger Govier
Erik B wrote:
How do I give a name to a data range?
|