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