When making entries in Excel there are a few keyboard shortcuts worth knowing. These can save you time and effort.
It is very common to enter today’s date. There is a shortcut to do it. Ctrl + ; will enter the date. This is not a formula, it is a data entry so it won’t change
If you do need a formula that updates, use the =TODAY() function.
Did you know you don’t have to enter the year if you want to enter a date in the current year?
Try this entering 15/1 and press Enter – see image below.
Copy from above
If you are entering data in a table, you often want to copy the entry from the above cell. To do that press Ctrl + ‘ and that will duplicate the entry from the above cell. Note sometimes with dates it may not match the format.
Formula copy – the previous technique is a way to copy the formula from the above cell without any references changing – see image below.
Copy from the left
If you need the entry from the cell on the left, you can press Ctrl + Shift + > note this does perform a copy and relative formulas references do move.
If you are entering data on a row in a formatted table pressing the Tab key will move the active cell to the right. When you reach the last column pressing Tab then moves you to the first column in a new row and the table expands.
To move to the end of the entries in the various direction hold the Ctrl key down and press one of the arrow keys.
Entering data but not moving the cell
If you want to make an entry but not move the active cell. In other words, stay where you, then press
Ctrl + Enter instead of Enter.
These are a few of the useful keyboard shortcuts that assist in data entry in Excel.