Not sure how to find the answer.

[Computerlearner]

I have a column that is specifically for having a number next to a song title
Ex:
Column A Column B
1 Song title
2 Song title

How can I get column A to count for me? Or is it that I have to manually input all numbers myself?

 

[VoG]

Try in A1 and copy down

=ROW()

 

[Computerlearner]

I'm sorry, I don't understand.

 

[VoG]

In A1 enter

=ROW()

click in A1, hover the cursor over the bottom right of the cell until the cursor turns into a + then hold down the left mouse button and drag down as far as needed. Release the mouse button.

 

[Computerlearner]

I Screwed my explanation up, In A1 I have "Disc #" in A2, I have1. I'm sorry.

 

[Computerlearner]

Thank you so much for your help. I'll go try that right now.

 

[VoG]

OK, as above but in A2

=ROW()-1

and copy down.

 

[Computerlearner]

So, would I have it 1=A2()-1? I'm having issues making it work

 

[VoG]

Try like this

Excel Workbook
	A
1	Disc #
2	1
3	2
Sheet5

 

[Computerlearner]

It counts down instead of up. I don't get it? Should I change - to +?

Thank you for being so patient with me