Forum Discussion
2019 Excel on Mac no data entry form
null null I assume that you're trying to enter a bunch of records with minimal clicking and typing to navigate from one record to the next.
I 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. In the screenshot below, the 2nd row was completed by typing e TAB f TAB g TAB h, and then the 3rd row was created by pressing TAB.
Thanks Steve,
I've not used the Table's process, I'll give it a go.
As regards my original question, I have since found ways round it using a multi-sheet workbook and VBA macros to process the entries and to move around the workbook. All such methods developed with the aid of this forum and others like it - members' responses, such as yours have been invaluable.
I now have a reasonable Excel replacement to Win 7 MS Money nearing the end of trials in time for the demise of support for Win 7 in January '20.
Regards and thanks
Mike
