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
You can continue to comment on this suggestion, but we are marking it Not at this Time, to let you know the status of the request.
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.
83 comments
-
Jim
commented
Please restore this function Data Form back.
-
Anonymous
commented
It is unbelievable that there is no constructive explanation about the why it is a downgrade instead of an upgrade? Why would you (Windows) do this? Is it really necessary to block Mac-users that bad?
-
CliveM
commented
Absolutely agree. The recommendation to use Tables is not what is what we need. Using the Data Form is a great feature, each data point is assigned to the correct column header and inserts it the bottom line of data automatically. Manually using a Table is NOT IDEAL.
-
Anonymous
commented
Adding insult to injury, if you bite the bullet and try to design a form in VBA, you'll discover that VBA is also disabled in the Mac version of Excel.
-
Anonymous
commented
Tables are not forms. So disappointed with this news.
-
Anonymous
commented
You're asking why we can't use TABLES instead of FORMS. My question is why can't the FORMS function come to MAC? It is very easy to go to a button to create form on the fly with WINDOWS. Now, we have to look for VBA scripts to recreate this same function in a MAC OS environment.
I agree that if it's available for WINDOWS, then it should be available for MAC. Your suggestion to make a table within the sheet will not work to replace this feature. I can TAB across the row currently and I don't need to create a table to do that. The FORM feature in EXCEL provides a GUI that removes all other distractions and makes it easy for entering data. It lets you TAB down through the fields (instead of TAB across like you can now) and select ENTER to proceed to the next row. You have buttons already created to let you move through the records and now, we have none of that for MAC.
This is not a request for something that can't be done in EXCEL. This is a feature that clearly is used by many people in WINDOWS and it should be reinstated.
In the meantime, since this is not a demand but a simple request, would you be so kind as to post the VBA script for recreating the form that natively appears in EXCEL for WINDOWS? That way, we can create the form from scratch using your code and we can wait for you to implement the feature for MAC. We understand that this is a small request but us mere mortals only have the little things in life to help our day to day lives easier. Please please please bring this to MAC.
-
Anonymous
commented
This is not the only missing function in Office for Mac. In Powerpoint when you add slides from another presentation now you can't choose which slide you need to import and you can't choose whether you want to keep the origin structure or the destination structure. Really awful. If that's a way to get back to Windows the Mac users... forget it!!!!!!
-
Anonymous
commented
Without the Data Form feature, this should be called MS Excel Lite and be for free. To remove such a crucial feature after it has been there for decades is very unfriendly to the customer.
-
Anonymous
commented
i just got ms office 2019 mac verson and i am not able to locate data entry form. there for will u pls. suggest is there any other option ?
-
Paul
commented
When will Microsoft make an effort to ensure Office 365 users have access to the exact features in Office 365 for Windows PC? I am a Windows 7 PC user and decided to upgrade to a MAC. As a consumer, I expect Power Query; the same Visual Basic commands (Worksheet change) to be available on the Excel 365 for MAC version and Power BMI.
-
Anonymous
commented
This was the weirdest thing to remove from a newer version of Excel. It was so useful!! We need to back.
-
Todd Walck
commented
Hmm...I'm using O365 Home and can access forms.microsoft.com. It looks like it's granted to me because I am using a Microsoft personal account, per the following FAQ "Who can use Microsoft Forms?":
-
Jim
commented
Unfortunately, Microsoft forms does not come with office 365 home.
-
Todd Walck
commented
To get around this limitation I ended up creating a form using Microsoft Forms. Once I finished data entry, I downloaded the results in an Excel document.
It's not a perfect solution and I'm sure my use is very limited, but it worked for me in a pinch.
-
James McLallen
commented
I really use this feature a lot. I will not be subscribing to Office 365 when it comes up for renewal in a few months unless this is add back into Excel for Mac by then.
-
ali
commented
Please restore this function Data Form back.
-
carmela
commented
please restore built in DATA ENTRY FORM function on Mac
I'm on 2019 Office 365 -
abdus sami
commented
a very useful command, which i used frequently. when switching to Excel 365, I thought that i would have access to all the features and updates ready, but i see this command missing. Pls put it back
-
David James
commented
Because the reality is that it is a scam and should referred to trading standards. Upgrades normally improve on previous versions, not dumb them down at extra cost.
-
Jose G Machado
commented
Why do I have to pay full value for a version of Office365 for Mac, since it doesn't give me all the existing options for Windows? 😡
Solve it fast