Row Numbering

U

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
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Help to copy information from one row at a time to another sheet 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Excel Concatenate with line breaks but ignore blank cells 3
Array formula copying blanks as zero’s 5
How to print row in excel on one page 1
Stop numbering rows for Titles 3
Worksheet sorts on first 5 columns only 2
Macro?? 5

Top