Row Numbering

[Uddhava]

Sorry for newbie question...

I want the top of my columns to be titles for my columns eg January,
February etc then to have a space (eg a blank row) before the data entry
begins. Excel is calling my titles as row 1, my blank space as row 2 and then
my first line of data row 3. Can I tell it that the titles and blank space
should not be counted as rows so that the first data is labeled as row 1 and
not row 3?

Thank you

 

[Gord Dibben]

Excel's rows are numbered from the top row.

You cannot change this numbering system.

Row 3 is row 3 no matter what you place in rows 1 and 2

You will have to adjust any formulas with that in mind.

If you want see a series of number in a column you can start in A3 and enter
the formula

=ROW()-2 and copy down.

But that is visual only


Gord Dibben MS Excel MVP