How do I have the first few rows not be numbered?
 

How do I have the first few rows not be numbered?
 

ToolsOptionsView.

Uncheck "row and Column headers.

Now in A7 enter =ROW() and copy down.


Gord Dibben MS Excel MVP


On Mon, 19 Nov 2007 15:57:01 -0800, happylucas
wrote:

How do I have the first few rows not be numbered?
 

You can have all the rows numbered or none of the rows numbered.

If you don't want the rows numbered, you can use this (in xl2003):
Tools|Options|View Tab|Uncheck Row and column headers.

Yep, you'll lose the column letters/numbers, too if you use this.

happylucas wrote:

--

Dave Peterson