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.