Spreadsheets: How to border a range of cells in Excel

The tutor tells how to set a border around a selected area in Excel.

Here’s how:

  1. Select the area around which you want a border, then right click.
  2. You’ll see a toolbar and a menu. On the toolbar, find the icon that’s a square divided in four. Click the downward arrow beside it.
  3. A dropdown menu will appear: at the bottom, click More Borders…
  4. In the pane that appears, you can select the style, thickness, color, etc, that you want. See next step for important info.
  5. In my experience, the order in which you set the options matters: For best results, select the style, then the color, then the outline, then OK. Otherwise, the border may not show the color, etc, that you desire.

HTH:)

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

Leave a Reply