In this article:

How to Email One Sheet in Excel (Easiest Way in 2024)

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

How to Email One Sheet in Excel

Follow the steps below to send one sheet from Excel. 

1. Access Sheet Tab Options

Right-click the sheet tab at the bottom of the Excel window to display a menu with various options.

how to email one sheet in excel

2. Choose 'Move or Copy' for Sheet Duplication

Select 'Move or Copy' from the menu. This opens a dialog box where you can duplicate your chosen sheet.

how to send one sheet in excel

3. Make a New Workbook with the Copied Sheet

In the 'Move or Copy' dialog box, check 'Create a copy' and pick '(new book)' from the dropdown. Click 'OK'.

how to email one tab in excel

This creates a new workbook with just your selected sheet.

how to attach one sheet of excel to an email

4. Prepare the Email by Selecting 'Share' and 'Excel Workbook'

With the new workbook open, navigate to 'File' and choose 'Share'.

email one sheet from excel

Then select 'Excel Workbook'. This step prepares your workbook for emailing as an attachment.

how to send only one sheet in excel via email

5. Fill In Email Information in the New Email Window

In the email window that opens, input the recipient's email address, a subject line, and any desired message.

how to email only one sheet in excel

6. Send the Email with the Attached Single Sheet

Once all details are entered, hit 'Send'. Your email, with the workbook containing the single sheet, will be dispatched.

We hope that you now have a better understanding of how to email one sheet in Excel. If you enjoyed this article, you might also like our article on how to autofill email addresses in Excel or our article on how to remove duplicate email addresses 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!