Forum Discussion
formulla
Hello, I am Ismail from Iran. My job is accounting and I use the Excel 2016 program and we are in the business of buying agricultural products. We buy the agricultural products of at least 500 garden...
SORRY .But I don't know how to do this for 500 sheets. Because I like to work with Excel, but I'm a beginner in this field and it's a bit difficult for me to speak and translate English.
Select A2:A3.
Then drag the fill handle down to A501. You will now have the numbers 1 to 500 without having to type them yourself.
Next, select B2:C2.
Then drag the fill handle down to row 501. This will copy the formulas in columns B and C.
- I'm sorry, but unfortunately I couldn't implement your order. There is a possibility of more guidance or doing this work for you. If you do a small favor, do it or explain more, I will be grateful, my friend. Do something friendly, my brother, I will compensate you.