Hi,
This is probably the most simple question asked today, but I cannot work out how to do it.
I am building a spreadsheet which will have a number of formulas and conditional formatting. This workbook will be populated daily with around 100 rows of data.
When I make a formula, I drag from bottom right hand corner, but it is random where I stop. Is there a way to copy the formula or conditional formatting down a column to say like row 10,000 without the need to manually drag them?
This is probably the most simple question asked today, but I cannot work out how to do it.
I am building a spreadsheet which will have a number of formulas and conditional formatting. This workbook will be populated daily with around 100 rows of data.
When I make a formula, I drag from bottom right hand corner, but it is random where I stop. Is there a way to copy the formula or conditional formatting down a column to say like row 10,000 without the need to manually drag them?