This technique enables excel to copy text/data into multiple cells.

• Highlight the cell by clicking the cell you want to copy.
• Left click and drag the fill handle as shown in the video over the cells you want to fill.
• Release the mouse button.

discuss this topic to forum