This  process shows you how to turn a particular sample in an Excel sheet into a single PDF with each sample on a different page. This process is good for creating a single PDF for a sample that has unique categorisation to the other samples in the file.

To convert multiple samples in an Excel document to a combined PDF, follow the instructions below:

  1. Highlight all the content for the sample you want to export by clicking and dragging on the relevant cells.

2. When you have highlighted the sample, Click file > print, or press ‘command’ + P for Mac, or ‘ctrl’ + P for Windows.

3. You will see the print dialog box open up. First, set the Page orientation to Portrait. Then, go to the ‘Print:’ option, and choose ‘Selection’. For Windows, go to the ‘Print Selection’ option and choose ‘Only print the current selection’.

(Mac)

(Windows)

4. In the bottom left corner, go the to ‘PDF’ dropdown, and choose ‘Save as PDF’.

5. Choose your save destination, then click ‘Save’. This will save your sample to a single PDF file.

This next process shows you how to turn multiple samples in an Excel sheet into a combined PDF with each sample on a different page. This process is good for creating a single PDF file with multiple samples that have the same categorisation (e.g. same company, same product, same channel, etc.)

To convert multiple samples in an Excel document to a combined PDF, follow the instructions below:

  1. Highlight all the content for the sample you want to export by holding the ‘command’ button (Mac) or the ‘ctrl’ button (Windows), then clicking and dragging on the relevant cells. NOTE: Remember to highlight each sample individually, holding ‘command’ or ‘ctrl’ the whole time.

2. When you have highlighted all the samples, Click file > print, or press ‘command’ + P for Mac, or ‘ctrl’ + P for Windows.
3. You will see the print dialog box open up. First, set the Page orientation to Portrait. Then, go to the ‘Print:’ option, and choose ‘Selection’. For Windows, go to the ‘Print Selection’ option and choose ‘Only print the current selection’.

(Mac)

(Windows)

4. In the bottom left corner, go the to ‘PDF’ dropdown, and choose ‘Save as PDF’.

5. Choose your save destination, then click ‘Save’. This will save your samples to a combined PDF file, with each sample saved on a separate page.

Did this answer your question?