This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I would like to use a simple vertical data entry form with a data table. A new form for each row. I cant find the "Form" tab to be placed in the Ribbon and therefor just cant setup a data entry form.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Data entry form
If you are comfortable with VBA, then you can use below alternative.
https://www.contextures.com/xlForm02.html
Another approach to making a data entry form in Excel is to use the web
Hi JHvw,
I go through the post carefully, in Excel for Mac there could be not built in Data entry forms in Excel for Mac, I would suggest you vote and leave your comments under the feedback thread in Excel Feedback community: Restore data form functionality (different from VBA UserForms) · Community (microsoft.com), the related team of Excel are aware of the requirements, though the feature is not in the plan now, your feedback will address the feature and will promote them to develop it. Thanks for your patience and understanding!
As a workaround, you may create data entry form with VBA, you may find related discussions on this from the link: Data Entry Form in Excel- Office 365 for Mac - Microsoft Community
Best Regards,
Clark