This problem is relatively easy to solve.In Excel, if the subsequent worksheet data is automatically generated after the cell is filled in with the date, it may be because of the PivotTable report or data option settings. The solution is as follows: 1. First, select the column to display data on the top of the table, and click the PivotTable tab on the right. 2. Select the data range to be displayed in the pop-up window and click "OK". 3. If the above methods are invalid, you can find the corresponding settings in "Data Options" and adjust them to the correct format. I hope the above methods can help you solve the problem.If you have any other questions, please feel free to consult.
Still don't understand.How to fill in the date number?Such as year, month, day or year/month/day, or XX day. What location is generated?New table?Existing table?What style of date?Don't consider the content?Or to what position?
You'd better learn this by yourself. It's easy to read and write. It takes a while to write. You'd better send the attachment so that everyone can download and write it directly. Otherwise, it's more difficult to implement without format, and no one will help you.
You first need a table that already contains these data, otherwise, the student ID cannot be automatically entered after entering the student name. If there is a table containing these data, the vlookup or hlookup formula can be used to implement the function of "entering the student name in cell a1, and automatically entering the student ID in cell b1".