How to automatically fill in time and date in Excel table How to set up automatic filling in time and date in Excel

How to automatically fill in time and date in Excel table? Many friends need to add a lot of time and date when editing tables, but adding it manually is very slow. We can set up automatic filling. Many people don’t know the setting steps, so today’s software tutorial will share with you the specific setting steps. Get up and find out.

The steps are as follows: 1. Open excel, enter information, and create a table.

2. Click on the file to open more options.

3. Find the formula in the options, check Enable iterative calculation and click OK.

4. Enter the formula in the date column of the table: =IF(B2=,,IF(C2=,TEXT(NOW(),yyyy-m-d h:mm:ss),C2)) , click the Enter key to complete the setting.

5. Enter the product name in the form and the sales time and date will be automatically filled in.

The above is the detailed content of How to automatically fill in time and date in Excel table How to set up automatic filling in time and date in Excel. For more information, please follow other related articles on the PHP Chinese website!