If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Row Numbering
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 |
#2
|
|||
|
|||
Row Numbering
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 On Tue, 13 Apr 2010 11:15:02 -0700, Uddhava wrote: 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 |
Thread Tools | |
Display Modes | |
|
|