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.
109 comments
-
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
-
iam pjsmith
commented
Please add this ASAP!
-
Anonymous
commented
Please add all the functionality about forms in excel.
-
Anonymous
commented
Please add all the functionality about forms in excel. Why users of mac cannot use the same functions as windows? Excel for mac is near to incompatibility with windows. If it is not solved, excel don't work for me, and I will not pay again for office 365. So Microsoft, if you want my money, do your job.
-
barry johansen
commented
Dataentry on very wide spreadsheets is a PIA. The data form made it a lot easier to read and enter/search/edit
-
mehmet
commented
Please restore this function Data Form back.
-
Anonymous
commented
Hi ADMIN, we need the functionality to easily create n data-try field, in which you can design the layout. If you have a large worksheet with many column, some of the cells contain calculations, some cells contain basic data (f.i. Hourrate) as a parameter for the calculations, some cells are for entry of actual data and some cells contains descriptions of transactions
In such a worksheet it is incomprehensive to enter records because you need to scroll a lot and you miss overview of all data in that record.
With the form-functionality we could define a sub-screen that shows alle the fields of a record, in an clear and easy to overlook layout. Scrolling from left to right is not necessary and you have an overview per record to check of the calculated results match your expectations.
I use this for our bookkeeping of our small (one person) business.
Please let me know that Microsoft will offer a functionality to make this possible.
Grtz, David.of VBA in