Fortunately, Excel enables users to instantly fill an entire row or selection of cells with the same formula with just a few keystrokes, with or without formatting.

How to use Excel’s Flash Fill feature, including a keyboard shortcut for both Windows and Excel for Mac.