Al
ToolsOptionsEdit "Extend list formats and formulas"
Gord Dibben Excel MVP
On Tue, 22 Feb 2005 06:51:09 -0800, al9315
wrote:
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
|