Share via

How do I set up a data entry form in Excel Office 365?

Anonymous
2023-08-06T19:04:14+00:00

Apparently, there is a form button to be added to the top toolbar/ribbon, but I can't locate it. Also, I have the Mac Version of Excel so I wonder if it differs from PC versions. Can anybody help?

Microsoft 365 and Office | Excel | Other | MacOS

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.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jim G 134K Reputation points MVP Volunteer Moderator
    2023-08-07T14:45:34+00:00

    Data entry form

    If you are comfortable with VBA, then follow this link:
    https://www.contextures.com/xlForm02.html

    Another approach to making a data entry form in Excel is to use the web

    https://youtu.be/7UEdYkExwTo

    GETTING STARTED LEARN VBA in EXCEL

    https://www.youtube.com/watch?v=WKyN8e7XXjI

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2023-08-06T19:42:53+00:00

    Hi Michael G,

    Thank you for reaching out to us. I am Blessing, an independent advisor here and a Microsoft user like you.

    Sorry for this inconvenience but the Data Entry Form feature is available in Excel for Windows PC but it is not available in Excel 365 for Mac.

    Kindly find similar thread links for more information: https://answers.microsoft.com/thread/efe4f27b-581e-4d90-a389-3c92a3105a42

    https://answers.microsoft.com/thread/b3016eac-083f-497b-b20a-fefb4bbbc665

    You can send feedback to Microsoft as well: https://feedbackportal.microsoft.com/feedback

    Hope this helps!

    Give back to the community, help the next person who has this problem by indicating if this answer solved your problem. Click Yes or No below.

    0 comments