How to copy Excel drop down list to Word document?
You can copy a cell with drop down list from Excel to Word document and easily apply the selection while using the Word document. In this article, we will show you how to copy Excel drop down list to Word document.
Recommended Productivity Tools for Excel
Office Tab: Bring powerful tabs to Office (include Excel), just like Chrome, Safari, Firefox and Internet Explorer. Save you half the time, and reduce thousands of mouse clicks for you. 30-day Unlimited Free Trial
Kutools for Excel: Save 71% of your time and solve 82% Excel problems for you. 300+ advanced tools designed for 1500+ work scenario, make Excel much easy and increase productivity immediately.60-day Unlimited Free Trial
Please do as follows to copy Excel drop down list to Word document.
1. In the certain worksheet, select the cell with drop down list you need to copy and paste to Word document. Copy it with pressing Ctrl + C keys simultaneously.
2. Go to the Word document, click Home > Paste > Paste Special. See screenshot:
3. In the Paste Special dialog box, you need to:
1). Select Paste link option;
2). Select Microsoft Excel Worksheet Object in the As box;
3). Click the OK button. See screenshot:
4. Then the cell with drop down list is pasted in the Word document as an object. Double click it, the Excel workbook is opened. And the selection will be coincident between the Word document and worksheet no matter how you change the selection in Excel.