Article sections

    Using Fill Handle to Copy Same Value in Multiple Cells in Excel

    Follow these simple steps to copy the same value to multiple cells using the Fill Handle:

    Step 1

    Highlight the cell with the value you would like to copy.

    Step 2

    You’ll notice the fill handle will appear in the bottom right corner of the cell. Simply drag it over the cells where you would like the value to appear.

    You’ll notice a dropdown which enables you to select the characteristics you want to copy.

     

    in Microsoft Excel
    Did this article answer your question?