Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

How to create a pop up window for multiple data entry in Excel?

Normally, you need to type in cells one by one to fill cell range. 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.

Create a pop up window for multiple data entry with the Form feature
Create a pop up window for data entry with an awesome feature


Create a pop up window for multiple data entry with the Form feature

The build-in Form feature of Excel can help you solve the problem. Please do as follows.

1. Click File > Options to open the Excel Options widow.

2. In the Excel Options window, you need to:

  • 1) Click Customize Ribbon in the left pane;
  • 2) Go to the tabs section, click the New Tab to create a new tab on the ribbon;
  • 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). And then click to select New Group under the Form tab;
  • 4) Select All Commands from the Choose commands from drop-down list;
  • 5) Find and select Form in the commands box;
  • 6) Click the Add button to add the Form command to the new created tab under the certain group;
  • 7) Click the OK button. See screenshot:

3. Then the Form tab is created and added to the Ribbon. Click on any cell of the range you want to input data, click Form (the name you specified in step 2) > Form.

4. In the pop up window for data entry window, if you want to create new data in the range, please click the New button, fill the fields and close the window. You can use the Find Prev and the Find Next button to switch up and down to change the existing cell value as you need.


Create a pop up window for data entry with an awesome feature

Sometimes, the cell content is too long to view except for expanding the cell size or enlarging the Formula bar. Here I recommend the Enhanced Edit Bar feature of Kutools for Excel for you. After enabling this feature, a window will pop up when clicking on a cell, and you can view and edit the cell content directly in the window.

Before applying Kutools for Excel, please download and install it firstly.

1. Click Kutools > Enhanced Edit Bar to enable the feature. See screenshot:

2. When clicking on a cell, a widow will pop up with all content listing inside. You can view, add and delete content in the window directly based on your needs.

  If you want to have a free trial ( 60-day) of this utility, please click to download it, and then go to apply the operation according above steps.


Related articles

Pop up a calendar when clicking a specific cell in Excel
Supposing there is a column range in a worksheet you need to frequently enter and change dates inside, but it is bored to enter or change date manually per time. How to quickly enter dates without manually typing into the column range? This article is talking about popping up a calendar when clicking on cells in a certain range, then inserting date into the selected cell automatically after selecting date in the calendar.

Protect cell formatting but only allow data entry in Excel
In many cases, you may need to protect the formatting of a range of cells and only allow data entry in Excel. This article provides three methods to achieve it.


Kutools for Excel - The Best Office Productivity Tool Increase Your Productivity by 80%

  • Reuse: Quickly insert complex formulas, charts and anything that you have used before; Encrypt Cells with password; Create Mailing List and send emails...
  • Super Formula Bar (easily edit multiple lines of text and formula); Reading Layout (easily read and edit large numbers of cells); Paste to Filtered Range...
  • Merge Cells/Rows/Columns without losing Data; Split Cells Content; Combine Duplicate Rows/Columns... Prevent Duplicate Cells; Compare Ranges...
  • Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
  • Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
  • Extract Text, Add Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
  • Super Filter (save and apply filter schemes to other sheets); Advanced Sort by month/week/day, frequency and more; Special Filter by bold, italic...
  • Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split Data into Multiple Sheets; Batch Convert xls, xlsx and PDF...
  • More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features 60-day free trial.
kte tab 201905

Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

  • Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
officetab bottom
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.

Be the first to comment.