Probably a simple answer to this.

I need to fill a formula for a large amount of cells, like 30,000 +. If I start at the top of the worksheet and enter =A1-B1 in Cell C1, draging the fill handle to Cell C30000 obviously takes to long to relatively fill the formula for all that data. How do I tell excel to fill to CELL C30000 automaticaly?