So you can enter the formula once and drag it down. Or select all the cells where you want to enter the same formula, type it into the formula bar, hold down the Ctrl key, and then hit Enter.

See Help for Keyboard Shortcuts.