Restore data form functionality (different from VBA UserForms)
I miss the data form feature available in previous versions of Excel and would like to see it restored in Excel for Mac. Note that the Data Form feature is not the same as VBA UserForms. There's a separate suggestion if you want to vote for VBA UserForms.
Jim
shared this idea
Thanks for the suggestion about the Data Form. We don’t have plans to implement this in the near future, so we’re marking it “Not at this time”.
We recommend using Tables to make data entry easy. To create a table, just press CMD+T. With a table, you can press TAB to move across the fields and then it will automatically go to the beginning of the next line if you’re at the last field. If you’re on the last record in the table, it will add a new record to the end of the list.
Please comment to let us know what other reasons you’re using the Data Form that make it easier/better than using a Table.
116 comments
-
Anonymous
commented
To Tracy Ip
I tried to make a data entry form using Visual Basic. I could not. Because Visual Basic is disabled as well. Since the Data Form runs on VB, I believe that once Microsoft enables VB, the Data Form will come back too. All previous Mac versions had VB enabled, except for one, 2008 I believe? The uproar made Microsoft bring it back. So we have to go through all that rigamarole again... -
Tracy Ip
commented
please add the form key into office excel 2019 for Mac as soon as possible. I hope I can make the data entry form by myself. thanks for your kind help in advance. : P
-
Anonymous
commented
There is no apparent reason this function should not be available. "Not at this time" is just not acceptable.
-
Jacki Evans
commented
And this is why Microsoft is not on my favs list. I just started the free trial for MS 365 so I could update to my clients and it's just one hassle after another. Sheesh. Why can't we all just work together?
-
Anonymous
commented
I have the same problem- no Form for data entry.I have subscribed to Office 365 and working on Mac 2019. I think we should take this issue to social media. I would but I am not good at social media.
-
William
commented
Whoever decided to remove this feature just cost Microsoft a $500 sale, as well as another 6-7 licenses, as well. The suggestion "We recommend using Tables to made data entry easy" is simply missing the point. Just because it's a table, doesn't mean it's good for data entry. My users need a very simple, verticle form to enter the data into. It matches the format on the paper they are entering the data from, so they can quickly scan for errors.
We're just going to go ahead and commit to LibreOffice. They have everything we need at a price that can't be beat. Microsoft really screwed the pooch on this one.
-
Ryan
commented
I have multiple people editing my document and it was awesome to keep them out of the actual table. What a bummer to finally get to collaborate online using excel only to find out that I still wont let them do it because you guys removed form functionality.
-
Anonymous
commented
not making the dataform available to Mac users is an absurd lack of respect for those who paid for the product. They should be ashamed of the respect they are practicing against users and implement this function as quickly as possible.
-
Steve
commented
If you have dozens of columns, entering data horizontally is more difficult, time consuming and the headings are not immediately proximate (unless you add a blank row at top near headings). A data form allows for easy data entry and also with data validation.) It is a simple but needed feature in large tables. Please add back to Excel for Mac
-
Al
commented
I used Data Form for decades, designed spread sheets around them. They are far superior than Tables. To remove Data Form after decades is preposterous.
-
Abe
commented
Please restore this, why doesn't this exist for mac, makes absolutely no sense. Such a key vital feature. Excel for mac is useless without it
-
Sam
commented
Please restore data form function for Mac. Not fair for the subscription cost of 365!!!!
-
Anonymous
commented
I am so disappointed you removed the data entry form feature. Please return it. I need it. I want it. Not happy without it. Must I go to Google Sheets? Or some other?
-
Anonymous
commented
Time to move away for Microsoft application as they discontinued VBA forms on MAC and do not support VBA on iPad. It is a shame, great software applications from Microsoft and fantastic hardware from Apple. Any suggestions?
-
Nhu
commented
Everyone here has been requesting to add the data entry form on excel, and now it's June and the developer don't seem to care. A lot of us here prefer using Mac over PC, due to system crashing. Now the most important feature of Office you don't offer ACCESS and Data entry form on Excel. When will this be done? What is the advantage of removing this feature to all Mac users? We don't like PC, are you literally trying to force us to buy PC computers when we don't want to? I purchased 5 PC laptop over 10 years ago and all keeps crashing. I've been using Mac ever since with no issue. Please offer ACCESS and Data Form on Excel. Thank you
-
Anonymous
commented
A couple of days ago Excel came out with a couple of 'improvements' that they put back because of 'popular demand.' What a joke. Until they put back the Form Functionality and VBA, whatever else they do is just putting lipstick on a pig.
-
Ann
commented
What a disappointment that Data entry form is no longer available. It is much faster and less errors to use the form than moving around a table. I recommend putting it back and make people happy.
-
David
commented
Too bad that Microsoft for Apple misses an important function. They ignore users
-
anonymous
commented
Please add forms in Microsoft 365.
Had I known it was not available, I would not even have purchased Microsoft 365.
-
Anonymous
commented
please add forms in Microsoft 365