This is a perfect and simple data entry form. When the active cell cursor is in the last cell of the table (lower right cell), pressing the Tab key will create a new empty row in the table ready for the next entry. This will cause the active cell cursor to move to the right instead of down so we can add the next value into our record. We can use the Tab key instead of Enter while entering our data. To add new data into our table we can start typing a new entry into the cells directly below the table and the table will absorb the new data. We now have our data inside an Excel table and we can use this to enter new data. Make sure the Create Table dialog box has the My table has headers option checked and press the OK button. The Ctrl + T keyboard shortcut will do the same thing.
We can also use a keyboard shortcut to create a table. Press the Table button in the Tables section.Select the range of data including the column headings.They’re perfect data containers and can be used as a simple data entry form.
0 kommentar(er)
