How to Entry Data in Excel?

There are several ways to enter data in MS Excel to be faster. Such as entering the same data or sequentially in several rows or columns. By knowing how to enter data quickly, especially for data that is patterned, we will be able to save more time.
 
Excel Data Entry Keyboard Shortcuts

Use Shortcut Keys

• Enter the current Date: Ctrl + ;

• Enter the current Time: Ctrl + Shift + ;

• Copy Value from cell above: Ctrl + Shift + '

• Copy Formula (exact) from cell above: Ctrl + '

• Copy Formula (relational reference) from cell above: Ctrl + D

Enter Data in Multiple Cells -- Ctrl + Enter

1. Select all the cells in which you want to enter the same value or formula

2. Type the value or formula in the active cell

3. Hold the Ctrl key and press Enter

Copy Data to Adjacent Cells

1. Select the range, starting with the cell that contains the data to be copied

2. Use a shortcut key to fill right or down:

o Fill Right -- Ctrl + R

o Fill Down -- Ctrl + D

Excel Data Entry Mouse Shortcuts

Copy Data to Adjacent Cells

1. Select the cell that contains the data to be copied

2. Point to the Fill Handle -- the black square at the lower right of the selection

3. When the pointer changes to a black plus sign, press the Left mouse button, and drag left, right, up or down, across one or more cells.

4. When finished, release the mouse button.

Copy to Adjacent Cells -- with options

1. Select the cell that contains the data to be copied

2. Point to the Fill Handle -- the black square at the lower right of the selection

3. When the pointer changes to a black plus sign, press the Right mouse button, and drag left, right, up or down, across one or more cells.

4. When finished, release the mouse button.

5. Select one of the options from the shortcut menu