how to create drop down in openoffice excel

Use the Microsoft Word's Find and Replace formatting tool to replace all the pre-designed template text in each label with your own information.

Continue with Step 3 until all labels are filled with your information.

Position the cursor in the next label, right-click and select Paste.

Highlight all the content in the first label, right-click and select Copy.

Insert your information on the 1st label.

How to create a sheet of all the same labels: Then click Text Wrapping and select In Front of Text in the drop down list.

Click in the cell where you want the list to appear. Select your image in the template and click the Page Layout tab in the Ribbon Toolbar. How can I create a drop-down list that references a list of values to select from Under Data Validity, you can control what people can enter in spreadsheets, and offer them help in the form of lists, help tips, etc. Highlight the text you entered and use the tools in Microsoft Word to format the text.Ĭlick the Insert tab in the Ribbon Toolbar to insert your own image, clip art, shapes and more. Once the file is open, type your information into the template.

Finalize the drop-down list by pressing enter and selecting OK. Then, open the second sheet and select the items in the table that you want to appear in the drop-down list. Select the Source button to minimize the Data Validation dialog box. If the template looks like a blank page, select Table Tools > Layout > Show Gridlines to view the template layout. Click on the drop-down menu under Allow and select List. Double-click the Avery Word Template file you downloaded and saved to your copmuter.

How to create drop down in openoffice excel