1st Row Column Heading as column letter
I would like to have row numbers on my spreadsheet print out. I have inserted
a column A with a formulas going down the column starting with A1 = 1 and A2
= A1 + 1 and this formula copied down the column. If a row is inserted it is
just a matter of recopying the formula down the column.
I would like to to the same for a Column headings. I've inserted a row 1 and
currently I've manually typed in the associated column letter. However if I
insert a column I have to manually "reletter" every column to the right. Is
there a way similiar to the "row number" I can use to letter the column
headings so I don't have to retype the letters again (and again....) every
time I add or delete a column?
Thanks
Jim T.
|