Click the plus and drag it down, filling the cells with a copy of the original formula. You’ll know you have hit it when the cursor changes to a plus sign. For best results, try one of the methods below.Īfter you are satisfied that it is correct, place your mouse cursor at the lower right-hand corner of the cell.
Not only is it mind-numbing, but it also leaves the opportunity for error if you don’t copy the formula down to exactly the correct cells. One of the more tedious tasks in Excel is to copy a formula down an entire column of a report.
