Hellow guys, Welcome to my website, and you are watching Excel - Create A Timestamp In Excel - Episode 1106. and this vIdeo is uploaded by MrExcel.com at 2009-09-22T06:32:59-07:00. We are pramote this video only for entertainment and educational perpose only. So, I hop you like our website.
| Name | Excel - Create A Timestamp In Excel - Episode 1106 |
| Video Uploader | Video From MrExcel.com |
| Upload Date | This Video Uploaded At 22-09-2009 13:32:59 |
| Video Discription | Microsoft Excel Tutorial: Add a timestamp to a cell in Excel. Welcome back to the MrExcel netcast! In today's episode, we have a great tip sent in by David from Australia. I may have shown this before, but it's definitely worth repeating because it's such a cool little trick. So let's dive right in! Have you ever used the function =now() in Excel? It's a handy function that automatically inserts the current date and time into a cell. But what if you only need the current date and not the time? That's where the function =today() comes in. It works just like =now(), but without the time component. This is useful when you want to calculate something based on the current date, but don't want it to change as you make updates to your spreadsheet. But what if you want a date and time that will never change, even if you make changes to your spreadsheet? Well, David has a couple of cool tricks for that. The first one is to simply press Ctrl+; and it will insert the current timestamp into the cell. But here's the real gem - if you press Ctrl+; and then immediately press Ctrl+Shift+;, it will give you a timestamp that will never change. This is perfect for tracking when certain data was entered into your spreadsheet. To help you remember this shortcut, just think of the colon in the time format. Ctrl+; for time, and Ctrl+Shift+; for date. It's a simple yet powerful trick that can save you time and effort in your Excel work. Thank you, David, for sending in this question and thank you for tuning in to another netcast from MrExcel. Don't forget to like, comment, and subscribe for more Excel tips and tricks. See you next time! Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/ You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/ Table of Contents: (00:00) Introduction by Bill Jelen (00:14) Tip from David in Australia (00:24) Using the Now function (00:34) The Today function (00:44) Creating a permanent date and time (00:57) Using Ctrl+; for current timestamp (01:07) Using Ctrl+; and Ctrl+Shift+; for timestamp (01:17) Remembering the shortcut (01:27) Clicking Like really helps the algorithm #excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial #exceltime #exceldates This video answers these common search terms: how to timestamp a cell in excel how to stamp time in excel create a timestamp in excel how to add timestamp in excel how to add timestamp to excel how to do a timestamp in excel how to add a timestamp in excel how to get a timestamp in excel how to insert time stamp excel how to create a timestamp in excel how to put automatic time stamp in excel how to create excel for time and date stamp David from Australia sends in a cool trick for adding a timestamp to a spreadsheet. Episode 1106 shows you how.Clicking Like really helps the algorithm Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152629/ |
| Category | Education |
| Tags | Excel | spreadsheets | tutorial | dates | NOW | Time | TODAY | Bill Jelen | Learn Excel | Excel Tutorial | Microsoft Excel | Excel Tips | how to timestamp a cell in excel | how to stamp time in excel | create a timestamp in excel | how to add timestamp in excel | how to add timestamp to excel | how to do a timestamp in excel | how to add a timestamp in excel | how to get a timestamp in excel | how to insert time stamp excel | how to create a timestamp in excel |
