Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    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
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Shortcut for date and time (2000)

    There is not a single built-in shortcut for date + time. You could use
    <code>
    Ctrl+; Space Shift+Ctrl+;
    </code>
    You could also create a small macro in your Personal.xls macro workbook:
    <code>
    Sub InsertDateTime()
    On Error Resume Next
    ActiveCell = Now
    End Sub
    </code>
    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
  •