Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Thanked 0 Times in 0 Posts

    Shortcut for date and time (2000)

    Is there a shortcut to put the date and time in a cell? I know that ctrl + ; puts the date and ctrl+shift+: puts the time but how do you do both in a cell?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Shortcut for date and time (2000)

    There is not a single built-in shortcut for date + time. You could use
    Ctrl+; Space Shift+Ctrl+;
    You could also create a small macro in your Personal.xls macro workbook:
    Sub InsertDateTime()
    On Error Resume Next
    ActiveCell = Now
    End Sub
    and assign it a keyboard shortcut in Tools | Macro | Macros...

    See Personal.xls Tutorial (All) if you need help with Personal.xls

Posting Permissions

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