Forum Discussion
Copy contents of one sheet into email
I am trying to copy contents of 1 sheet into an email for distribution. I'm having difficulty just sending th information of just the one sheet. When I attempt to copy, the recipients are able to view the rest of the sheets in the workbook. What am I doing wrong?
3 Replies
AggarwalatulMicrosoft
Hey isalnun- I am assuming this was answered earlier, however, just to put things in perspective, what you see is an expected behavior. Excel permissions apply at the workbook level, not the sheet level so if you share or attach the file, recipients can see all sheets.
To send only one sheet, use one of these options:
- Copy the required range and paste it directly into the email body
- Move/Copy the sheet to a new workbook and attach that file
- Export the active sheet as PDF (Print→ Print Active sheets)
Hiding or protecting sheets won’t prevent access if the full workbook is shared.
Do they need the capability of Excel in what you're distributing? One alternative, if it's just the presentation, is to "print to PDF" and just send that PDF file. Think of it as what we'd do in the old world, printing the document and sticking it in the mail...
To share just one Excel sheet without exposing others, create a copy in a new workbook:
- Right-click the sheet tab → Move or Copy → Select (new book) → Check Create a copy.
- Attach the new file to your email (safest) or paste data directly (formatting may vary).
Your original workbook stays secure, and recipients see only the intended sheet.
This keeps it concise while covering key steps and reassurance.
My answers are voluntary and without guarantee!
Hope this will help you.
