Abstract
Transcript
In this video, we’ll look at shortcuts for entering data.
Before we start, I want to show you an option related to cursor movement in Excel.
On Windows, press Alt + F, then T for Options, and A for Advanced.
On a Mac, jot down command + comma to go to Preference, then click Edit.
I’ll leave this alone for now, but I want to check that you know it’s there.
However, it’s possible for you to override this behavior with specific shortcuts.
Shift + Enter will move the cursor up.
To enter a value and stay in the same cell, you might use Control + Enter.
Just make a selection that includes multiple cells, jot down a value, and press control + enter.
There are two more very handy shortcuts for filling, or copying, data from other cells.
Control + D, will copy data from the cell above.
it’s possible for you to also work with more than one column.
Finally, a few special-purpose shortcuts for entering data.
To insert the current date, use control + semicolon.
To insert the current time, use control + shift + colon.
it’s possible for you to use these shortcuts together to enter the current date and time.
Just add a space between them.
