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.

Page Setup/ Sheet/ Row and column headings ?
--
David Biddulph

"jimt" wrote in message
...
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.

Is this what you're looking for:

=ADDRESS(1,COLUMN(),4)
?
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"jimt" wrote in message
...
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.

I think the OP was looking for just the column letter, so perhaps:
=LEFT(ADDRESS(1,COLUMN(),4),1)
if he isn't happy with just using
Page Setup/ Sheet/ Row and column headings
--
David Biddulph

"Ragdyer" wrote in message
...
Is this what you're looking for:

=ADDRESS(1,COLUMN(),4)
?

"jimt" wrote in message
...
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.

How about:
File|Page setup|Sheet Tab|Check Row and Column Headings

Or on the page layout tab|sheet options group in xl2007.

jimt wrote:

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.

--

Dave Peterson

In A1 thru IV1 enter:
=SUBSTITUTE((LEFT(ADDRESS(1,COLUMN()),3)),"$","")

--
Gary's Student
gsnu200708


"jimt" wrote:

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.

WOW... thanks! The Left and Substitute functions both work great.

"jimt" wrote:

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.