Select the range you want to copy the formula into. Make sure the first cell is the one with the formula. Select Edit/Fill Down. I use Ctrl+D for short.