Spreadsheets: How to border a selection in LibreOffice Calc

The tutor explains how to set a border around a range of cells in LibreOffice Calc.

Here’s what to do:

  1. Select the area around which you want a border.
  2. Find the icon that’s a square divided in four; it’s perhaps four in from the right. If you mouse over it, you’ll see Borders, add lines
  3. Click that icon, then select the style of border you want.

You’ll see a thin, black border around your selection. To customize that border, do the following:

  1. Make sure the range is still selected (or select it again).
  2. At the top of the screen, click Format, then Cells…
  3. Select the Borders tab. Therein, you’ll see where you can select the style, width, and color of the border.
  4. I find a border really doesn’t become obvious until it’s 1.25pt or more.
  5. Click OK to apply your choices.

HTH:)

Jack of Oracle Tutoring by Jack and Diane, Campbell River, BC.

Leave a Reply