In Excel 2011 I was able to use SHIFT + CMD + SEMICOLON to insert today's date in a cell. Now it looks like it's not working anymore in Excel 2016, even though all keyboard shortcut maps online says they still should work. What I'm I doing wrong?
I have tried these 4 keyboard shortcuts in Excel 2016. SHIFT + CTR + SEMICOLON = Insert time in a cell SHIFT + CMD + SEMICOLON = Insert time in a cell SHIFT + CTR + COLON = Insert time in a cell SHIFT + CMD + COLON = Insert time in a cell I'm using Swedish Pro keyboard, but that should not affect anything since I tried switching to English US keyboard and same issues. Using the latest Excel 2016.
Note The information in this article applies to Excel versions 2019, 2016, 2013, 2010, 2007, and Excel for Mac. The shortcuts may vary between Excel for Windows and Excel for Mac. The shortcuts may vary between Excel for Windows and Excel for Mac. Here is how to execute the shortcut in 2 simple steps. Step 1: Select the cell you wish to enter the current date or time in. Step 2: There are, of course, 2 different shortcuts for entering the date and the time. Microsoft Excel graciously placed these two shortcuts on the same key, the semicolon or “;” key. The difference is in the modifier keys. Excel is quite robust, meaning there is a lot of different tools that can be utilized within it, and therefore there are many skills Excel Resources Excel Shortcuts - List of the most important & common MS Excel shortcuts for PC & Mac users, finance, accounting professions. Keyboard shortcuts speed up your modeling skills and save time.
Insert Time Or Date Shortcut On Ms Excel For Macro
And I have tried to completely uninstall and reinstall Office 2016 without any luck. Please confirm that your installation of Office 2016 is fully updated - 15.19.1 is the most current version for most users. Once confirmed/updated, Restart your Mac to see if the built-in keystrokes operate as they should: Command+; inserts the Time Control+; inserts the Date Did you see the last few postings in the conversation I referred you to? It appears that keyboard type/Input Method can have bearing on how the keystrokes work.Version 15.20 has been supplied only to Insider participants & Office 365 subscribers, but if you're one of them it's possible that the update has broken something. I don't know because I'm still on 15.19.1 OS X 10.10.5. Please mark HELPFUL or ANSWERED as appropriate to keep list as clean as possible ☺ Regards, Bob J.
Just looking to insert and delete cells/rows.