Click the Flash Fill button or use keyboard shortcut Ctrl E. Looking to learn more about Excel? See more free Microsoft tips or browse our range Microsoft Excel ...