How can I add border to a cell

[michelle_ho]

I want to add border at the bottom of a cell. How can i do so?

Thx

 

[Aaron Howe]

You can either right click on the cell and select "format
cell" or go to Format > Cells from the menu bar. In the
format screen you'll see a tab marked "Border", from there
you can select to border the inside/outside of the cell,
or select which 'wall' of the cell you want to border by
clicking on it. Select a border style from the right side
then click on the 'wall' to change the style.

Additionally, there is a Border button on the formatting
toolbar which can do the same thing.

HTH

 

[Guest]

Select the cell you want and press CTRL+1 you see the cell format window, select the borders tab, you choice to add borders to any side. There are border buttons available on the Formatting tool bar, but you may not have this showing

----- michelle_ho > wrote: ----

I want to add border at the bottom of a cell. How can i do so

Thx

 

[Nikos Yannacopoulos]

Michelle,

Try:

Selection.Borders(xlEdgeBottom).LineStyle = xlContinuous

HTH,
Nikos