The long date is in the following format: Day in Words, day number, month, year.
Current date: Ctrl ; (semicolon) Current time: Ctrl Shift ; (semicolon) When you use either of these shortcuts to enter a date or time into your worksheet, Excel enters a static value into the worksheet.
Tip 3: To create shorter time slots, click and drag in the calendar just a little, until your desired time slot is highlighted.
Change the time resolution on your calendar for even finer control.
To insert multiple rows at once, press [Shift] and select multiple row headers, then click [Insert].
NOTE: Mac users should use [Ctrl] [I] to insert a new row.[Ctrl] [Space Bar]: Selects the entire column of your active or selected cells.[Shift] [Space Bar]: Selects the entire row of your active or selected cells.[Space Bar]: Displays or removes a checked box, star, or flag in the selected cell.
Shift Alt D is an independent shortcut; it is not a shortcut for the Date and Time dialog box.
Hey, Your Mac has some fantastic shortcuts and workarounds to allow you to get things done faster.
Comes in very useful if you find you are writing the date frequently. Select the keyboard option, and then “Keyboard Shortcuts” from the tab options. Within the list that appears in the right hand box select “Long Date”, “Long Date & Time”, “Short Date”, “Short Date & Time” or “Time”. When you select the options they will appear in [App] The keyboard options allow you to enter them with a keystroke. If using the List or Agenda views, click on the event date in the mini calendar first before clicking ‘Add event’ – the start date will be set accordingly.Tip 5: When in the event editor, pressing the Enter key while in any of the main fields will save your event and close the window.In other words, the date or time that is entered does not change when the worksheet is recalculated.In most cases, this is probably what you want, but you should be aware of this limitation.