Feedback by UserVoice

 

How can we improve Excel for Mac?

← Excel for Mac

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.

330 votes
Sign in
(thinking…)
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

Jim shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
not at this time  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded  · 

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.

Show previous admin responses (2)

103 comments

Sign in
(thinking…)
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Anonymous commented  ·   ·  Flag as inappropriate

    So having read the comments below, if I ditch 365 and buy an old version of Excel / Office, I will have Forms again?
    So those of us who BUY 365 every year, are acting as paying guinea pigs?
    Crazy

  • Aidan commented  ·   ·  Flag as inappropriate

    Sherry if he doesn't want to change his entire operating system, and his Mac has sufficient memory and hard drive space, you could buy Parallels Desktop, download Excel for Windows on that, and then use parallels in coherence mode (which basically let's you run Windows applications on your Mac, as if they were native Mac applications).

  • Anonymous commented  ·   ·  Flag as inappropriate

    I also miss Data Form. I used it all the time for adding data to a form. Now it is very difficult. I vote yes

  • Ben G-C commented  ·   ·  Flag as inappropriate

    Please, add this back. To shortchange so many users of your program is a major misstep, especially with such an essential and useful function.

  • Anonymous commented  ·   ·  Flag as inappropriate

    We just need the basic data forms available to us! UGH it's ridiculous not to have that available and even readily available

  • Al commented  ·   ·  Flag as inappropriate

    The is function needs to be RETURNED to Excel MAC. I have been using it since 1990 and to have it removed is just wrong. After all, the Microsoft Excel Mac sales literature says that 2019 has all the features we are used to, clearly features have been removed. Please return the data entry Form... feature to Excel for the Mac.

    Thanks.

  • Al commented  ·   ·  Flag as inappropriate

    I have been using this data entry Form... feature in Excel Mac since 1990 and I'm stunned that it was removed in Excel Mac 2019. Excel is now seriously hobbled without this Form... feature.

    Please return this important feature immediately.

  • Anonymous commented  ·   ·  Flag as inappropriate

    I used Data Form all the time in my previous version of Excel. I really miss it. The way I have to do it now is really inefficient.

  • Anonymous commented  ·   ·  Flag as inappropriate

    Let's make a strong current for Excel 2016 on the Mac to be updated with the use of forms. It is very difficult to work like this. Can anyone shed some light on the subject ?: What does Microsoft talk about?
    We buy the Microsoft product also when we use MAC. Please. Look at MAC users.

  • Sherry Carter commented  ·   ·  Flag as inappropriate

    You have just caused me merciless heartache with my boss. I work as his personal admin, he uses only macBooks and I am in a learning curve and you have made this so hard. I am going back to Windows and he will have to download Windows for mac. Please provide what we need... I . need a fast Userform application.

  • Anonymous commented  ·   ·  Flag as inappropriate

    I need tu use VBA on my Mac. Please fix it, I think in turning back to windows then :/

1 2 4 6

Excel for Mac: Other

Categories

Feedback and Knowledge Base

(thinking…)