Putting border around 5 cells and 5,000 rows ?

[tcurrier]

Hi,

I have a spreadsheet where I need to put a border around 5 cells across and 5,000 rows down.... The only way I can figure out how to do it is to highlight the 5 cells, and drag all the way down to the 5,000th row. Then click 'format cells', 'border', 'outline'...... I also have other groups of cells on the same spreadsheet that I need to do the same thing with.

Can anyone save me about 1/2 hour of work with an easy way to do this ?

Thanks !

 

[Norie]

What range do you want to do this formatting in?

Let's say it's A1:E5000.

In the name box, to the left of the formula bar, just enter A1:E5000.

That should select the required range which you should be able to format via the Format... menu.

 

[tcurrier]

I tried that, but it doesn't seem to work...

I put A1:G10 in the 'name' box.... then clicked 'Format', 'Cells'....
but the A1:G10 goes away as soon as I click the 'Format' button .....

 

[Norie]

Try pressing Enter after you've put the range in the Name Box.

 

[HalfAce]

Or since this sounds like something done regularly, you may be interested in a quick
little one liner in vba.

Assumes the ranges will stay the same, and you want just a standard black border.

Sub BorderMe()
Range("A1:E5000, G1:H10").BorderAround LineStyle:=xlContinuous
End Sub

 

[tcurrier]

Thanks to both of you !

Both of your suggestions worked ....