{"id":349994,"date":"2021-10-07T18:00:15","date_gmt":"2021-10-07T15:00:15","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-create-a-data-entry-form-in-microsoft-excel\/"},"modified":"2021-10-07T18:00:15","modified_gmt":"2021-10-07T15:00:15","slug":"how-to-create-a-data-entry-form-in-microsoft-excel","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-create-a-data-entry-form-in-microsoft-excel\/","title":{"rendered":"#How to Create a Data Entry Form in Microsoft Excel"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_84 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a27b3d10a6b4\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #dd3333;color:#dd3333\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a27b3d10a6b4\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-create-a-data-entry-form-in-microsoft-excel\/#Add_the_Form_Option\" >Add the Form Option<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-create-a-data-entry-form-in-microsoft-excel\/#Convert_Your_Data_to_a_Table\" >Convert Your Data to a Table<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-create-a-data-entry-form-in-microsoft-excel\/#Use_the_Data_Entry_Form\" >Use the Data Entry Form<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-create-a-data-entry-form-in-microsoft-excel\/#Edit_Your_Form\" >Edit Your Form<\/a><\/li><\/ul><\/nav><\/div>\n<p><strong>&#8220;#How to Create a Data Entry Form in Microsoft Excel&#8221;<\/strong><\/p>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone size-full wp-image-731027\" srcset=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/MS-excel-logo-675.png?width=398&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 400w, https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/MS-excel-logo-675.png?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 1200w\" sizes=\"auto, 400w, 1200w\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/MS-excel-logo-675.png?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Microsoft Excel Logo\" width=\"1200\" height=\"675\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Manual data entry can be time-consuming and error prone. But if you take a few minutes to create a data entry form in Microsoft Excel, you can improve the process and reduce the risk of mistakes like missing data.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Add_the_Form_Option\"><\/span>Add the Form Option<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To use the Form option in Excel, you\u2019ll need to add it to either the Quick Access toolbar or ribbon. The simplest of the two is the Quick Access toolbar. If you decide to add it to your ribbon instead, you\u2019ll need to create a special tab for it, which may not be ideal.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Create a Customized Tab on the Microsoft Office Ribbon<\/em><\/strong><\/p>\n<p>To add the Form button to your Quick Access toolbar, click the arrow in the toolbar to open the Customize Quick Access Toolbar menu. Select \u201cMore Commands.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-752689 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/08\/QuickAccessMoreCommands-ExcelDataEntryForm.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Pick More Commands\" width=\"460\" height=\"500\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Confirm that Quick Access Toolbar is selected on the left. In the \u201cChoose Commands From\u201d drop-down box on the left, choose \u201cAll Commands.\u201d<\/p>\n<p>In the \u201cCustomize Quick Access Toolbar\u201d drop-down box on the right, choose whether you\u2019d like to add the Form button to all documents or your current one.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-752690\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/08\/ChooseCommandsDocument-ExcelDataEntryForm.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Choose All Commands a pick the document\" width=\"650\" height=\"241\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Scroll through the All Commands list and pick \u201cForm.\u201d Click the \u201cAdd\u201d button to add it to the toolbar.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-752687\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/08\/FormAdd-ExcelDataEntryForm.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select Form and click Add\" width=\"610\" height=\"500\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Click \u201cOK\u201d to close the settings and return to your spreadsheet. You should see the Form button in the Quick Access Toolbar.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-752688\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/08\/QuickAccessForm-ExcelDataEntryForm.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Form button in Quick Access Toolbar\" width=\"384\" height=\"86\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Convert_Your_Data_to_a_Table\"><\/span>Convert Your Data to a Table<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To use the form, you\u2019ll need labels for each field. These come in the form of table headers. If the data is already formatted as a table, you\u2019re one step ahead and can move on to using the form. If not, you can easily convert it.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Create and Use a Table in Microsoft Excel<\/em><\/strong><\/p>\n<p>Select the cells containing the data. Go to the Home tab and the Styles section of the ribbon. Click \u201cFormat as Table\u201d and choose a table style.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-752693\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/08\/FormatAsTable-ExcelDataEntryForm.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Select a table style\" width=\"650\" height=\"319\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>In the Create Table pop-up window, confirm the cell range and check the \u201cMy Table Has Headers\u201d box. Click \u201cOK.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-752692\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/08\/CreateTable-ExcelDataEntryForm.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Check the table has headers box\" width=\"266\" height=\"161\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You will then see your data formatted as a nice and neat table.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-752691\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/08\/CreatedTable-ExcelDataEntryForm.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Table in Excel\" width=\"650\" height=\"81\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Use_the_Data_Entry_Form\"><\/span>Use the Data Entry Form<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Now all you have to do is start entering data into your form! Select any cell within the table and click the Form button you added to the Quick Access Toolbar.<\/p>\n<p>You\u2019ll see a pop-up window with your table headers as the field labels. Fill in each field.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-752697\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/08\/OpenForm-ExcelDataEntryForm.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Open the data entry form in Excel\" width=\"650\" height=\"442\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You can move between the fields and onto the next record quickly. After you fill a field, press your Tab key to move to the next one. When you finish completing all fields for the record, press Enter. Then fill out the next record. As you enter the data, you\u2019ll see your table fill.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-752696\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/08\/UseForm-ExcelDataEntryForm.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Complete the form fields\" width=\"650\" height=\"438\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Use can also use the buttons on the data entry form to add, review, or remove records.<\/p>\n<ul>\n<li>To create another record, click \u201cNew.\u201d<\/li>\n<li>To move through the records, click \u201cFind Prev\u201d or \u201cFind Next.\u201d You can also use the scroll bar in the data field area.<\/li>\n<li>To see the number of records, look above the New button.<\/li>\n<li>To remove a record, make sure it displays on the form and click \u201cDelete.\u201d Then confirm by clicking \u201cOK.\u201d<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-752707 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/08\/FormButtons-ExcelDataEntryForm.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Form buttons\" width=\"499\" height=\"409\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>When you finish with the data entry form, click \u201cClose.\u201d You can reopen it any time by selecting a table cell and clicking the Form button in the Quick Access Toolbar.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Edit_Your_Form\"><\/span>Edit Your Form<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you\u2019d like to edit the labels or rearrange the fields on the form, you\u2019ll do so in your Excel sheet. Close the form, make the change in your table, then reopen the form. You\u2019ll see your changes <a href=\"https:\/\/buradabiliyorum.com\/en\/category\/download-scripts-themes-apps\/\" data-internallinksmanager029f6b8e52c=\"9\" title=\"Download Scripts &amp; Themes &amp; Apps\" target=\"_blank\" rel=\"noopener\">app<\/a>lied to the form.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-752695\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/08\/EditForm-ExcelDataEntryForm.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Edit the form\" width=\"650\" height=\"301\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>For a fast way to enter a lot of data into a spreadsheet, especially when it\u2019s from an external source, try creating your own data entry form in Excel.<\/p>\n<p>If you use Excel on a Mac, you might also be interested in\u00a0quickly adding data by scanning a printed document.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Insert Data from a Picture in Microsoft Excel for Mac<\/em><\/strong><\/p>\n<\/div>\n<p><script>\n setTimeout(function(){\n  !function(f,b,e,v,n,t,s)\n  {if(f.fbq)return;n=f.fbq=function(){n.callMethod?\n  n.callMethod.apply(n,arguments):n.queue.push(arguments)};\n  if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0';\n  n.queue=[];t=b.createElement(e);t.async=!0;\n  t.src=v;s=b.getElementsByTagName(e)[0];\n  s.parentNode.insertBefore(t,s) } (window, document,'script',\n  'https:\/\/connect.facebook.net\/en_US\/fbevents.js');\n   fbq('init', '335401813750447');\n   fbq('track', 'PageView');\n  },3000);\n<\/script><\/p>\n<blockquote><p><strong><span style=\"color: #ff6600;\">If you liked the article, do not forget to share it with your friends. Follow us on\u00a0<span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/news.google.com\/publications\/CAAqBwgKMLG0nwswvr63Aw\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Google News<\/a><\/span>\u00a0too, click on the star and choose us from your favorites.<\/span><\/strong><\/p><\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.howtogeek.com\/752684\/how-to-create-a-data-entry-form-in-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;#How to Create a Data Entry Form in Microsoft Excel&#8221; Manual data entry can be time-consuming and error prone. But if you take a few minutes to create a data entry form in Microsoft Excel, you can improve the process and reduce the risk of mistakes like missing data. Add the Form Option To use&#8230;<\/p>\n","protected":false},"author":1,"featured_media":349995,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/MS-excel-logo-675.png?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-349994","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/349994","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=349994"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/349994\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/349995"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=349994"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=349994"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=349994"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}