Microsoft Excel – creating a pdf from more than one worksheet in a workbook

I was recently asked whether you could incorporate more than one Excel worksheet into a single pdf.

To do so, first group the worksheets – if they are not next to each other, select the first one, then holding down the Ctrl key, click on the sheet tabs of any other worksheets to be included in the pdf; if they are next to each other, select the first worksheet, then holding down the Shift key, click on the sheet tab of the last worksheet to be included in the pdf.

Then, click File – Save & Send, click Create PDF/XPS Document. Click Create PDF/XPS Document. The Publish as PDF or XPS dialog box will be displayed. Locate the drive and folder in which to save the pdf. Type a suitable file name in the File name box. Click Publish. The pdf will be created.

Find out more about our Excel training courses Sydney, Australia.

Find out more about our Excel training courses London, Surrey, Middlesex or our Excel training courses Dorset, Hampshire, Wiltshire.

About jdonbavand

I am a trainer of Microsoft Office, Microsoft Project and Crystal Reports. I have called my blog "If Only I'd Known That...." because I hear it so many times in training sessions. In fact, if only I had a £100 (or 150 Aussie dollars)for every time someone says "If only I'd known that." ....
This entry was posted in Microsoft Excel, Microsoft Excel 2010 and tagged , . Bookmark the permalink.

One Response to Microsoft Excel – creating a pdf from more than one worksheet in a workbook

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s