You could hide the row numbers and use column A to show what you want, but I
wouldn't bother. It'll become a pain when you insert/delete rows and when
you're writing formulas.

Besides, isn't everyone used to seeing those row numbers in excel?

pboost1 wrote:

Hello everybody. I have a spreadsheet where row 1 and row 2 I am using
for headers. I have frozen rows 1 and 2 so the header is always
visible when I enter data. I was wondering if there is a way to
renumber the rows so the headers does not contain the numbers 1 and 2.
Any help anybody can give would be greatly appreciated. Thanks.

--
pboost1
------------------------------------------------------------------------
pboost1's Profile: http://www.excelforum.com/member.php...o&userid=11895
View this thread: http://www.excelforum.com/showthread...hreadid=472704

--

Dave Peterson