Entering the Current Time or Date

March 30, 2013

0 comments

Excel on Mac   Excel Shortcuts for Mac   Excel Skin   How Excel Skin Works   Insert Date   Insert Time  



We’re a team of problem solvers, world travelers, idea guys, and doers, working to make using Excel on a Mac a better experience.

That’s enough about us -- whether you are new to Excel for Mac or an experienced user, you probably want to spend less time manipulating data and more time thinking. The Excel Skin will help you do that. If you are a PC user hesitant about switching to Mac because you don’t want to give up your customized menus and shortcuts, well, the Excel Skin just might be the myth-buster you need. Excel for Mac is just as capable as it is for the PC. And with the Excel Skin, you’ll relearn your old shortcuts in no time.

The Excel Skin makes it easy to be as proficient and efficient in Excel for Mac as on any other platform. Powerful shortcuts are presented intuitively on an elegant silicone keyboard skin. Shortcut and modifier keys are printed by color and heat fused onto our high quality silicone to ensure durability.

The Excel Skin a small product that will make a big difference in your life.

 

Insert Date or Time Shortcut

A shortcut to enter the date or time is one of those shortcuts that you first learn about and think, when will I ever use that?  Next thing you know you’re mashing away at your number keys trying to enter in the current date or time because the shortcut went in one ear and out the other.  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.  Lets start with the “Insert Date” shortcut.  

“Insert Date” shortcut text color corresponds to the “control” modifier key on our Excel Skin so we know the “Insert Date” shortcut is executed by pressing: 

⌃Semicolon (;)


The current date will appear in the cell you have selected.




To execute the “Insert Time” shortcut we go through the same thought process.  The “Insert Time” text corresponds with the color on the “command” key and therefore our shortcut is: 


⌘Semicolon (;)


The current time will now appear in the cell you have selected.



Leave a comment

Comments will be approved before showing up.