Use Borders through 3 how-to topics, including applying preset borders, customizing border styles, and removing borders. Choose a topic from the index and follow the entry path and steps.
How-to Index
| No. | Topic | Membership |
|---|---|---|
| 1 | 1. Apply preset borders quickly | Free |
| 2 | 2. Customize border styles | Free |
| 3 | 3. Remove borders | Free |
How-to Guide
1. Apply preset borders quickly
Entry path: Home → Borders
- Select the cell range where you want to add borders.
- Click the Borders drop-down arrow on the Home tab.
- Choose a preset such as All Borders, Outside Borders, or Inside Borders.
- If needed, review additional line color or line style options.
Success Criteria
- The selected range shows the border effect you chose.
- You can continue editing, formatting, or saving the file.
Tips While Using
- If you do not select a target range first, the border may not be applied where you expect.
- Protected cells or sheets may prevent format changes.
2. Customize border styles
Entry path: Right-click → Format Cells → Borders
- Select the target cell range and right-click it.
- Choose Format Cells to open the side panel.
- Switch to the Cell tab and choose the line style, color, and weight in the line area.
- Choose a preset layout or click specific sides in the preview diagram.
- Click OK to apply the settings.
Success Criteria
- The target range updates to the border style you set.
- You can continue refining other sides or copy the format to another range.
Tips While Using
- If you choose a line style but do not click a border side or layout, the change may not appear.
- Very thin lines may look different at different zoom levels.
3. Remove borders
Entry path: Home → Borders
- Select the cell range where you want to clear borders.
- Open the Borders drop-down menu on the Home tab.
- Choose No Border to remove all borders.
- If needed, choose a side-specific no-border option to clear only one side.
Success Criteria
- The selected border lines are removed from the target range.
- You can apply a different border style or continue editing content.
Tips While Using
- Gridlines are not the same as borders, so you may still see worksheet gridlines after removing borders.
- Only actual borders print; gridlines do not print by default.