Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Shortcut for Today's date in Excel 2007

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 24-06-2009
Member
 
Join Date: Apr 2009
Posts: 351
Shortcut for Today's date in Excel 2007
  

Hi i am using Ms office 2007 since couple of weeks. I like to work with keyboard rather than using mouse to be fast and save the time. Today i need a shortcut key to enter current date in Excel 2007. Is there any shortcut ? Please let me know.

Reply With Quote
  #2  
Old 24-06-2009
Member
 
Join Date: Jan 2008
Posts: 3,751
Re: Shortcut for Today's date in Excel 2007

Its definitely very useful to work with shortcuts on computer. To enter to days date in Excel 2007 you need to the box or the cell where you it to be. Keep pressed the Ctrl key and press ; semi colon key. Thats it.. You will see today's date there. Remember to hold the Ctrl key while pressing semi colon key.

In same way to enter time , this is the shortcut CTRL+ SHIFT+ : (colon).

To apply the Date format with the day, month, and year, press CTRL+SHIFT+#
Reply With Quote
  #3  
Old 24-06-2009
Member
 
Join Date: Feb 2009
Posts: 253
Re: Shortcut for Today's date in Excel 2007

For more Excel shortcuts, see this:-

How to count date in Microsoft Excel
Date Separator in Excel
Calculating date in Excel
[Excel] no increment date
Excel shortcut keys
Reply With Quote
  #4  
Old 24-06-2009
Member
 
Join Date: Apr 2009
Posts: 351
Re: Shortcut for Today's date in Excel 2007

Thanks buddy. That is what i really needed as it is in my job profile and i use waste time for typing the date. Also the extra shortcuts you have gave are little interesting. Thank you for helping me. I appreciate your help.
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Shortcut for Today's date in Excel 2007"
Thread Thread Starter Forum Replies Last Post
Disable Excel 2007 Date Auto Format Forrest Ranger MS Office Support 2 09-02-2012 06:36 PM
how do you disable copy & cut in MS Excel 2007 - ribbon, shortcut keys and right mouse sub menu? swb23 Windows Software 4 02-05-2011 05:55 AM
Excel 2007 impulsively formats whole work book in date format foraman Windows Software 5 29-11-2010 11:14 PM
Excel 2007 Date Bug zakir Software Development 3 01-08-2009 01:44 PM


All times are GMT +5.5. The time now is 04:39 AM.