How to create a simple input form without VBA in Microsoft Excel

5373cb0c1f7ff2ee2d5001323af0627c

Usually, filling in data in Microsoft Excel tables is done manually, but this is not always convenient, especially when it comes to projects with a large number of columns. It is often necessary to use the mouse to scroll the sheet sideways and make unnecessary movements to switch between cells. This problem is solved by creating a simple input form that can be implemented without VBA programming skills.

Preparatory actions

First, you need to prepare the letter itself, namely, create a table so that in the future the form recognizes it correctly. Along with this, you need to activate the button to call the form, because by default in new versions of Microsoft Excel it is not added to the quick access bar.

  1. Hold down the left mouse button and select the entire content of the table, then go to the tab “Insert”.Select a table to create a simple input form in Microsoft Excel

  2. Expand the list on it “Tables” and left-click on the option “Table”.Create table button to create a simple Microsoft Excel input form

  3. The table location will already be set by default, so all that remains is to confirm this action.Table creation confirmation to create a simple Microsoft Excel input form

  4. You can change the appearance of the table at your discretion, but for now I will stop at its classic look, since there will be no functional difference.Checking the layout of the table to create a simple Microsoft Excel input form

  5. Next, you need to add a button to call the form, for which go to the tab “File”.Go to the File tab to create a simple Microsoft Excel input form

  6. Click on the item “others” and select an item from the menu “Options”.Opening a section with options for creating a simple input form in Microsoft Excel

  7. In the new window with settings on the left panel, select a section “Quick access panel” and set a filter for commands “Teams are not on tape”.Select an option to create a simple input form in Microsoft Excel

  8. Among all commands, search “Form”select it with the left mouse button and click “Add”.Add a button to the Quick Access Toolbar to create a simple Microsoft Excel input form

  9. This completes the setup process, so make sure the button is now listed on the right, then tap “OK”.Confirmation of adding a button to create a simple Microsoft Excel input form

That’s it, now you have a ready-made table to fill in, as well as a button on the shortcut bar that is responsible for calling up a window with a form.

The community is now in Telegram

Subscribe and stay up to date with the latest IT news

Sign up

Filling out a simple input form

I will show an example of how to fill out a simple form using a function window, the call button of which we added to the quick access panel. The data filling process looks simple and is perfect for those situations when you need to create several rows with a large number of columns at once.

  1. Select absolutely any cell included in the table, and then click on the button “Form” on the quick access panel.Call the button after selecting a table to create a simple Microsoft Excel input form

  2. Start by pressing the button “Add”to create a new line to populate.Create a new row to create a simple Microsoft Excel input form

  3. Enter a value for each cell one by one from the column names, then click Enter to confirm input.Data entry to create a simple Microsoft Excel input form

  4. You can immediately start adding the next row and do so until you have finished entering all the values ​​for this table.Switch to the next row to create a simple Microsoft Excel input form

Such a simple sequence of actions allows you to quickly fill the table with data without the need to constantly switch between rows and cells manually. At the same time, there is no need to independently create a form through VBA, which for most users is practically an insurmountable task.

Read also in the Community:

Related Posts

Leave a Reply

Your email address will not be published. Required fields are marked *

© 2022 ZoNa365.ru - Theme by WPEnjoy · Powered by WordPress