{"id":24425,"date":"2018-08-06T14:14:09","date_gmt":"2018-08-06T08:44:09","guid":{"rendered":"https:\/\/trumpexcel.com\/?p=24425"},"modified":"2024-01-24T16:00:50","modified_gmt":"2024-01-24T10:30:50","slug":"data-entry-form","status":"publish","type":"post","link":"https:\/\/trumpexcel.com\/data-entry-form\/","title":{"rendered":"How to Create a Data Entry Form in Excel"},"content":{"rendered":"<p style=\"text-align: center;\"><strong>Watch the Video on Using Data Entry Forms in Excel<\/strong><\/p>\n<p style=\"text-align: center;\"><iframe title=\"Using Data Entry Form in Excel (NO VBA or CODING Needed) | Easy Step by Step Guide\" width=\"1200\" height=\"675\" src=\"https:\/\/www.youtube.com\/embed\/v2ntjP692VQ?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" allowfullscreen><\/iframe><\/p>\n<p>Below is a detailed written tutorial about Excel Data Entry form in case you prefer reading over watching a video.<\/p>\n<p>Excel has many useful features when it comes to <a href=\"https:\/\/trumpexcel.com\/excel-data-entry-tips\/\" target=\"_blank\" rel=\"noopener noreferrer\">data entry<\/a>.<\/p>\n<p>And one such feature is the <strong>Data Entry Form<\/strong>.<\/p>\n<p>In this tutorial,\u00a0 I will show you what are data entry forms and how to create and use them in Excel.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-light-blue ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">This Tutorial Covers:<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" 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: #999;color:#999\" 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><\/span><\/a><\/span><\/div>\n<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:\/\/trumpexcel.com\/data-entry-form\/#Why-Do-You-Need-to-Know-About-Data-Entry-Forms\">Why Do You Need to Know About Data Entry Forms?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/trumpexcel.com\/data-entry-form\/#Data-Entry-Form-in-Excel\">Data Entry Form in Excel<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/trumpexcel.com\/data-entry-form\/#Adding-Data-Entry-Form-Option-To-Quick-Access-Toolbar\">Adding Data Entry Form Option To Quick Access Toolbar<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/trumpexcel.com\/data-entry-form\/#Parts-of-the-Data-Entry-Form\">Parts of the Data Entry Form<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/trumpexcel.com\/data-entry-form\/#Creating-a-New-Entry\">Creating a New Entry<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/trumpexcel.com\/data-entry-form\/#Navigating-Through-Existing-Records\">Navigating Through Existing Records<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/trumpexcel.com\/data-entry-form\/#Deleting-a-Record\">Deleting a Record<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/trumpexcel.com\/data-entry-form\/#Restricting-Data-Entry-Based-on-Rules\">Restricting Data Entry Based on Rules<\/a><\/li><\/ul><\/nav><\/div>\n\n<h2><span class=\"ez-toc-section\" id=\"Why-Do-You-Need-to-Know-About-Data-Entry-Forms\"><\/span>Why Do You Need to Know About Data Entry Forms?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Maybe you don&#8217;t!<\/p>\n<p>But if data entry is a part of your daily work, I recommend you check out this feature and see how it can help you save time (and make you more efficient).<\/p>\n<p>There are two common issues that I have faced (and seen people face) when it comes to data entry in Excel:<\/p>\n<ol>\n<li><strong>It&#8217;s time-consuming<\/strong>. You need to enter the data in one cell, then go to the next cell and enter the data for it. Sometimes, you need to scroll up and see which column it is and what data needs to be entered. Or scroll to the right and then come back to the beginning in case there are many columns.<\/li>\n<li><strong>It&#8217;s error-prone<\/strong>. If you have a huge data set which needs 40 entries, there is a possibility you may end up entering something that was not intended for that cell.<\/li>\n<\/ol>\n<p>A data entry form can help by making the process faster and less error-prone.<\/p>\n<p>Before I show you how to create a data entry form in Excel, let me quickly show you what it does.<\/p>\n<p>Below is a data set that is typically maintained by the hiring team in an organization.<\/p>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"size-full wp-image-26621 aligncenter\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Data-set-for-data-entry-form.png\" alt=\"Data set for data entry form\" width=\"751\" height=\"172\" srcset=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Data-set-for-data-entry-form.png 751w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Data-set-for-data-entry-form-600x137.png 600w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Data-set-for-data-entry-form-50x11.png 50w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Data-set-for-data-entry-form-250x57.png 250w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Data-set-for-data-entry-form-400x92.png 400w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Data-set-for-data-entry-form-350x80.png 350w\" sizes=\"(max-width: 751px) 100vw, 751px\" \/><\/p>\n<p>Every time a user has to add a new record, he\/she will have to select the cell in the next empty row and then go cell by cell to make the entry for each column.<\/p>\n<p>While this is a perfectly fine way of doing it, a more efficient way would be to use a Data Entry Form in Excel.<\/p>\n<p>Below is a data entry form that you can use to make entries to this data set.<\/p>\n<p><img decoding=\"async\" class=\"size-full wp-image-26622 aligncenter\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Excel-Data-Entry-Form-dialog-box.png\" alt=\"Excel Data Entry Form dialog box\" width=\"486\" height=\"409\" srcset=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Excel-Data-Entry-Form-dialog-box.png 486w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Excel-Data-Entry-Form-dialog-box-356x300.png 356w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Excel-Data-Entry-Form-dialog-box-50x42.png 50w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Excel-Data-Entry-Form-dialog-box-250x210.png 250w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Excel-Data-Entry-Form-dialog-box-119x100.png 119w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Excel-Data-Entry-Form-dialog-box-238x200.png 238w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Excel-Data-Entry-Form-dialog-box-178x150.png 178w\" sizes=\"(max-width: 486px) 100vw, 486px\" \/><\/p>\n<p>The highlighted fields are where you would enter the data. Once done, hit the Enter key to make the data a part of the table and move on to the next entry.<\/p>\n<p>Below is a demo of how it works:<\/p>\n<p><img decoding=\"async\" class=\"size-full wp-image-26623 aligncenter\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Data-Entry-Form-in-Excel-Demo.gif\" alt=\"Data Entry Form in Excel - Demo\" width=\"748\" height=\"640\" \/><\/p>\n<p>As you can see, this is easier than regular data entry as it has everything in a single dialog box.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Data-Entry-Form-in-Excel\"><\/span>Data Entry Form in Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Using a data entry form in Excel needs a little pre-work.<\/p>\n<p>You would notice that there is no option to use a data entry form in Excel (not in any tab in the ribbon).<\/p>\n<p>To use it, you will have to first add it to the Quick Access Toolbar (or the ribbon).<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Adding-Data-Entry-Form-Option-To-Quick-Access-Toolbar\"><\/span>Adding Data Entry Form Option To Quick Access Toolbar<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Below are the steps to add the data entry form option to the Quick Access Toolbar:<\/p>\n<ol>\n<li>Right-click on any of the existing icons in the Quick Access Toolbar.<\/li>\n<li>Click on &#8216;Customize Quick Access Toolbar&#8217;.<img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-26635 aligncenter\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Customize-the-Quick-Access-Toolbar-option.png\" alt=\"Customize the Quick Access Toolbar option\" width=\"411\" height=\"182\" srcset=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Customize-the-Quick-Access-Toolbar-option.png 411w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Customize-the-Quick-Access-Toolbar-option-50x22.png 50w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Customize-the-Quick-Access-Toolbar-option-250x111.png 250w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Customize-the-Quick-Access-Toolbar-option-226x100.png 226w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Customize-the-Quick-Access-Toolbar-option-400x177.png 400w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Customize-the-Quick-Access-Toolbar-option-339x150.png 339w\" sizes=\"(max-width: 411px) 100vw, 411px\" \/><\/li>\n<li>In the &#8216;Excel Options&#8217; dialog box that opens, select the &#8216;All Commands&#8217; option from the drop-down.<img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-26636 aligncenter\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Select-All-Commands-from-the-drop-down.png\" alt=\"Select All Commands from the drop down\" width=\"562\" height=\"278\" srcset=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Select-All-Commands-from-the-drop-down.png 562w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Select-All-Commands-from-the-drop-down-50x25.png 50w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Select-All-Commands-from-the-drop-down-250x124.png 250w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Select-All-Commands-from-the-drop-down-202x100.png 202w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Select-All-Commands-from-the-drop-down-400x198.png 400w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Select-All-Commands-from-the-drop-down-303x150.png 303w\" sizes=\"(max-width: 562px) 100vw, 562px\" \/><\/li>\n<li>\u00a0Scroll down the list of commands and select &#8216;Form&#8217;.<img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-26637 aligncenter\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Select-Form-option-in-the-Excel-Options-dialog-box.png\" alt=\"Select Form option in the Excel Options dialog box\" width=\"554\" height=\"347\" srcset=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Select-Form-option-in-the-Excel-Options-dialog-box.png 554w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Select-Form-option-in-the-Excel-Options-dialog-box-479x300.png 479w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Select-Form-option-in-the-Excel-Options-dialog-box-50x31.png 50w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Select-Form-option-in-the-Excel-Options-dialog-box-250x157.png 250w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Select-Form-option-in-the-Excel-Options-dialog-box-160x100.png 160w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Select-Form-option-in-the-Excel-Options-dialog-box-319x200.png 319w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Select-Form-option-in-the-Excel-Options-dialog-box-239x150.png 239w\" sizes=\"(max-width: 554px) 100vw, 554px\" \/><\/li>\n<li>Click on the &#8216;Add&#8217; button.<img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-26638 aligncenter\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Click-on-the-Add-button.png\" alt=\"Click on the Add button\" width=\"668\" height=\"475\" srcset=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Click-on-the-Add-button.png 668w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Click-on-the-Add-button-422x300.png 422w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Click-on-the-Add-button-50x36.png 50w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Click-on-the-Add-button-250x178.png 250w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Click-on-the-Add-button-141x100.png 141w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Click-on-the-Add-button-281x200.png 281w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Click-on-the-Add-button-211x150.png 211w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Click-on-the-Add-button-650x462.png 650w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Click-on-the-Add-button-665x473.png 665w\" sizes=\"(max-width: 668px) 100vw, 668px\" \/><\/li>\n<li>Click OK.<\/li>\n<\/ol>\n<p>The above steps would add the Form icon to the Quick Access Toolbar\u00a0 (as shown below).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-26639 aligncenter\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Excel-Data-Entry-Form-icon-in-QAT.png\" alt=\"Excel Data Entry Form icon in QAT\" width=\"258\" height=\"89\" srcset=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Excel-Data-Entry-Form-icon-in-QAT.png 258w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Excel-Data-Entry-Form-icon-in-QAT-50x17.png 50w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Excel-Data-Entry-Form-icon-in-QAT-250x86.png 250w\" sizes=\"(max-width: 258px) 100vw, 258px\" \/><\/p>\n<p>Once you have it in QAT, you can click any cell in your dataset (in which you want to make the entry) and click on the Form icon.<\/p>\n<div class=\"cbyellow\">Note: For Data Entry Form to work, your data should be in an <a href=\"https:\/\/trumpexcel.com\/excel-table\/\" target=\"_blank\" rel=\"noopener noreferrer\">Excel Table<\/a>. If it isn&#8217;t already, you&#8217;ll have to convert it into an Excel Table (keyboard shortcut &#8211; Control + T).<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Parts-of-the-Data-Entry-Form\"><\/span>Parts of the Data Entry Form<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>A Data Entry Form in Excel has many different buttons (as you can see below).<\/p>\n<p>Here is a brief description of what each button is about:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-26627 aligncenter\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Buttons-of-the-Entry-Form-in-Excel.png\" alt=\"Buttons of the Entry Form in Excel\" width=\"751\" height=\"630\" srcset=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Buttons-of-the-Entry-Form-in-Excel.png 751w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Buttons-of-the-Entry-Form-in-Excel-358x300.png 358w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Buttons-of-the-Entry-Form-in-Excel-50x42.png 50w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Buttons-of-the-Entry-Form-in-Excel-250x210.png 250w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Buttons-of-the-Entry-Form-in-Excel-119x100.png 119w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Buttons-of-the-Entry-Form-in-Excel-238x200.png 238w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Buttons-of-the-Entry-Form-in-Excel-179x150.png 179w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Buttons-of-the-Entry-Form-in-Excel-551x462.png 551w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Buttons-of-the-Entry-Form-in-Excel-564x473.png 564w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Buttons-of-the-Entry-Form-in-Excel-676x567.png 676w\" sizes=\"(max-width: 751px) 100vw, 751px\" \/><\/p>\n<ul>\n<li><strong>New<\/strong>: This will clear any existing data in the form and allows you to create a new record.<\/li>\n<li><strong>Delete<\/strong>: This will allow you to delete an existing record. For example, if I hit the Delete key in the above example, it will delete the record for Mike Banes.<\/li>\n<li><strong>Restore<\/strong>: If you&#8217;re editing an existing entry, you can restore the previous data in the form (if you haven&#8217;t clicked New or hit Enter).<\/li>\n<li><strong>Find Prev<\/strong>: This will find the previous entry.<\/li>\n<li><strong>Find Next<\/strong>: This will find the next entry.<\/li>\n<li><strong>Criteria<\/strong>: This allows you to find specific records. For example, if I am looking for all the records, where the candidate was Hired, I need to click the Criteria button, enter &#8216;Hired&#8217; in the Status field and then use the find buttons. Example of this is covered later in this tutorial.<\/li>\n<li><strong>Close<\/strong>: This will close the form.<\/li>\n<li><strong>Scroll Bar<\/strong>: You can use the <a href=\"https:\/\/trumpexcel.com\/create-a-scroll-bar-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">scroll bar<\/a> to go through the records.<\/li>\n<\/ul>\n<p>Now let&#8217;s go through all the things you can do with a Data Entry form in Excel.<\/p>\n<p>Note that you need to convert your data into an Excel Table and select any cell in the table to be able to open the Data Entry form dialog box.<\/p>\n<p>If you haven&#8217;t selected a cell in the Excel Table, it will show a prompt as shown below:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-26629 aligncenter\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Table-Not-Selected-Prompt.png\" alt=\"Table Not Selected Prompt\" width=\"597\" height=\"145\" srcset=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Table-Not-Selected-Prompt.png 597w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Table-Not-Selected-Prompt-50x12.png 50w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Table-Not-Selected-Prompt-250x61.png 250w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Table-Not-Selected-Prompt-400x97.png 400w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Table-Not-Selected-Prompt-350x85.png 350w\" sizes=\"(max-width: 597px) 100vw, 597px\" \/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Creating-a-New-Entry\"><\/span>Creating a New Entry<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Below are the steps to create a new entry using the Data Entry Form in Excel:<\/p>\n<ol>\n<li>Select any cell in the Excel Table.<\/li>\n<li>Click on the Form icon in the Quick Access Toolbar.<img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-26639 aligncenter\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Excel-Data-Entry-Form-icon-in-QAT.png\" alt=\"Excel Data Entry Form icon in QAT\" width=\"258\" height=\"89\" srcset=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Excel-Data-Entry-Form-icon-in-QAT.png 258w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Excel-Data-Entry-Form-icon-in-QAT-50x17.png 50w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Excel-Data-Entry-Form-icon-in-QAT-250x86.png 250w\" sizes=\"(max-width: 258px) 100vw, 258px\" \/><\/li>\n<li>Enter the data in the form fields.<\/li>\n<li>Hit the Enter key (or click the New button) to enter the record in the table and get a blank form for next record.<\/li>\n<\/ol>\n<p><img decoding=\"async\" class=\"size-full wp-image-26623 aligncenter\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Data-Entry-Form-in-Excel-Demo.gif\" alt=\"Data Entry Form in Excel - Demo\" width=\"748\" height=\"640\" \/><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Navigating-Through-Existing-Records\"><\/span>Navigating Through Existing Records<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>One of the benefits of using Data Entry Form is that you can easily navigate and edit the records without ever leaving the dialog box.<\/p>\n<p>This can be especially useful if you have a dataset with many columns. This can save you a lot of scrolling and the process of going back and forth.<\/p>\n<p>Below are the steps to navigate and edit the records using a\u00a0 \u00a0data entry form:<\/p>\n<ol>\n<li>Select any cell in the Excel Table.<\/li>\n<li>Click on the Form icon in the Quick Access Toolbar.<\/li>\n<li>To go to the next entry, click on the &#8216;Find Next&#8217; button and to go to the previous entry, click the &#8216;Find Prev&#8217; button.<img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-26641 aligncenter\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Navigating-uing-the-Data-Entry-Form-in-Excel.png\" alt=\"Navigating uing the Data Entry Form in Excel\" width=\"486\" height=\"408\" srcset=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Navigating-uing-the-Data-Entry-Form-in-Excel.png 486w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Navigating-uing-the-Data-Entry-Form-in-Excel-357x300.png 357w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Navigating-uing-the-Data-Entry-Form-in-Excel-50x42.png 50w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Navigating-uing-the-Data-Entry-Form-in-Excel-250x210.png 250w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Navigating-uing-the-Data-Entry-Form-in-Excel-119x100.png 119w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Navigating-uing-the-Data-Entry-Form-in-Excel-238x200.png 238w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Navigating-uing-the-Data-Entry-Form-in-Excel-179x150.png 179w\" sizes=\"(max-width: 486px) 100vw, 486px\" \/><\/li>\n<li>To edit an entry, simply make the change and hit enter. In case you want to revert to the original entry (if you haven&#8217;t hit the enter key), click the &#8216;Restore&#8217; button.<\/li>\n<\/ol>\n<p>You can also use the scroll bar to navigate through entries one-by-one.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-26642 aligncenter\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Usinf-Scroll-Bar-to-Navigate.gif\" alt=\"Using Scroll Bar to Navigate\" width=\"492\" height=\"420\" \/><\/p>\n<p>The above snapshot shows basic navigation where you are going through all the records one after the other.<\/p>\n<p>But you can also quickly navigate through all the records based on criteria.<\/p>\n<p>For example, if you want to go through all the entries where the status is &#8216;In-progress&#8217;, you can do that using the below steps:<\/p>\n<ul>\n<li>Select any cell in the Excel table.<\/li>\n<li>Click on the Form icon in the Quick Access Toolbar.<\/li>\n<li>In the Data Entry Form dialog box, click the Criteria button.<img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-26643 aligncenter\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Criteria-Button-in-Excel-Data-Entry-Form.png\" alt=\"Criteria Button in Excel Data Entry Form\" width=\"486\" height=\"408\" srcset=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Criteria-Button-in-Excel-Data-Entry-Form.png 486w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Criteria-Button-in-Excel-Data-Entry-Form-357x300.png 357w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Criteria-Button-in-Excel-Data-Entry-Form-50x42.png 50w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Criteria-Button-in-Excel-Data-Entry-Form-250x210.png 250w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Criteria-Button-in-Excel-Data-Entry-Form-119x100.png 119w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Criteria-Button-in-Excel-Data-Entry-Form-238x200.png 238w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Criteria-Button-in-Excel-Data-Entry-Form-179x150.png 179w\" sizes=\"(max-width: 486px) 100vw, 486px\" \/><\/li>\n<li>In the Status field, enter &#8216;In-progress&#8217;. Note that this value is not case sensitive. So even if you enter IN-PROGRESS, it would still work.<img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-26644 aligncenter\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Specify-the-criteria-in-the-field.png\" alt=\"Specify the criteria in the field\" width=\"486\" height=\"408\" srcset=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Specify-the-criteria-in-the-field.png 486w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Specify-the-criteria-in-the-field-357x300.png 357w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Specify-the-criteria-in-the-field-50x42.png 50w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Specify-the-criteria-in-the-field-250x210.png 250w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Specify-the-criteria-in-the-field-119x100.png 119w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Specify-the-criteria-in-the-field-238x200.png 238w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Specify-the-criteria-in-the-field-179x150.png 179w\" sizes=\"(max-width: 486px) 100vw, 486px\" \/><\/li>\n<li>Use the Find Prev\/Find Next buttons to navigate through the entries where the status is In-Progress.<\/li>\n<\/ul>\n<p>Criteria is a very useful feature when you have a huge dataset, and you want to quickly go through those records that meet a given set of criteria.<\/p>\n<p>Note that you can use multiple criteria fields to navigate through the data.<\/p>\n<p>For example, if you want to go through all the &#8216;In-progress&#8217; records after 07-08-2018, you can use &#8216;&gt;07-08-2018&#8217; in the criteria for &#8216;Date&#8217; field and &#8216;In-progress&#8217; as the value in the status field. Now when you navigate using\u00a0Find Prev\/Find Next buttons, it will only show records after\u00a007-08-2018 where the status is In-progress.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-26645 aligncenter\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Two-criteira-in-data-entry-form.png\" alt=\"Two criteria in data entry form\" width=\"486\" height=\"408\" srcset=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Two-criteira-in-data-entry-form.png 486w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Two-criteira-in-data-entry-form-357x300.png 357w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Two-criteira-in-data-entry-form-50x42.png 50w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Two-criteira-in-data-entry-form-250x210.png 250w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Two-criteira-in-data-entry-form-119x100.png 119w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Two-criteira-in-data-entry-form-238x200.png 238w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Two-criteira-in-data-entry-form-179x150.png 179w\" sizes=\"(max-width: 486px) 100vw, 486px\" \/><\/p>\n<p>You can also use <a href=\"https:\/\/trumpexcel.com\/excel-wildcard-characters\/\" target=\"_blank\" rel=\"noopener noreferrer\">wildcard characters<\/a> in criteria.<\/p>\n<p>For example, if you have been inconsistent in entering the data and have used variations of a word (such as In progress, in-progress, in progress, and inprogress), then you need to use wildcard characters to get these records.<\/p>\n<p>Below are the steps to do this:<\/p>\n<ol>\n<li>Select any cell in the Excel table.<\/li>\n<li>Click on the Form icon in the Quick Access Toolbar.<\/li>\n<li>Click the Criteria button.<\/li>\n<li>In the Status field, enter\u00a0<strong>*progress<img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-26646 aligncenter\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Using-Wildcard-characters-in-data-entry-form-dialog-box.png\" alt=\"Using Wildcard characters in data entry form dialog box\" width=\"486\" height=\"408\" srcset=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Using-Wildcard-characters-in-data-entry-form-dialog-box.png 486w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Using-Wildcard-characters-in-data-entry-form-dialog-box-357x300.png 357w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Using-Wildcard-characters-in-data-entry-form-dialog-box-50x42.png 50w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Using-Wildcard-characters-in-data-entry-form-dialog-box-250x210.png 250w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Using-Wildcard-characters-in-data-entry-form-dialog-box-119x100.png 119w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Using-Wildcard-characters-in-data-entry-form-dialog-box-238x200.png 238w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Using-Wildcard-characters-in-data-entry-form-dialog-box-179x150.png 179w\" sizes=\"(max-width: 486px) 100vw, 486px\" \/><\/strong><\/li>\n<li>Use the Find Prev\/Find Next buttons to navigate through the entries where the status is In-Progress.<\/li>\n<\/ol>\n<p>This works as an asterisk (*) is a wildcard character that can represent any number of characters in Excel. So if the status contains the &#8216;progress&#8217;, it will be picked up by\u00a0Find Prev\/Find Next buttons no matter what is before it).<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Deleting-a-Record\"><\/span>Deleting a Record<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>You can delete records from the Data Entry form itself.<\/p>\n<p>This can be useful when you want to find a specific type of records and delete these.<\/p>\n<p>Below are the steps to delete a record using Data Entry Form:<\/p>\n<ol>\n<li>Select any cell in the Excel table.<\/li>\n<li>Click on the Form icon in the Quick Access Toolbar.<\/li>\n<li>Navigate to the record you want to delete<\/li>\n<li>Click the Delete button.<img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-26647 aligncenter\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Delete-a-record.png\" alt=\"Delete a record in Excel\" width=\"486\" height=\"408\" srcset=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Delete-a-record.png 486w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Delete-a-record-357x300.png 357w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Delete-a-record-50x42.png 50w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Delete-a-record-250x210.png 250w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Delete-a-record-119x100.png 119w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Delete-a-record-238x200.png 238w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Delete-a-record-179x150.png 179w\" sizes=\"(max-width: 486px) 100vw, 486px\" \/><\/li>\n<\/ol>\n<p>While you may feel that this all looks like a lot of work just to enter and navigate through records, it saves a lot of time if you&#8217;re working with lots of data and have to do data entry quite often.<\/p>\n<pre>Also read:\u00a0<a href=\"https:\/\/trumpexcel.com\/prevent-duplicate-entries-excel\/\">Prevent Duplicate Entries in Excel<\/a><\/pre>\n<h2><span class=\"ez-toc-section\" id=\"Restricting-Data-Entry-Based-on-Rules\"><\/span>Restricting Data Entry Based on Rules<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>You can use data validation in cells to make sure the data entered conforms to a few rules.<\/p>\n<p>For example, if you want to make sure that the date column only accepts a date during data entry, you can create a <a href=\"https:\/\/trumpexcel.com\/learn-all-about-data-validation-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">data validation<\/a> rule to only allow dates.<\/p>\n<p>If a user enters a data that is not a date, it will not be allowed and the user will be shown an error.<\/p>\n<p>Here is how to create these rules when doing data entry:<\/p>\n<ol>\n<li>Select the cells (or even the entire column) where you want to create a data validation rule. In this example, I have selected column A.<\/li>\n<li>Click the Data tab.<img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-26659 aligncenter\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Data-Tab-in-the-Ribbon.png\" alt=\"Data Tab in the Ribbon\" width=\"544\" height=\"194\" srcset=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Data-Tab-in-the-Ribbon.png 544w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Data-Tab-in-the-Ribbon-50x18.png 50w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Data-Tab-in-the-Ribbon-250x89.png 250w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Data-Tab-in-the-Ribbon-400x143.png 400w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Data-Tab-in-the-Ribbon-350x125.png 350w\" sizes=\"(max-width: 544px) 100vw, 544px\" \/><\/li>\n<li>Click the Data Validation option.<img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-26658 aligncenter\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Data-Validation-Option-in-the-Ribbon.png\" alt=\"Data Validation Option in the Ribbon\" width=\"402\" height=\"120\" srcset=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Data-Validation-Option-in-the-Ribbon.png 402w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Data-Validation-Option-in-the-Ribbon-50x15.png 50w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Data-Validation-Option-in-the-Ribbon-250x75.png 250w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Data-Validation-Option-in-the-Ribbon-400x119.png 400w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Data-Validation-Option-in-the-Ribbon-350x104.png 350w\" sizes=\"(max-width: 402px) 100vw, 402px\" \/><\/li>\n<li>In the &#8216;Data Validation&#8217; dialog box, within the &#8216;Settings&#8217; tab, select &#8216;Date&#8217; from the &#8216;Allow&#8217; drop down.<img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-26660 aligncenter\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Date-Option-in-Data-Validation-Drop-Down.png\" alt=\"Date Option in Data Validation Drop Down\" width=\"587\" height=\"412\" srcset=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Date-Option-in-Data-Validation-Drop-Down.png 587w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Date-Option-in-Data-Validation-Drop-Down-427x300.png 427w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Date-Option-in-Data-Validation-Drop-Down-50x35.png 50w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Date-Option-in-Data-Validation-Drop-Down-250x175.png 250w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Date-Option-in-Data-Validation-Drop-Down-142x100.png 142w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Date-Option-in-Data-Validation-Drop-Down-285x200.png 285w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Date-Option-in-Data-Validation-Drop-Down-214x150.png 214w\" sizes=\"(max-width: 587px) 100vw, 587px\" \/><\/li>\n<li>Specify the start and the end date. Entries within this date range would be valid and rest all would be denied.<img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-26661 aligncenter\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Start-and-End-Date-in-Data-Validation.png\" alt=\"Start and End Date in Data Validation\" width=\"587\" height=\"412\" srcset=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Start-and-End-Date-in-Data-Validation.png 587w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Start-and-End-Date-in-Data-Validation-427x300.png 427w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Start-and-End-Date-in-Data-Validation-50x35.png 50w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Start-and-End-Date-in-Data-Validation-250x175.png 250w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Start-and-End-Date-in-Data-Validation-142x100.png 142w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Start-and-End-Date-in-Data-Validation-285x200.png 285w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Start-and-End-Date-in-Data-Validation-214x150.png 214w\" sizes=\"(max-width: 587px) 100vw, 587px\" \/><\/li>\n<li>Click OK.<\/li>\n<\/ol>\n<p>Now, if you use the data entry form to enter data in the Date column, and if it isn&#8217;t a date, then it will not be allowed.<\/p>\n<p>You will see a message as shown below:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-26656 aligncenter\" src=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Data-Validation-Error-when-doing-data-entry-with-a-form-in-Excel.png\" alt=\"Data Validation Error when doing data entry with a form in Excel\" width=\"531\" height=\"145\" srcset=\"https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Data-Validation-Error-when-doing-data-entry-with-a-form-in-Excel.png 531w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Data-Validation-Error-when-doing-data-entry-with-a-form-in-Excel-50x14.png 50w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Data-Validation-Error-when-doing-data-entry-with-a-form-in-Excel-250x68.png 250w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Data-Validation-Error-when-doing-data-entry-with-a-form-in-Excel-400x109.png 400w, https:\/\/trumpexcel.com\/wp-content\/uploads\/2018\/08\/Data-Validation-Error-when-doing-data-entry-with-a-form-in-Excel-350x96.png 350w\" sizes=\"(max-width: 531px) 100vw, 531px\" \/><\/p>\n<p>Similarly, you can use data validation with data entry forms to make sure users don&#8217;t end up entering the wrong data. Some examples where you can use this is numbers, text length, dates, etc.<\/p>\n<p>Here are a few important things to know about Excel Data Entry Form:<\/p>\n<ol>\n<li>You can use wildcard characters while navigating through the records (through criteria option).<\/li>\n<li>You need to have an Excel table to be able to use the Data Entry Form. Also, you need to have a cell selected in it to use the form. There is one exception to this though. If you have a <a href=\"https:\/\/trumpexcel.com\/named-ranges-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">named range<\/a> with the name &#8216;Database&#8217;, then the Excel Form will also refer to this named range, even if you have an Excel table.<\/li>\n<li>The field width in the Data Entry form is dependent on the column width of the data. If your column width is too narrow, the same would be reflected in the form.<\/li>\n<li>You can also insert <a href=\"https:\/\/trumpexcel.com\/bullet-points\/\" target=\"_blank\" rel=\"noopener noreferrer\">bullet points<\/a> in the data entry form. To do this, use the keyboard shortcut ALT + 7 or ALT + 9 from your numeric keypad. Here is a <a href=\"https:\/\/www.youtube.com\/watch?v=cE5QFgUk7i8\" target=\"_blank\" rel=\"noopener noreferrer\">video about bullet points<\/a>.<\/li>\n<\/ol>\n<p><strong>You May Also Like the Following Excel Tutorials:<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/trumpexcel.com\/excel-interview-questions\/\" target=\"_blank\" rel=\"noopener noreferrer\">100+ Excel Interview Questions.<\/a><\/li>\n<li><a href=\"https:\/\/trumpexcel.com\/excel-drop-down-list\/\" target=\"_blank\" rel=\"noopener noreferrer\">Drop Down Lists in Excel<\/a>.<\/li>\n<li><a href=\"https:\/\/trumpexcel.com\/find-and-remove-duplicates-in-excel\/\" target=\"_blank\" rel=\"noopener noreferrer\">Find and Remove Duplicates in Excel.<\/a><\/li>\n<li><a href=\"https:\/\/trumpexcel.com\/excel-text-to-columns-examples\/\" target=\"_blank\" rel=\"noopener noreferrer\">Excel Text to Columns.<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Watch the Video on Using Data Entry Forms in Excel Below is a detailed written tutorial about Excel Data Entry form in case you prefer reading over watching a video. Excel has many useful features when it comes to data entry. And one such feature is the Data Entry Form. In this tutorial,\u00a0 I will &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to Create a Data Entry Form in Excel\" class=\"read-more button\" href=\"https:\/\/trumpexcel.com\/data-entry-form\/#more-24425\" aria-label=\"Read more about How to Create a Data Entry Form in Excel\">Read more<\/a><\/p>\n","protected":false},"author":80,"featured_media":26627,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[157,20],"class_list":["post-24425","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-tips","tag-data-entry","tag-efficiency-tip"],"_links":{"self":[{"href":"https:\/\/trumpexcel.com\/wp-json\/wp\/v2\/posts\/24425","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/trumpexcel.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/trumpexcel.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/trumpexcel.com\/wp-json\/wp\/v2\/users\/80"}],"replies":[{"embeddable":true,"href":"https:\/\/trumpexcel.com\/wp-json\/wp\/v2\/comments?post=24425"}],"version-history":[{"count":0,"href":"https:\/\/trumpexcel.com\/wp-json\/wp\/v2\/posts\/24425\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/trumpexcel.com\/wp-json\/wp\/v2\/media\/26627"}],"wp:attachment":[{"href":"https:\/\/trumpexcel.com\/wp-json\/wp\/v2\/media?parent=24425"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/trumpexcel.com\/wp-json\/wp\/v2\/categories?post=24425"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/trumpexcel.com\/wp-json\/wp\/v2\/tags?post=24425"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}