In this article:

How to Autofill Email Addresses in Excel (Easiest Way in 2024)

In this article, we will show you how to autofill email addresses in Excel. Simply follow the process below. 

How to Autofill Email Addresses in Excel

Follow the steps below to efficiently autofill email addresses in Excel. 

1. Open Excel and Input First and Last Names in Separate Columns

Launch Excel and open your spreadsheet. In two separate columns, input first names and last names. For instance, enter "Aiden" in the first column and "Smith" in the second.

how to autofill email address in excel

2. Enter Formula for Email in Adjacent Cell and Autofill Down the Column

In the cell next to the first name and last name, create the first email address using a formula. For example, type =A2 & "." & B2 & "" in C2 to get "".

Then, use Excel's autofill feature by dragging the small square at the bottom-right corner of this cell down to fill other cells.

excel autofill email address

3. Verify Autofilled Email Addresses for Correct Format

Check the autofilled email addresses to ensure they follow the correct format according to the first and last names.

4. Modify Formula if Necessary and Reapply Autofill

If the email format needs to be changed, adjust the formula in the first cell and use the autofill feature again.

5. Save Changes to the Excel Document

Save your Excel document to keep the changes.

6. Resolve Any Formatting Errors in Email Addresses

If errors occur, like incorrect email formatting, revise the formula to match your desired format.

We hope that you now have a better understanding of how to autofill email addresses in Excel. If you enjoyed this article, you might also like our article on how to send a part of an Excel spreadsheet by email or our article on how to email one sheet in Excel.  

Schedule a free automation consult
Learn more

Level up your Google Sheets skills with our free Google Sheets automation guide

Wasting too much time doing things manually in spreadsheets? Want to spend more time doing what you love? Our 100% free, 27-page Google Sheets automation guide is full of new tips and tricks that will save you time and money!