View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Richard Buttrey Richard Buttrey is offline
external usenet poster
 
Posts: 296
Default How can I change default row numbers in Excel ?

If I understand you correctly, you are wanting to change the basic
Excle structure so that your rows start their excel listing with
number 1 in the 9th row.

You can't do it.

If you think about it, and being logical and assuming Excel allowed
this, how would you expect to see the first 8 rows numbered, -7, -6,
-5, -4, -3, -2, -1, 0 ?

As has been suggested the only way you can get the sheet to look like
you want it to look, is to switch off the view rows/columns, number
cell A9 with '1', A10 with '2' etc, and then hide column A.

HTH



On Sun, 27 Aug 2006 10:34:01 -0700, XcelMstr
wrote:

thankx for ur reply....

but that option will hide the row and columns.I don't want to hide them I
just want to change the 8 row in the excel sheet as starting from
1,2,3.......and so on...hope you get my point.

"Don Guillett" wrote:

Use column 1 to put in whatever you like and use toolsoptionsview

--
Don Guillett
SalesAid Software

"XcelMstr" wrote in message
...
I wanted to change/modify the default row numbers in Excel but was unable
to
do it.Actually I have inserted logo which covers row 1 to 8 and then my
actual data starts.But what I want is the actual row which is showing row
no.9 shoudl be as row no.1 .Can anybody give a solution for it ?





__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________