Need to record timestamps? If you're working in Excel, pressing CTRL + ; will enter the current date into a cell, CTRL + SHIFT + ; will enter the current time Happy Keyboard Shortcut Advent Calendar Day 19 🎁🎄😊 - ThreadSky

jenmsft.bsky.social • 70 days ago

Need to record timestamps?

If you're working in Excel, pressing CTRL + ; will enter the current date into a cell, CTRL + SHIFT + ; will enter the current time

Happy Keyboard Shortcut Advent Calendar Day 19 🎁🎄😊

Comments

dantecoyote.bsky.social•70 days ago

One of my favourites along with CTRL+' which copies the field above.

I also like pressing (one after the other) ALT then A then C. Which removes all the applied filters on a table.

pokersizeddeck.bsky.social•70 days ago

If people only took these tips as seriously as they take UFOs, we'd have cities on Mars by now.

gargaj.umlaut.hu•70 days ago

Just to go back to your question about which shortcuts are super useful: As someone who has to speak multiple languages, Win+Space to switch keyboard layouts is so much better than what LeftAlt+Shift used to be (which had no visual feedback and was easy to press inadvertently)

jenmsft.bsky.social•70 days ago

artificialwench.bsky.social•70 days ago

And it all comes crashing down when they try to use Excel as a database instead of something more appropriate.

jenmsft.bsky.social•70 days ago

Excel actually has a ton of useful shortcuts https://support.microsoft.com/en-us/office/keyboard-shortcuts-in-excel-1798d9d5-842a-42b8-9c99-9b7213f0040f (shift + F2 to add a note is great too!)

But did you know notepad also supports entering time stamps? 👀 https://bsky.app/profile/m-vaneerde.bsky.social/post/3ldobzlvnrc26

pdutta.net•70 days ago

Then there was this super old feature of adding “.LOG” as the first line in Notepad: https://superuser.com/a/217014

pyvd.bsky.social•70 days ago

The true revolution in my use of Notepad is when I learned that Alt + mouse permits to work on multiple lines, not just one line.
Mind. Blown.

malanalysis.bsky.social•70 days ago

To be fair, I was told the lynch pin for banks was COBOL. But I can see how Excel would likely be a day2day dependancy too.

daniloneto.bsky.social•70 days ago

lol I was strugling earlier today. An user somehow managed to install O365 with no admin access (at least that we know) and didn't uninstalled O2016. He was opening a spreadsheet with 2016 and crashing instantly, we weren't able to set O365 as default for opening and even uninstall 2016 xDD