Excel2007 - draw a line

[zigmund]

In Excel 2002 I could draw a line between columns just by dragging it, and
when I reached the bottom of the window the drag would automatically start to
scroll down the rows, so to draw a line between columns D and E, rows 1
through 2500 was dead easy.
In Excel2007 the page no longer automatically scrolls, or rather the page
scrolls but the drag doesn't follow the scroll. So I have to manually scroll
the worksheet back, find the circle, and drag the line a screen at a time,
which takes ages if you have several lines 2500 rows deep.

I either need the drag to follow the scroll, or to be able to select the
start and end points.
Any thoughts why Excel2007 is different to Excel2002?
Or how to make them behave the same?

 

[Roger Govier]

Hi

If I drag down till I hit the bottom of the page, after a momentary pause
whilst holding the cursor in the bottom bar, the line continues on down the
sheet as far as I wish.

alternatively, you could select cells D12500>Home tab>Font
section>dropdown on borders>select Right Border