Borders around all cells in a range

Just select that range, then right-click and choose Format Cells, then choose the Border tab, and then you can click on the small icons to set Top, Middle and Bottom borders only. You can also choose different thicknesses of the lines.

Hope this helps.

Pete

Jon

You should use your macro recorder to find out how to do things like this.

Click on developer and then on record macro.

select an area,

right click,

select format cell

select your borders

Click on developer and then on stop recorder.

Please Login or Register  to view this content.

Originally Posted by Pete_UK

Just select that range, then right-click and choose Format Cells, then choose the Border tab, and then you can click on the small icons to set Top, Middle and Bottom borders only. You can also choose different thicknesses of the lines.

Hope this helps.

Pete

That's exactly what I was looking for, them "Middle" borders!

Thanks guys, really wanted to avoid using Macros for this kind of shite!

Originally Posted by mehmetcik

Jon

You should use your macro recorder to find out how to do things like this.

Click on developer and then on record macro.

select an area,

right click,

select format cell

select your borders

Click on developer and then on stop recorder.

Appreciate that, mehmetcik, was looking for something simpler though. Cheers!