Click on any cell of the range you want to input data, click Form (the name you specified in step 2) > Form.Ĥ. Then the Form tab is created and added to the Ribbon. 6) Click the A dd button to add the Form command to the new created tab under the certain group.5) Find and select Form in the commands box.4) Select All Commands from the Choose commands from drop-down list.And then click to select New Group under the Form tab 3) Right click on the new created tab in the Main Tabs box and rename it as you need (Here I rename this tab as Form).2) Go to the tabs section, click the New Tab to create a new tab on the ribbon.1) Click Customize Ribbon in the left pane.In the Excel Options window, you need to: Click File > Options to open the Excel Options widow.Ģ. The build-in Form feature of Excel can help you solve the problem. Have you ever thought of creating a pop up window for multiple data entry when clicking on cells in a specific range in Excel? This article will show you the solutions step by step.Ĭreate a pop up window for multiple data entry with the Form featureĬreate a pop up window for data entry with an awesome feature Normally, you need to type in cells one by one to fill cell range. How to create a pop up window for multiple data entry in Excel?
