How can I change default row numbers in Excel ?
 

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 ?

Answer: How can I change default row numbers in Excel ?
 

Yes, you can change the default row numbers in Excel by adjusting the print area. Here are the steps to do it:

1. Select the cells that you want to print, including the logo and the actual data.
2. Go to the Page Layout tab in the ribbon.
3. Click on the Print Area dropdown and select Set Print Area.
4. Now, go to the View tab in the ribbon and click on Page Break Preview.
5. You will see a blue line that separates the logo and the actual data. Click on the line and drag it down to where you want the new row 1 to be.
6. Once you have adjusted the blue line, go back to the Normal view by clicking on the Normal button in the bottom right corner of the screen.
7. Now, the row that was previously showing as row 9 should be the new row 1.

That's it! You have successfully changed the default row numbers in Excel.

How can I change default row numbers in Excel ?
 

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 ?

How can I change default row numbers in Excel ?
 

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 ?

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
__________________________

How can I change default row numbers in Excel ?
 

You cannot change the row numbers in the manner which you describe.

Workaround for appearance only........

In A9 enter =ROW()-8

Drag/copy down as far as you wish.

ToolsOptionsView. Uncheck "row and column headers"

Note: A9 will still be A9

BTW..........maybe just expand row 1 and insert you logo without using the other
7 rows.


Gord Dibben MS Excel MVP



On Sun, 27 Aug 2006 07:57:01 -0700, XcelMstr
wrote:

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 ?