Here are three quick data entry tips for Excel — use these shortcuts to enter data in a cell:
-
To enter today’s date in a cell:Â Â Ctrl+;
-
To copy the data from the cell above:Â Ctrl+’
-
To create a line break within a cell:Â Alt+Enter
Video: Date and Time Shortcuts
Watch this 1-minute video to see the keyboard shortcuts for entering dates and times in a worksheet.
Video: Make a Quick List of Dates
Another quick way to enter dates is by dragging down with the active cell’s fill handle.
Watch this short video and see how to create a list of dates that are a week apart.
More Excel Data Entry Tips
For lots more Excel data entry tips, visit the following pages on my Contextures site:
___________
To copy the data from the cell above: Ctrl+’ in addition we can also use Ctrld
In Spanish language interface Ctrl+J is the equivalent of Ctrl+D, but Ctrl+´ has a little difference. Enters in edit mode just after copying the content of the cell above.