select multiple rows and EdgeBottom of each

chookers · May 22nd, 2002, 10:08 PM

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 · May 22nd, 2002, 11:22 PM

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)

May 22nd, 2002, 11:22 PM	#2
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	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) __________________ Regards, Juan Pablo González http://www.juanpg.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 22nd, 2002, 10:08 PM	#1
chookers Board Regular Join Date: Mar 2002 Posts: 115	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