Rebecca wrote <<How do I add a unique reference number to a column?

Go to the column past the last one in the spread sheet.

Highlight the column. To do this click on the letter at the head of the
column.

Format the column. To do this click on <Format<Cells<Number<OK

Ensure that "allow cell drag and drop" is enabled. To do this click on
<Tools<Options<Edit and tick on <Allow cell drag and drop

Seed the number. To do this insert 1 & 2 into cells Z1 and Z2 respectively.

Highlight cells Z1 and Z2. To do this left an hold whilst drawing the mouse
over the cells

Extend the numbers over the required range. To do this place the mouse
pointer over the blob at the south-east corner of the cell and drag it down
to the bottom of the range.

All this sounds complicated but that is common to most instruction sets.

Regards.

Bill Ridgeway
Computer Solutions