What Is a Functional Record?

Using Excel's "Record Sheet" function ---- In Excel, in the process of inserting a new record into a form with a large amount of data, a lot of time is wasted to switch the position of rows and columns back and forth. And Excel's "Record Sheet" can help you complete the data entry work in a small window, without having to enter in long forms. The specific steps are as follows: Click on any cell in your form and select "data" * "record". A dialog box will open (as shown in the figure), which contains the names of all the columns in the form. If you need to add a new data row, you just need to click the "New" button and fill in the blank text box after the data column name with the corresponding value of each column in the new record. ---- Use the "Record List" function to not only add new records easily, but also use it to search for specific cells in the form. First click the "Condition" button, all the column data in the dialog box will be cleared. Now type your query condition under the corresponding column name, and then click the "Next" button or "Previous" button to search. At this time, the qualified records will appear in the corresponding columns in the dialog box. Text box. This method is particularly suitable for queries with multiple query conditions, as long as the corresponding query conditions are entered simultaneously in the multiple column text boxes of the dialog box.

Record sheet

Right!

Using Excel's "Record Sheet" function ---- In Excel, in the process of inserting a new record into a form with a large amount of data, a lot of time is wasted to switch the position of rows and columns back and forth. And Excel "

Record: A document that records the required information in detail.

In excel, there is a record sheet function in the data item.

Using Excel's "Record Sheet" function ---- In Excel, in the process of inserting a new record into a form with a large amount of data, a lot of time is wasted in switching the position of rows and columns. And Excel's "Record Sheet" can help you complete the data entry work in a small window, without having to enter in long forms. The specific steps are as follows: Click on any cell in your form and select "data" * "record". A dialog box will open (as shown in the figure), which contains the names of all the columns in the form. If you need to add a new data row, you just need to click the "New" button and fill in the blank text box after the data column name with the corresponding value of each column in the new record. ---- Use the "Record List" function to not only add new records easily, but also use it to search for specific cells in the form. First click the "Condition" button, all the column data in the dialog box will be cleared. Now type your query condition under the corresponding column name, and then click the "Next" button or "Previous" button to search. At this time, the qualified records will appear in the corresponding columns in the dialog box. Text box. This method is particularly suitable for queries with multiple query conditions, as long as the corresponding query conditions are entered simultaneously in the multiple column text boxes of the dialog box.

We usually enter the corresponding data row by column in Excel. If the amount of data in the worksheet is huge, the length and width of the worksheet will also be very large. In this way, when inputting data, it will take a lot of precious time to switch back and forth between rows and columns, and it is even prone to errors.

excel 2003

Select any cell in the data range, execute the " data record " command, open the "record" form (as shown in the figure), click the "new" button, and then enter data in the corresponding cell, enter After finishing one record, press the "Enter" key or the "Next" button to enter the input state of the next record. (As shown below)

Note: When typing, please press the "Tab" key to move the mouse, you cannot press the "Enter" key to move the mouse!

(The record form of excel 2003 is similar to that of excel 2007)

excel 2007

The record sheet function is not placed in the data ribbon of excel 2007. Office button excel options custom , find the record sheet and add it to the quick access toolbar.

A shortcut

Alt + D + O

Note: In excel 2007, because this shortcut key combination is an excel2003 shortcut key, you need to press twice

The prompt will appear in the upper right corner when you press it for the first time. The shortcut is the shortcut for excel 2003, and then press the shortcut key combination again.

(PS: This is the key to type the letter "O", not the key to type the number "0." In Excel 2013, the first time you press the shortcut key "Alt + D + O" in the data ribbon, although there is no "record sheet "It's clear, but it can be done by pressing twice in a row.

Advantages of processing records through record sheets

The advantages of processing records through the record sheet are: intuitive interface, simple operation, reducing the back and forth switching between rows and columns during data processing, and avoiding input errors. It is especially suitable for checking, adding, searching, modifying or deleting records in large data lists.