- #How to rotate an excel spreadsheet and insert into word how to#
- #How to rotate an excel spreadsheet and insert into word free#
#How to rotate an excel spreadsheet and insert into word how to#
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.Ĭreate a searchable drop down list in Excelįor a drop down list with numerous values, finding a proper one is not an easy work. It is quite easy to create a data validation drop down list among worksheets within a workbook. This tutorial provides the method to solve the problem.Ĭreate drop down list from another workbook in Excel If there is method for allowing to auto complete when typing the first letter in the drop down list, everything will become easier. 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. Note: Every time you want to choose item from the drop-down list, you need to turn on the Lock command.Īutocomplete when typing in Excel drop down list After finish selecting, please turn off the Lock command in order to make the whole document editable. Then you can choose item from the drop down list now.Ĩ. 6.3) Repeat these two steps until all drop down items are added into the Items in drop-down list box ħ.6.1) Enter a drop down item into the Drop-down item box.In the Drop-Down Form Field Options dialog box, you need to: Then a form field is inserted into the document, please double click it.Ħ. In the Form Field dialog box, select the Drop-down option and then click OK.ĥ.
Place the cursor to where you want to insert drop down list, and click Form Field button.Ĥ. Now the specified commands are added to a new group under the certain tab.ģ. 2.7) Click the Add button to add this command to the new group too.2.6) Find the Lock command in the commands box.2.5) Click the Add button to add this command to the new group.2.4) Find and the Insert Form Field command in the commands box.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.2) Select Commands Not in the Ribbon from the Choose commands from drop-down list.2.1) Click Customize Ribbon in the left pane.In the Word options window, you need to finish the below settings. In the Word document you want to insert drop down list, click File > Options.Ģ. Please do as follows to create drop down lists in a Word document.ġ.
#How to rotate an excel spreadsheet and insert into word free#
The Drop-down List with Check Boxes utility of Kutools for Excelcan 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.ĭownload and try it now ( 30-day free trail)
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.Įasily create drop-down list with checkboxes in Excel: Tips: This method only pastes a link creating a shortcut to the workbook. 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. Now the drop down list cell is pasted into Word document.
Select Microsoft Excel Worksheet Object in the As box
In the Paste Special dialog box, you need to: Go to the Word document, click Home > Paste > Paste Special. Select the drop down list cell and copy it by pressing the Ctrl + C keys simultaneously.ģ. Open the worksheet contains the drop down list you want to copy to Word document.Ģ. Please do as follows to copy Excel drop down list 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.Ĭopy Excel drop down list to Word documentĭirectly create drop down list in a Word document This article is talking about copying drop down list from Excel to Word document. How to copy Excel drop down list to Word document?