Printing Problems

How to Print Excel Data Validation Drop-Down Values to PDF

Phi Hung Vo Sep 28, 2026 869 views

Question details

The user wants to export or print the full list of values contained within an Excel data validation drop-down menu into a single PDF document.

How to Print Excel Data Validation Drop-Down Values to PDF

Product: Excel
Device & OS: not provided
Scenario: Attempting to document or share all the available options from a drop-down list by converting them into a PDF file.
Observed behavior: Excel does not natively print the expanded drop-down menu or its internal values directly to a PDF; the list values must be displayed in a printable worksheet area first.

Before you start

Locate the source data cells that feed your drop-down list, or prepare a screenshot tool if you prefer to capture the drop-down menu visually.

Solution 1Recommended

Set the Source Data Range as the Print Area

The most effective way to output drop-down values is to print the actual cells containing the source list used for the data validation.

Excel drop-down lists pull their options from a specific range of cells. By locating this range and setting it as your print area, you can easily export the exact list values to a PDF.

Locate the source data

Click on the cell containing your drop-down list. Go to the Data tab, click Data Validation, and look at the 'Source' box to find which cells contain your list values.

Select the data range

Navigate to the cells referenced in the Source box and highlight the entire range of values.

Set the Print Area

Go to the Page Layout tab on the ribbon, click Print Area, and select Set Print Area from the drop-down menu.

Export to PDF

Go to File > Export > Create PDF/XPS Document, or go to File > Print and choose 'Microsoft Print to PDF' as your printer. Click Print or Publish to save the file.

Set the Source Data Range as the Print Area

Tip: If your source data is on a hidden sheet, you will need to unhide the sheet first by right-clicking the sheet tabs at the bottom and selecting 'Unhide'.

Solution 2

Insert a Screenshot of the Expanded Drop-Down Menu

Use this method if you specifically need the PDF to visually show the drop-down menu as it appears when a user clicks on it.

Manage and Export Excel Drop-Down Lists with WPS Spreadsheet

WPS Spreadsheet provides a seamless and intuitive experience for creating data validation lists, managing print areas, and exporting your data directly to high-quality PDF files without needing extra plugins.

1. Open your file in WPS: Launch WPS Spreadsheet and open the workbook containing your drop-down list.
2. Highlight the list values: Select the range of cells that serve as the source data for your data validation list.
3. Set the Print Area: Navigate to the Page Layout tab, click Print Area, and choose Set Print Area.
4. Export directly to PDF: Click the Menu button in the top left corner, select Export to PDF, adjust your saving preferences, and click Export.

Fully compatible with Microsoft Excel (.xlsx) formatsBuilt-in, one-click Export to PDF featureIntuitive Page Layout tools to quickly set print areasFree to use with a lightweight and fast interface

microsoft office alternative - wps office

Frequently Asked Questions

Can I print the drop-down list while it is clicked open in Excel?

No, Excel's print engine does not capture interactive UI elements like an open drop-down menu. To show the menu open, you must take a screenshot, paste the image into your worksheet, and then print the sheet.

Where do I find the source data for my drop-down list?

Select the cell with the drop-down menu, go to the Data tab, and click Data Validation. In the Settings tab, check the 'Source' box to see the cell references (e.g., =Sheet2!$A$1:$A$10) where your list values are stored.

How do I remove the print area after saving my PDF?

To restore normal printing, go to the Page Layout tab on the ribbon, click the Print Area button, and select Clear Print Area.

Why is my exported PDF cutting off some of the list values?

This happens if the set print area is too small or if page scaling is incorrect. Before exporting, go to File > Print to view the Print Preview, and under Settings, change the scaling option to 'Fit Sheet on One Page'.

Document & File Issues