Ampler saves or emails chosen sheets as a new Excel workbook or a PDF, so you send the relevant sheets without copying the file and deleting the rest.
Quick answer: Click Save As (Ctrl+Shift+S) or Email (Ctrl+Shift+X), choose Current, Selected, or All sheets and PDF or XLSX, name the file, and click Save or Send.
How to use it
Choose the sheets and format, then save or email them.
- Click Save As (Ctrl+Shift+S) or Email (Ctrl+Shift+X) on the Ampler ribbon.
- Choose Current sheet, Selected sheets, or All sheets, and PDF or XLSX.
- Set the file name and date format, then click Save As, Send, or press Enter.
The chosen sheets are saved or emailed as a new workbook or PDF, leaving the source file untouched.
Keyboard shortcut
Save As is Ctrl+Shift+S and Email is Ctrl+Shift+X by default; both can be reassigned in the Ampler Settings → Shortcuts.
Why use it
Sending part of a workbook normally means saving a copy, deleting the sheets you don’t want, and exporting. Ampler exports the chosen sheets as a new workbook or PDF directly — and can email them without leaving Excel.
How consultants use it
A client sees the output sheet, not the working model behind it, and usually as a fixed PDF. Sending a clean subset is standard. Three habits apply:
- Send only the output: the relevant sheets go out, not the whole model.
- PDF to fix the look: a read-only PDF stops the recipient reflowing the sheet.
- Clean before sending: pair with Clean workbook so nothing hidden travels with the file.
Save or email selected sheets makes controlled sharing quick.
Tips & best practices
- Select the output sheets before exporting to send just those.
- Use PDF for external recipients so the layout is fixed.
- Run Clean workbook before sending an XLSX externally.
Availability
Included in Ampler for Excel and the Ampler Suite, on Windows desktop Excel.
Frequently asked questions
How do you save only some sheets from an Excel workbook?
Click Save As (Ctrl+Shift+S) on the Ampler ribbon and choose Selected sheets, then PDF or XLSX. Only those sheets are exported.
How do you email an Excel sheet as a PDF?
Click Email (Ctrl+Shift+X), choose the sheets and PDF, and Ampler attaches them to a new email.
Can you export sheets as a new workbook?
Yes. Ampler saves the selected sheets as a new XLSX workbook (or a PDF), leaving the source file untouched.