What is this? From this page you can use the Social Web links to save Putting Borders around bunch of non-adjacent Cells at once to a social bookmarking site, or the E-mail form to send a link via e-mail.

Social Web

E-mail

E-mail It
December 26, 2007

Putting Borders around bunch of non-adjacent Cells at once

Posted in: General

This article talks about formatting and borders.

 

If borders are needed around some specific cells, then here is the way to do it:

1)Hold down the “Ctrl” key.
2)Select the range of cells using mouse.
3)Then choose “Format” -> “Cells” -> “Border”.

For example in the sheet below,borders are only needed around cell range B3:B6,B11:B14 and B27:B30.So this can be done by holding down the control key and then selecting these cells using mouse.

borders1.JPG

For non-adjacent cell selection,instead of holding down “Ctrl” key, just press shift + F8 once and then make the desired selection using mouse.


Return to: Putting Borders around bunch of non-adjacent Cells at once