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.
More tutorial for drop down list...
The Best Office Productivity Tools
Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%
- Reuse: Quickly insert complex formulas, chartsand anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails...
- Super Formula Bar [easily edit multiple lines of text and formula]; Reading Layout [easily read and edit large numbers of cells]; Paste to Filtered Range...
- Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns... Prevent Duplicate Cells; Compare Ranges...
- Select Duplicate or Unique Rows; Select Blank Rows [all cells are empty]; Super Find and Fuzzy Find in Many Workbooks; Random Select...
- Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
- Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
- Super Filter [save and apply filter schemes to other sheets]; Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
- Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
- More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features 30-day free trial. 60-day money back guarantee.
Read More... Free Download... Purchase...
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!
Read More... Free Download... Purchase...
- 3 Comments
- Login
Sort by Newest
- Best
- Popular
- Newest
- Oldest
Say something here...
symbols left.
You are guest
- Login Now
or post as a guest, but your post won't be published automatically. Post
Loading comment... The comment will be refreshed after 00:00.
To post as a guest, your comment is unpublished.
L.Cree · 4 years ago
Nice, but it's not a drop down list in word. Only a link to an excel sheet.
- Reply
To post as a guest, your comment is unpublished.
dsfdsadfasf · 2 years ago
ikr? ...............
- Reply
To post as a guest, your comment is unpublished.
Jan Lambert · 5 years ago
Awesome!! Thank you so much for sharing your knowledge :]
- Reply
How to Make Multiple Selections in a Drop Down List in Excel
- -- By Sumit Bansal
FREE EXCEL TIPS EBOOK - Click here to get your copy
One of my colleagues asked me if it is possible to make multiple selections in adrop-down list in Excel.
When you create a drop-down list, you can only make one selection. If you select another item, the first one is replaced with the new selection.
He wanted to make multiple selections from the same drop down in such a way that the selections get added to the already present value in the cell.
Something as shown below in the pic:
There is no way you can do this with Excel in-built features.
The only way is to use a VBA code, which runs whenever you make a selection and adds the selected value to the existing value.
This Tutorial Covers:
- How to make Multiple Selections in a Drop Down List
- Creating the Drop Down List in Excel
- VBA Code to allow Multiple Selections in a Drop-down List [with repetition]
- VBA Code to allow Multiple Selections in a Drop-down List [without repetition]
- Where to Put the VBA Code
- Frequently Asked Questions [FAQs]
Watch Video – How to Select Multiple Items from an Excel Drop Down List