Home

How to share active worksheet as a PDF

%3CLINGO-SUB%20id%3D%22lingo-sub-364416%22%20slang%3D%22en-US%22%3EHow%20to%20share%20active%20worksheet%20as%20a%20PDF%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-364416%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20are%20using%20the%20latest%20desktop%20version%20of%20Excel%20O365.%26nbsp%3B%20The%20share%20button%20allows%20you%20to%20email%20an%20Excel%20workbook%20as%20a%20PDF.%26nbsp%3B%20It%20will%20share%20all%20worksheets%20using%20their%20respective%20print%20area%20settings%20as%20what%20it%20will%20%22print%22%20on%20the%20PDF.%26nbsp%3B%20Is%20there%20a%20way%20to%20share%20only%20the%20active%20worksheet%20as%20a%20PDF%3F%26nbsp%3B%20The%20only%20way%20to%20do%20this%20would%20be%20to%20use%20the%20export%20as%20a%20PDF%20and%20make%20sure%20the%20options%20are%20set%20to%20active%20worksheet%20only.%20The%20draw%20back%20with%20this%20is%20you%20have%20to%20save%20a%20new%20document%2C%20and%20then%20create%20a%20new%20email%20and%20attach%20it.%20Looking%20for%20that%20magic%20one%20button%20for%20users.%3C%2FP%3E%3CP%3EThank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-364416%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

We are using the latest desktop version of Excel O365.  The share button allows you to email an Excel workbook as a PDF.  It will share all worksheets using their respective print area settings as what it will "print" on the PDF.  Is there a way to share only the active worksheet as a PDF?  The only way to do this would be to use the export as a PDF and make sure the options are set to active worksheet only. The draw back with this is you have to save a new document, and then create a new email and attach it. Looking for that magic one button for users.

Thank you.