Forum Discussion
2019 Excel on Mac no data entry form
I recently switched from PC to Mac. Then I found my Microsoft Access not available on Mac version Office. I tried to use Excel instead by creating a data entry form. Windows Excel 2016 is ok. But Mac...
Do you have access to PowerApps? You could create your data entry form there which can read/write to an Excel file in OneDrive, Sharepoint, etc.
Really frustrating the Form command is missing in Excel 365 Mac.
Thanks forum members for your tips.
Nico_Landsman I managed to do what I wanted using Microsoft Forms: https://www.microsoft.com/en-us/microsoft-365/online-surveys-polls-quizzes. Beautiful questions. Answers can be downloaded to Excel.
