I need help with a formula, I have to number a spreadsheet from top to bottom 1 to 300 but I can't type in the number I have to use a single formula to get each cell value. Anyone have any ideas?
Go to Excel and click on A1 and then click on Auto Sum in the top right corner. Since you can't just put a number 1. Your formula is =SUM(b1+1) you can use any cell you want instead of b1 except any of the A column. Then go to A2 and click on Auto Sum in the top right corner and put =SUM(A1+1). Then right click on A2 and select copy Then left click on A3 and hold the left mouse click down until you get to A300. Then click paste and the Excel will be numbered from 1 to 300
And you cant do A1+1? and copy it all the way to 300
use =row() copy fill it from 1-300
So put in A1 =row() Then click A1, then goto A300 hold shift and click A300
Goto your home tab and click "fill" in the far top right, and select down. It will fill A2-A300 with what you have in A1.
Done numbered 1-300 with out typing a single number.
Another way to fill is included in the image. Just fill in A1 click the square in the bottom right corner when you click A1(where they intersect) drag down to 300. Done.
Answers & Comments
Verified answer
Go to Excel and click on A1 and then click on Auto Sum in the top right corner. Since you can't just put a number 1. Your formula is =SUM(b1+1) you can use any cell you want instead of b1 except any of the A column. Then go to A2 and click on Auto Sum in the top right corner and put =SUM(A1+1). Then right click on A2 and select copy Then left click on A3 and hold the left mouse click down until you get to A300. Then click paste and the Excel will be numbered from 1 to 300
And you cant do A1+1? and copy it all the way to 300
use =row() copy fill it from 1-300
So put in A1 =row() Then click A1, then goto A300 hold shift and click A300
Goto your home tab and click "fill" in the far top right, and select down. It will fill A2-A300 with what you have in A1.
Done numbered 1-300 with out typing a single number.
Another way to fill is included in the image. Just fill in A1 click the square in the bottom right corner when you click A1(where they intersect) drag down to 300. Done.