Posts
Inserting date & time quickly date & time serves very specific purpose.
1. use =now function to insert date & time.
2. Copy the cell.
3. Go to the target cell or if it is the same cell, press delete to remove the above step - 1 function.
4. Double click in the target cell and get into editing mode.
5. paste only value, keyboard shortcut would be CTRL + SHIFT + V.
1. use =now function to insert date & time.
2. Copy the cell.
3. Go to the target cell or if it is the same cell, press delete to remove the above step - 1 function.
4. Double click in the target cell and get into editing mode.
5. paste only value, keyboard shortcut would be CTRL + SHIFT + V.
No comments:
Post a Comment