select multiple rows and EdgeBottom of each

[chookers]

Can that be done? If I have 20 rows, and I want to have a line at the bottom of EACH row, what do I do? Do I have to manually select each row? If I select all 20, of course it only edges the bottom one of the selection.

Thanks

 

[Juan Pablo González]

In VBA:

Selection.Borders(xlInsideHorizontal).LineStyle=xlContinuous

In Excel

Select all 20 rows, go to Format, Cells, Borders, and click on the horizontal line that's in the middle... that's it ! (Oh, make sure that you also check the bottom one)