Results 1 to 4 of 4

Thread: Shortcut for Today's date in Excel 2007

  1. #1
    Join Date
    Apr 2009
    Posts
    356

    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.

  2. #2
    Join Date
    Jan 2008
    Posts
    3,758

    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+#

  3. #3
    Join Date
    Feb 2009
    Posts
    253

    Re: Shortcut for Today's date in Excel 2007


  4. #4
    Join Date
    Apr 2009
    Posts
    356

    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.

Similar Threads

  1. Disable Excel 2007 Date Auto Format
    By Forrest Ranger in forum MS Office Support
    Replies: 2
    Last Post: 09-02-2012, 05:36 PM
  2. Replies: 4
    Last Post: 02-05-2011, 04:55 AM
  3. Replies: 5
    Last Post: 29-11-2010, 10:14 PM
  4. Excel 2007 Date Bug
    By zakir in forum Software Development
    Replies: 3
    Last Post: 01-08-2009, 12:44 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •