How do I insert a timestamp automatically when data is updated in another column in Excel?Īuto insert timestamp while entering dataįirstly, click File > Options to open the Excel Options dialog, choose Formulas in the left pane, then check Enable iteractive calculation in Calculation options group. Release the mouse button and select either Fill Months or Fill Years from the menu that displays. With the RIGHT mouse button pressed, drag to select the cells to autofill. Hover the mouse over the lower right edge of the cell until you see the Fill Handle. Key in the starting date and format the cell. at the lower-right corner of the cell, hold down, and drag to fill the rest of the series. Drag the fill handle across the adjacent cells that you want to fill with sequential dates.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |