Data Entry Techniques

Data Entry Techniques

Here is the guide that shows the easy ways that you can use to enter data into the worksheet.

·  To fill a range of cells with the same data

·  Highlight the cells you wish to fill.

·  Enter the information that you wish to fill the selected range with.

·  Press Ctrl+Shift+Enter and the range will be filled.

To fill a range of cells with the 'automatic' data

·  Highlight the cells you wish to fill.

·  Enter the data into the cells as follow: A1: 1; A2: 2

·  Use the mouse to drag from cell A1 to A2.

·  Place your mouse in the bottom right corner of the selected cells until you see the “+” sign appear as follow:

·  Click and drag the mouse down the cells as you wish. You will see the selected range will fill with continuous numbers 3, 4, 5, 6,…
Note: You also can replace the above A1 and A2 cells with days of week such as Monday, Tuesday,... and months like January, February,...