In this article, we will show you how to email one sheet in Excel. Simply follow the process below.
Follow the steps below to send one sheet from Excel.
Right-click the sheet tab at the bottom of the Excel window to display a menu with various options.
Select 'Move or Copy' from the menu. This opens a dialog box where you can duplicate your chosen sheet.
In the 'Move or Copy' dialog box, check 'Create a copy' and pick '(new book)' from the dropdown. Click 'OK'.
This creates a new workbook with just your selected sheet.
With the new workbook open, navigate to 'File' and choose 'Share'.
Then select 'Excel Workbook'. This step prepares your workbook for emailing as an attachment.
In the email window that opens, input the recipient's email address, a subject line, and any desired message.
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.
