Microsoft Excel: Create drop down list data

To create Excel template for your document, sometimes you need to select data from the provided one without typing again. Here is the way to create drop down list for the prepared data.

Environment: Microsoft Excel 2010

- First of all, you need to create the group of data that you want to use in the drop down list. In my case, I create the group of data in new tab of the same Excel file.





















- Select "Data" menu and click at the cell that you want to create drop down list.

















- Click at "Data Validation" button and select "Data Validation..." choice.














- Excel will show "Data Validation" pop-up window. In "Allow:", select "List" option.

















- When select option "List", it will show "Source:". Click at grid button.

















- Select the tab that contain the group of data, drag the mouse over the data that you want to use. Then, select the grid button when you finish.


















- Click "OK" button to finish.

















- There will be the drop down list for the cell you have selected. When click at the drop down list button, the data that you specified will be shown as the picture below.




















Reference: http://office.microsoft.com/en-us/excel-help/create-or-remove-a-drop-down-list-HP005202215.aspx

Comments

Post a Comment

Popular posts from this blog

Microsoft Visio: How to set default font

Image
Microsoft Visio doesn't have the easy way to set its default font and size. Please follow these steps to make change of your drawing. Environment : Microsoft Visio 2007 Solution No. 1 : Set default font and size from Style Note that this solution will not apply to the drawing that you change to specific font. - From menu bar, select 'Tools' and then 'Options...'. - In 'Options' pop-up window, select 'Advanced' tab. At 'Advanced options', check 'Run in developer mode' and press 'OK' button. This option will allow you to select 'Define Styles...' sub-menu. - Draw some drawing and select it. At the menu bar, select 'Format' and then select 'Define Styles...' sub-menu. - In 'Define Styles' pop-up window, at 'Style' section, the default style name will be selected automatically follow by the style of the drawing that we selected befo
Read more

LINE: Change the contact name

Image
People use some other name to represent themselves in LINE. To search them, you might not be able to remember what name they are using. You can just change the displayed name to what you call them. Follow these steps to change it. Environment : Application: LINE version 3.1.7 O/S: Android Ice Cream Sandwich 4.0.4 Device: Samsung Galaxy S III Press at the friend that you wan to change the name. Press at the pencil sign in the pop-up screen. It will show you the textbox to override the name. Type in the name that you want to call your friend and press "Save". Scroll down or search the new name you just defined.
Read more

Microsoft Word: Make picture background to be transparent

Image
If you want to make your picture background to be transparent but don't have any tool. Microsoft Word also provide the simple tool for that. Environment : Microsoft Word 2010 - Select the picture that you want to make the background to be transparent. The menu "Picture Tools" -> "Format" will show in the main menu. - Click at "Format" menu. It will show the sub-menu. Click "Remove Background" button. - Menus under "Background Removal" will be shown as below. In the picture, purple area is the transparent area. - Adjust area that you want to make transparency. - Click at "Mark Areas to Keep" button and mark at the areas that you don't want to be transparent. - When finish marking area, click "Keep Changes" button to keep the change. - The result will be as below.
Read more