How to automatically generate dates in tables

How to automatically generate dates in tables: First open the excel table that needs to automatically generate dates, select a cell; then press the "ctrl" and ":" keys on the keyboard, and the date will be automatically displayed in the cell. .

The operating environment of this tutorial: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.

Open the excel table.

Then select a cell.

Then press the "ctrl" ":" key on the keyboard, and the date will automatically be displayed in the cell.

#If you want to change the format of the date, right-click and select Format Cells.

Then select the date format.

Finally click OK.

Related learning recommendations: excel tutorial

The above is the detailed content of How to automatically generate dates in tables. For more information, please follow other related articles on the PHP Chinese website!