Look Who it Was Random video

Excel - Time-Saving Excel Shortcuts: Enter Today's Date, Format Text, & View Formulas - Episode 542

674 views · Published 29 July 2009 · 3:46 · Indexed 20 September 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial: Time-Saving Excel Shortcuts: Enter Today's Date, Format Text, & View Formulas.

Welcome back to the MrExcel netcast, where we explore all things Excel. In today's episode, we'll be discussing some handy shortcuts that can save you time and make your Excel experience even more efficient. 

First, we'll cover the shortcut for entering today's date. By using the key combination of control and semicolon, you can quickly input today's date into your spreadsheet. But that's not all - we'll also show you how to enter the current time using control and shift and the colon key. These shortcuts are easy to remember and can save you valuable time when working with dates and times in Excel. 

But that's not all - we'll also dive into some other useful shortcuts, such as control B for bold, control U for underline, and control I for italics. These shortcuts are great for formatting your data quickly and easily. And for those of you who use Excel for to-do lists, we'll show you how to cross off completed tasks using control 5 for strike through. 

But wait, there's more! Did you know that you can view all the formulas in your worksheet at once? By using the key combination of control and the tilde key (or the backwards accent key on some keyboards), you can toggle between viewing all formulas and viewing the results. This can be a helpful tool for troubleshooting and understanding your data. 

If you're a fan of shortcuts, you'll definitely want to check out the IdeasOn keyboard for Excel. This innovative product features key sets that display various Excel shortcuts, making it easy to learn and remember them. Plus, it's a great conversation starter for your next Excel training session. 

Thanks for tuning in to today's episode, and a special thanks to Jonathan from the UK for suggesting the shortcut for entering today's date. We hope you found these shortcuts helpful and that they will save you time and make your Excel experience even better. Don't forget to check out the IdeasOn keyboard on our website, and be sure to join us for our next episode on Thursday. Happy Excel-ing!

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/


Jonathan writes in to mention Ctrl ; enters todays date. In Episode 542, I run through several of my favorite shortcut keys, including Show Formulas, Visible Cells Only, and more.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Table of Contents:
(00:00) Introduction and email from Jonathan
(00:21) Entering today's date with shortcut key
(00:33) Other useful shortcut keys
(01:25) Shortcut for visible cells only
(02:05) Finding more shortcuts in Excel help
(02:15) Recommendation for a shortcut keyboard
(03:13) 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 

This video answers these common search terms:
Excel shortcut for bold, underline, and italics
Excel shortcut for copying visible cells only
Excel shortcut for strike through
Excel shortcut keys
Fourth of July holiday in the United States
How to enter today's date in Excel using shortcut
IdeasOn keyboard for Excel shortcuts
Keyboard shortcuts for video games
MrExcel keyboard for learning shortcuts
MrExcel podcast schedule
Shortcut to view all formulas in Excel worksheet
YouTube video shortcuts

Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152538/

More from this channel