You can not control this through Excel. In the “Input Range,” choose month names range of cells. In this example, create a scroll bar that covers cells B2:B6 in height and is about one-fourth of the width of the column. Microsoft Excel provides several controls for dialog sheets that are useful for selecting items from a list. Click-to-add is available but requires a bit of setup. When you click the up control or down control on the spin button, cell G1 is updated to a number that indicates the current value of the spin button plus or minus the incremental change of the spin button. This value initializes the scroll bar so that the INDEX formula will point to the first item in the list. Video guide on how to disable or enable Ctrl key shortcuts in Windows 10 Command Prompt: Step 2: Right-tap the Title bar and choose Properties. This value restricts the top of the scroll bar to the first item in the list. Under Selection type, make sure that the Single option is selected. To add a list box in Excel 2007 and later versions, click the Developer tab, click Insert in the Controls group, and then click List Box Form (Control) under Form Controls. Click Ok. For more information about form controls in Excel, see Overview of forms, form controls, and ActiveX controls on a worksheet. It adds a three-dimensional look to the drop-down or combo box. In the Minimum value box, type 1. Now select the “Combo Box” right click and choose “Format Control.”. Right-click the combo box, and then click Format Control. Now to insert values, create a day list in column A. If you find difficulty in entering BIOS Setup by this method then you can enter the BIOS Setup using UEFI Settings. In the Maximum value box, type 20. Click any cell so that the scroll bar is not selected. This number specifies the maximum number of entries in the list. Step 1: Open Command Prompt. And then Fn+F2 will bring up brightness key, I have Lenovo and in this, to lock Fn key, I press Fn Key followed by Esc key. Type the following information, and then click OK: Note: The INDEX formula uses the value in G1 to return the correct list item. To use the drop-down box or combo box, click any cell so that the object is not selected. If you Enable this then you won’t have to press Fn key + Function key to perform those functions. Click the drop-down button on the right of the Format button in the Find and Replace dialog box and choose the Choose Format from Cell option on the pop-up menu. Click the worksheet location where you want the upper-left corner of the combo box to appear, and then drag the combo box to where you want the lower-right corner of the list box to be. This number then updates the INDEX formula in cell A1 to show the next or previous item. First I suggest you check if this issue only occur with F4 key, you can select a cell in Excel and press F2 key and check if it enter to edit mode for this cell. The INDEX formula in cell A1 uses this number to display the item's name. The macro once created, can be run over any cell/cells when you have to perform the desired task. If you Disable this then you will have to press Fn + Function key to perform those functions. Select the “Combo Box” and draw anywhere on the worksheet area. Your options … In the Minimum value box, type 1. To add a spin button in Excel 2007 and later versions, click the Developer tab, click Insert, and then click Spin Button under Form Controls. Here are the steps to do that. Ctrl+C, Ctrl+A and Ctrl+V) to copy and paste the selected text. When you click an item in the drop-down box or combo box, cell G1 is updated to a number that indicates the position in the list of the item selected. Press +F, and then type your search words. Click the worksheet location where you want the upper-left corner of the spin button to appear, and then drag the spin button to where you want the lower-right corner of the spin button to be. It adds a three-dimensional look to the scroll bar. Then I can press any function key without keeping Fn key pressed. In the Current value box, type 1. Note: The 3-D shading check box is optional. Click Popular, select the Show Developertab in the Ribbon check box, and then click OK. To do this, follow these steps: Select the Developer check box under Main Tabs on the right, and then click OK. To use the forms controls in Excel 2007, you must enable the Developer tab. This number specifies the maximum number of entries in the list. XML – Options here include opening the XML Source task pane to manage XML maps, importing an XML data file, or managing any expansion packs that might be attached to a sheet we are working with.