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:
- Select the area around which you want a border, then right click.
- 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.
- A dropdown menu will appear: at the bottom, click More Borders…
- In the pane that appears, you can select the style, thickness, color, etc, that you want. See next step for important info.
- 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.