Title in row 1
 

How do you get a title/column names to appear in the row 1 and have row 1
start below it. ie. row 1 has no number 1?

And how get title to center if going with title and not column names?

I tried the window freeze but 1 still appears in row 1.

Messes up the data. ie. say I have 20 rows data and shows total count of 21
when actually 20 because the column names/title are in row 1.

Thanks.
--
Paul

Title in row 1
 

Hi questionman,
You cannot change the numbering on the rows.

If you like you can dedicate another column to showing a number if that helps
the person reading your spreadsheet, it will probably confuse anyone trying
to do maintenance on the sheet.

Insert a column before current column A
A1: '; (leave empty)
A2 =ROW()-1 (fill down with fill handle)


More information on possible topics:
http://www.mvps.org/dmcritchie/excel/fillhand.htm
http://www.mvps.org/dmcritchie/excel/freeze.htm

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"QuestionMan" wrote in message ...
How do you get a title/column names to appear in the row 1 and have row 1
start below it. ie. row 1 has no number 1?

And how get title to center if going with title and not column names?

I tried the window freeze but 1 still appears in row 1.

Messes up the data. ie. say I have 20 rows data and shows total count of 21
when actually 20 because the column names/title are in row 1.

Thanks.
--
Paul