Excel Date & Time Shortcuts

13.05.2007 04:44
Excel Date & Time Shortcuts


To enter the date or time based on your PC's current clock setting into an Excel spreadsheet cell, you can use keyboard shortcuts and avoid that embarrassing typo.



After you click on the cell you want, press CTRL+; to insert the date or CTRL+: to enter the time.

Add your comment Send Print Report

Add your comment
  Anonymous comment
Nickname:
Password:
  Remember me on this computer

Title:
Send me by email any answer to my comment
Send me by email every new comment to this article

Home Page | Tip of the day
Latest
Body The state of the world Was the Yom Kippur War Preventable? Future peace Dear Mr. President, the three terrors Pod sweet pod: capsule rooms hit Hong Kong There Are Still Protesters Outside Dolce & Gabbana's Hong Kong Boutique Hong Kong Issues Advice On RMB Investment Products Hong Kong Leads Euromonitor's Top City Destinations Ranking London in HK link-up to trade in yuan China to Encourage More Yuan Listings in Hong Kong Girls' Generation wraps up successful solo concert in Hong Kong Hong Kong post goes to Dutch conductor Hong Kong health department recalls Teva drug
Eric's Latest
One of the cresults...Time to Reboot AmericaInt'l Arts Carnival to launch July 11L'Empereur du ChantBruce Lee to hit BroadwayArchives to reopen after floodCultural NomadKama Sutra For IT PeopleTan Yuanyuan accepts guest principal dancer position at Hong Kong BalletArt HK 08 Draws Huge Audiences
Embed in your website
Nasa
NASA Hosts Its First Google+ Hangout Connecting with Space Station NASA Casts A Wide Net For STEM Education Partners Reporters Invited to International Space Station Social Media Event NASA Experts Discuss Russia Meteor in Media Teleconference Today NASA Awards Final Space Launch System Advanced Booster Contract NASA'S Fermi Proves Supernova Remnants Produce Cosmic Rays NASA Targets March 1 Launch for Next SpaceX Station Resupply Mission; Media Accreditation Open NASA to Chronicle Close Earth Flyby of Asteroid NASA Spinoff 2012 Features New Space Tech Bettering Your Life Today NASA's Chandra Suggests Rare Explosion Created Our Galaxy's Youngest Black Hole
Google Blog
RISE Awards 2013: A global effort Fireside Hangouts: Join President Obama on Google+ after the State of the Union Solve for X: Celebrating moonshot thinking—join us and declare your X! Zagat: Who’s serving up the best service? A Chrome Experiment made with some friends from Oz Safer Internet Day: How we help you stay secure online Google and Brazil celebrate Carnival 2013 M&M’s, Beyonce and Ravens dominate game day searches on Google Google creates €60m Digital Publishing Innovation Fund to support transformative French digital publishing initiatives Exploring the Grand Canyon on Google Maps