Excel for mac copy and paste down autofill

broken image
broken image

The keyboard shortcut for Mac is Ctrl+E, just as in the Windows version. In Excel for Mac, the keyboard shortcut is the only way to use Flash Fill.

broken image

Flash Fill will populate your column based on the pattern it detects. Once you type the first and last name in the first cell, click in the next cell down. There is also a keyboard shortcut for Flash Fill.