When you need to enter massive amounts of data in an Excel worksheet, typically, the input is done column by row, but this method of inputting data wastes a lot of valuable time in switching rows and columns, and it's easy to make mistakes, and you can use the "record sheet" feature provided by Excel to quickly enter data.
Operation Steps:
1, in the Open Excel workbook, click the file button to switch to the background view, and then click the Options button, as shown in Figure 1:
2. Switch to the Quick Access Toolbar tab in the Excel Options dialog box that opens, and select commands that are not in the Ribbon from the Select commands from the following location Drop-down list, as shown in Figure 2:
3, then find the "Record" command, select "Record List", click the "Add" button, add it to the custom Quick Access Toolbar, and finally click the "OK" button, as shown in Figure 3:
4, can be found in the Quick Access Toolbar "record List" command, when we enter data, click the "Record" button, in the Open dialog box can easily enter data, such as Figure 4:
5. If you want to enter a new record, click the New button directly, and then enter the data in the appropriate field text box, and then click the New button again after you enter the record sheet, so that the form information you just entered is added to the Excel workbook, as shown in Figure 5:
6, of course, also through the "record list" information to "Delete, find or browse" a certain record, as shown in Figure 6: