Excel 2007
. I have hundreds of records. Instead of entering them manually I want them to show up automatically. Please give me short example for 1 to 10.=ROW()
into any cell and that cell will show the row number as its value.=1000+ROW()
A1
A2
a4
cell because of your heading & other stuff, you can write as Unlike other Microsoft Office programs, Excel does not provide a button to number data automatically. But, you can easily add sequential numbers to rows of data by dragging the fill handle to fill a column with a series of numbers or by using the ROW function.
To enter specific sequential number codes, such as purchase order numbers, you can use the ROW function together with the TEXT function. For example, to start a numbered list by using 000-001, you enter the formula =TEXT(ROW(A1),'000-000') in the first cell of the range that you want to number, and then drag the fill handle to the end of the range.
The fill handle displays by default, but you can turn it on or off.