How to automatically generate dates in excel tables

This article is about how dates are automatically generated in excel tables. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

The method of automatic date generation in the table: first open the excel table that needs to automatically generate the date, select a cell; then press the "ctrl" + ":" key on the keyboard, the cell will automatically display the date.

The operating environment of this tutorial: windows7 system, Microsoft Office Excel2010 version, Dell G3 computer.

Open the excel table.

Then select a cell.

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

If you want to change the format of the date, right-click and select set Cell format.

Then select the date format.

Finally, click OK.

Thank you for reading! On "how to automatically generate dates in the excel table" this article is shared here, I hope the above content can be of some help to you, so that you can learn more knowledge, if you think the article is good, you can share it out for more people to see it!