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.
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.
I recently "upgraded" to Microsoft 365. Previously used Excel for the Mac (pretty much every version since the beginning of time through Excel for Mac 2016).
It is mind boggling that you would eliminate a feature that has been in the Mac version of the software for decades while it still remains available in the Window version.
We use the Data Form because it is SIMPLE and obvious for employees who are not facile with Excel to be able to enter data without screwing up the data table or scrolling/tabbing clear across a wide page with many columns.
Not everyone uses just the first 8 columns on a spreadsheet. If you have a spreadsheet with 40 columns but new data only gets entered into six disparate ones, your suggestion that people merrily tab across the columns is a recipe for disaster.
PLEASE reinstall the simple data form entry function in Microsoft 365 for Mac!
Karen Figurelli commented
Data form makes it easier to create entries in a table - accuracy as it limits and validates the data. I really don't understand how that compares to the suggestion of using TAB.
This tools is so user friendly and easier compared to a table in excel. A good feature to remove. If this is removed, should have provided alternative means. O365 feature is so limiting in terms of speed when you have created an existing table or creating a form from an existing table.
Please add forms to Excel 365 for Mac. It is easier to transcend from table to forms, come on you should by now realise that it was a mistake to move forms.
You are right, as in this recent article on the subject:
one can read:
" Ideally, you have to use Excel for Windows if you’re a power user. "
James McLallen commented
But the is more to it than just data entry. Forms expand the table automatically and carry formula and formatting with it to the next row. In order to do the same thing in the way Admin describes you have to "insert" a new row just under the last row. Then you cave to copy every formula down to the new row. And if you have formulas that reference another worksheet that copying does not work. You have to create the formulae again. All that was done automatically with forms with the click of one button. I have been using Excel for 40+ years on PCs and Macs and I would suggest that it appears that those at Apple making these decisions are NOT professional Excel users.
Has one of you practically tested that this procedure for creating a Data Entry Form is actually not working :
Thanks in advance for your cooperation.
I miss the data entry form on excel for Mac. It makes data entry easy and less mistakes. why would I want to keep hitting the tab button and go across all my columns and sometimes making mistakes. When you have a large table and need to keep making entries you need the DATA ENTRY FORM. Please put it back in. Why on earth did you remove it.??
Danke für Ihren bisherigen Support !
Bitte implementieren Sie wieder die die "Form-Funktionen / Eigenschaften" !
Es ist für unsere Tätigkeiten sehr wichtig !!
Gene McGinnis commented
I don't see a Form and Table is being mutually exclusive. I have created a Table for individual assignments for a course I teach for 250 students. I have a Table that is 500 rows by 10 columns. I don't want students trying to go into the Table to choose an assignment and date. With a Form i could tell the students to choose their course section, their professor, and the specific assignment. Available dates would then show up that they could fill in. (not sure I explained this well).
I am trying to have large tables that other users can contribute to through an input form without them wading through a massive table.
Appie Dev commented
At the office where I am hired at the moment, they did buy 45 M1 chipped LT and Mini's. They have now 200+ mac's. They did test the MS suite on the M1's and decide to move the whole office ecosystem away from MS.
I saw that they will spend 100K for training and 250K for office app's conversions.
Shame and **** on you MS.
This is ridiculous. I don't even know how many hundreds of dollars I have painfully forked out to M$ for access to the 365 platform, and then when I actually NEED functionality, it's not there. I've been Windows-free for 15 years, and Microsoft continually gives me more reasons to further distance myself from their products.
Yes, Google Sheets has a Form feature, but I need VBA to freely exchange docs with Windows users. I never checked, but is it possible to sync Google Sheets with Excel?
Hopefully Microsoft won't mind us referring people to Google Sheets on their support forums?
That such a useful feature is not included for Mac is verging on crazy. There should be a reduction in cost for part completed software ...
You won't be able to do that. It is true, the Data Form feature is not part of the VBA Environment, nevertheless, the underlying language that makes it run is VBA. Not only is the Data Form feature gone, but VBA is not enabled either. So you won't be able to design your own data entry form. I tried.
Once MS decides to enable VBA again, then plugging in the script that runs the Data Form feature is just a mere slight of hand.
I want to make a Userform/Data form that is opened by a developer button, which would be used to auto fill a table instead of manual entry.
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.
Come on Fix This!