How to copy Excel drop down list to Word document?
This article is talking about copying drop down list from Excel to Word document. Alternatively, it provides a step-by-step guide to show you how to manually create drop down list in a Word document.
Copy Excel drop down list to Word document
Directly create drop down list in a Word document
More tutorial for drop down list...
Copy Excel drop down list to Word document
Please do as follows to copy Excel drop down list to Word document.
1. Open the worksheet contains the drop down list you want to copy to Word document.
2. Select the drop down list cell and copy it by pressing the Ctrl + C keys simultaneously.
3. Go to the Word document, click Home > Paste > Paste Special. See screenshot:
4. 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:
Now the drop down list cell is pasted into Word document. When you double click the pasted object in Word, the corresponding Excel workbook is opened, and changes to the drop-down list in the worksheet will be reflected in the Word document.
Tips: This method only pastes a link creating a shortcut to the workbook. Actually, Word allows users to create drop down lists with its build-in features, if you are interested in it, please browse the below method.
Easily create drop-down list with checkboxes in Excel:
The Drop-down List with Check Boxes utility of Kutools for Excel can help you easily create drop-down list with checkboxes in a specified range, current worksheet, current workbook or all opened workbooks based on your needs.
Download and try it now (30-day free trail)
Directly create drop down list in a Word document
Please do as follows to create drop down lists in a Word document.
1. In the Word document you want to insert drop down list, click File > Options.
2. In the Word options window, you need to finish the below settings.
- 2.1) Click Customize Ribbon in the left pane;
- 2.2) Select Commands Not in the Ribbon from the Choose commands from drop-down list;
- 2.3) In the right main tabs box, select a tab name (here I select the Insert tab), click New Group button to create a new group under the Insert tab;
- 2.4) Find and the Insert Form Field command in the commands box;
- 2.5) Click the Add button to add this command to the new group;
- 2.6) Find the Lock command in the commands box;
- 2.7) Click the Add button to add this command to the new group too;
- 2.8) Click the OK button. See screenshot:
Now the specified commands are added to a new group under the certain tab.
3. Place the cursor to where you want to insert drop down list, and click Form Field button.
4. In the Form Field dialog box, select the Drop-down option and then click OK.
5. Then a form field is inserted into the document, please double click it.
6. In the Drop-Down Form Field Options dialog box, you need to:
- 6.1) Enter a drop down item into the Drop-down item box;
- 6.2) Click the Add button;
- 6.3) Repeat these two steps until all drop down items are added into the Items in drop-down list box;
- 6.4) Check the Drop-down enabled box;
- 6.5 Click the OK button.
7. Click the Lock command to enable it. Then you can choose item from the drop down list now.
8. After finish selecting, please turn off the Lock command in order to make the whole document editable.
Note: Every time you want to choose item from the drop-down list, you need to turn on the Lock command.
Related articles:
Autocomplete when typing in Excel drop down list
If you have a data validation drop down list with large values, you need to scroll down in the list just for finding the proper one, or type the whole word into the list box directly. If there is method for allowing to auto complete when typing the first letter in the drop down list, everything will become easier. This tutorial provides the method to solve the problem.
Create drop down list from another workbook in Excel
It is quite easy to create a data validation drop down list among worksheets within a workbook. But if the list data you need for the data validation locates in another workbook, what would you do? In this tutorial, you will learn how to create a drop fown list from another workbook in Excel in details.
Create a searchable drop down list in Excel
For a drop down list with numerous values, finding a proper one is not an easy work. Previously we have introduced a method of auto completing drop down list when enter the first letter into the drop down box. Besides the autocomplete function, you can also make the drop down list searchable for enhancing the working efficiency in finding proper values in the drop down list. For making drop down list searchable, try the method in this tutorial.
Auto populate other cells when selecting values in Excel drop down list
Let’s say you have created a drop down list based on the values in cell range B8:B14. When you selecting any value in the drop down list, you want the corresponding values in cell range C8:C14 be automatically populated in a selected cell. For solving the problem, the methods in this tutorial will do you a favor.
Best Office Productivity Tools
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
