• Home
  • Blog
  • About
  • FGA
  • Menu

Nellipalooza

  • Home
  • Blog
  • About
  • FGA

Excel Tip of Today: Quick Date

February 22, 2016 in Tips, Productivity

Quickly enter the current date into a cell:

CTRL+; (semi-colon)

...as you were.


Additionally:

  • To insert the current time, press CTRL+SHIFT+; (semi-colon).
  • To insert the current date and time, press CTRL+; (semi-colon), then press SPACE, and then press CTRL+SHIFT+; (semi-colon).

https://support.office.com/en-us/article/insert-the-current-date-and-time-in-a-cell

Tags: Excel, Microsoft, Office, Tips
Prev / Next
  • April 2022
    • Apr 13, 2022 Natures Highway Apr 13, 2022
  • June 2021
    • Jun 25, 2021 KC135R Tail Art Jun 25, 2021
  • September 2020
    • Sep 11, 2020 Studio X Sep 11, 2020
    • Sep 11, 2020 Audio Compression When Editing with Audacity? Sep 11, 2020
  • March 2020
    • Mar 1, 2020 Create a VCard file for sharing contact information Mar 1, 2020
  • November 2019
    • Nov 29, 2019 I Believe I Can Fly Nov 29, 2019
  • January 2019
    • Jan 27, 2019 Thunderstorm and Bird Visualizations Jan 27, 2019
  • October 2018
    • Oct 26, 2018 Ball Joints, Knuckles and Gaskets Oct 26, 2018
  • March 2017
    • Mar 3, 2017 777-300ER Operations at KPAE Mar 3, 2017
  • January 2017
    • Jan 15, 2017 Free Admission to National Parks 2017 Jan 15, 2017
  • May 2016
    • May 6, 2016 Mt. St. Helens May 6, 2016
    • May 4, 2016 OneNote - Tame the Receipts May 4, 2016
  • April 2016
    • Apr 22, 2016 Free Admission to Washington State Parks Apr 22, 2016
    • Apr 21, 2016 Free Admission to National Parks 2016 Apr 21, 2016
    • Apr 5, 2016 PDG - Night of the Living Dead ... And a Pontiac LeMans Apr 5, 2016
  • March 2016
    • Mar 30, 2016 RIP Abe Mar 30, 2016
    • Mar 30, 2016 How to 'Age' your carbon blade knife - Opinel Knife #8 Mar 30, 2016
    • Mar 17, 2016 Do You Even Salmon? Mar 17, 2016
    • Mar 11, 2016 Ice Cubes go Clink! Mar 11, 2016
    • Mar 11, 2016 Review: FromScratch Mar 11, 2016
    • Mar 10, 2016 Tech Support Scams Redux Mar 10, 2016
    • Mar 9, 2016 Excel Tip of Today: Simple Selection and Navigation Mar 9, 2016
    • Mar 8, 2016 Lenses - HiFi vs. LoFi Mar 8, 2016
    • Mar 8, 2016 Are You an Umbraphile? Mar 8, 2016
    • Mar 2, 2016 Boeing 727 Last Flight Mar 2, 2016
  • February 2016
    • Feb 22, 2016 Excel Tip of Today: Quick Date Feb 22, 2016
    • Feb 21, 2016 Can Crushing for Science Feb 21, 2016
    • Feb 14, 2016 Beautiful Machine: Help me find it Feb 14, 2016
    • Feb 5, 2016 How to make clear ice cubes Feb 5, 2016
    • Feb 5, 2016 Wanted: Speakers for Cheap Feb 5, 2016
    • Feb 4, 2016 Dreaming of Dreamliners Feb 4, 2016
    • Feb 4, 2016 Baofeng Handheld Radios Feb 4, 2016
    • Feb 4, 2016 OneNote - OneDrive - Office Lens Feb 4, 2016