I received a spreadsheet which I have to add information to :-
e.g. when it arrived column A is for Ref No.
The first one (A1)was already filled in and had the left and right borders
black and the Ref.No. centred, when I entered my first Ref.No. in the cell
below (A2) the borders automatically went black and the No. I entered was
centred.
How has someone set up the sheet to do this ?
Thanks,

Al