How to Add Date & Time to Comments Using Keyboard Shortcut
Adding date to excel comments and sometimes adding both date & time to comments become crucial. It makes your comments precise. You can keep track of things more easily.
In previous tutorial I’ve showed you how you can do it automatically using vba: [ Ссылка ] and in this tutorial we are going to do it using keyboard shortcut. Though its not automatic but its easier and doesn’t require vba.
Learn Everything On Excel Comments Here: [ Ссылка ]
I am going to use the basic keyboard shortcuts in excel. There are two shortcuts available. First shortcut is for the Date. Whenever & wherever you press it, it will bring up today's date in excel. You can use the same shortcut inside comment and you can add dates to comment using that very keyboard shortcut.
The second ways are the same as how do you insert an automatic timestamp in excel using keyboard shortcut. The shortcut used for adding timestamp in excel is also used inside comments. With that shortcut you can add time to you excel comments. Now if you use both keyboard shortcut you will get both date and time inside your comments.
This is the easiest way of adding timestamp in excel comments. You can use this keyboard shortcut to insert current date / current time to both comments and excel cells.
#Date&Time #KeyboardShortcut
Thanks for watching.
-------------------------------------------------------------------------------------------------------------
Support the channel with as low as $5
[ Ссылка ]
-------------------------------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial
[ Ссылка ]
Here goes the most recent video of the channel:
[ Ссылка ]
Playlists:
Advance Excel Tutorial: [ Ссылка ]
Excel Tutorial for Beginners: [ Ссылка ]
Excel Case: [ Ссылка ]
Combine Workbook & Worksheets: [ Ссылка ]
All About Comments in Excel: [ Ссылка ]
Excel VBA Programming Course: [ Ссылка ]
Social media:
Facebook: [ Ссылка ]
Twitter: [ Ссылка ]
Blogger: [ Ссылка ]
Tumblr: [ Ссылка ]
Instagram: [ Ссылка ]
Hubpages: [ Ссылка ]
How To Add Date And Time To Comments Using Keyboard Shortcut
Теги
Excel 10 Tutorialexcel tutorialexceltutorialmicrosoft excelexcel 2019excel tricksexcel tipse10tshortcut key for date and time in excelkeyboard shortcut in exceldate & time keyboard shortcutdate & timeexcel shortcut date formatshortcut key for date and time together in excelhow to put date in excel comment shortcutquickly add date and time stamps to an excel worksheetexcel commentscommentscomments in excelcell commentkeyboard shortcuts