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.
78 comments
-
Anonymous
commented
It would really be great to add forms back to excel for MAC.
-
Anonymous
commented
Need "user form" back in Mac excel 2016. The removal of this command is nothing less than STUPID.
May get rid of Excel and goto Numbers for Mac. -
Damaris
commented
Please enable VBA user form on Office 2016 for Mac
-
David James
commented
Simon queries why we have to continue with paying for new version of MS which are incrementally worse than the previous - a payment for downgrading. You don’t have to - you can move to the OpenOffice suite - it’s free, runs on most OS’s and has a macro system similar to MS’s. the only down side is that it is not exactly compatible with MS VBA and there is a steep learning curve. I think the wise move is not to upgrade MS Office until they sort it! This may take a long time......
-
SImon
commented
Why are we paying for Microsoft to make excel useless in increments? first VBA and now forms and many more. discuss....
-
Sam
commented
This is really sad that Microsoft do not say anything regarding these changes. I got office 2016 while ago I have so many Excel applications that use user form almost all of them now none of them works in this **** version. The **** with Microsoft office.
-
Anonymous
commented
Please bring back this feature!
-
David James
commented
In Excel 2011 for Mac the Form icon is available by right clicking on the quick access toolbar (at the top) and choosing "Customize Toolbars and menus..." then select Data in the left column and "Form..." in the right which can be dragged up onto the toolbar.
In Excel 2016 for Mac it is not available. The quick access toolbar customization is in Preferences, but the Form icon has been deleted.
Why Microsoft feel they need to firstly change the method of finding these controls and then deleting some is beyond my comprehension. My motto has always been "if it ain't broken DON'T FIX IT"!
-
Anonymous
commented
Please bring back this feature!
-
Anonymous
commented
Please restore this mega useful feature. Pretty please. Thank you.
You know not makes sense........
-
Jose G Machado
commented
I deeply regret the fact that MS does not make userform available to us Mac users. We pay the same amount of the full version for Windows and receive a lower product ...
-
Anonymous
commented
Data Form was simple and easy. Why the heck would you delete it?
-
Jim Gordon Mac MVP
commented
To access form controls, go to Excel Preferences > Ribbon and Toolbar. Turn the Developer tab on.
-
Roy
commented
No data form? Please reinstate the data form feature in Excel for Mac as this is sorely missed.
-
Anonymous
commented
Its a quick easy tool for end users to enter simple data into a worksheet. Please put data forms back into the Mac version.
-
Anonymous
commented
Are you kidding? No data form available!???
-
Anonymous
commented
Please add a data form capability to excel for mac 2016
-
JLBS
commented
Gridline functions do not work for printing nor in Preview.