Using the fill handle (dragging the bottom right corner), I'd like to copy a cell down a column, but ignore the borders.
Simply dragging the fill handle will "Fill" the series, eg: count up (see Column A below).
Holding Ctrl and then dragging the fill handle will keep the numerical values correct, but the horizontal border is then copied for each successive cell (see Column B below).
Dragging the fill handle with the right mouse button (or clicking the small pop-up after dragging with the left mouse button) and selecting "Fill without formatting") fixes the border issue, but counts up (see Column C below).
My desired result is shown in Column D below.
Edit: Here is what is looks like immediately after I drag the fill handle:
You can see that the borders are copied.
It appears that the reason for this behavior is that the horizontal border is on the top of the cell I'm trying to copy down, not on the bottom of the cell above.
Is there a simple method for using the fill handle that doesn't involve manually removing borders each time I copy something?