Last Updated on November 1, 2023 by Jake Sheridan
In this tutorial, you will learn how to outline cells in Google Sheets.
How To Outline Cells In Google Sheets
Applying a cell border is an easy way to outline a group of cells in Google Sheets. This is especially useful when you want to group related information together, and make it easier to read.
In this guide, we will show you how to outline cells in Google Sheets with a cell border. We’ll explain how to add a border to just one cell, or to a group of cells.
We’ll also go over how to customize your borders to make them look exactly the way you want.
How To Add a Cell Border in Google Sheets
Here’s how to add a cell border in Google Sheets.
Select the cell or cell range you want to add a border to.
In this example, we’ll place a border in the cell range B2:B3.
Click on the Borders icon which can be found in the toolbar.
Next, click your desired border option to apply on the selected sheet.
In this example, we’ll use the ‘All borders’ option.
The selected range should now have the right cell formatting to show an outline.
You can modify the border color of the selected range by clicking on the color icon seen below.
You may also modify the border weight and border style of the outline.
These custom border options can allow users to highlight certain cells, rows, and columns in a spreadsheet.
This guide should be everything you need to outline cells in Google Sheets.
You may make a copy of this example spreadsheet to test it out on your own.
More ways to design in Google Sheets:
- Add Borders
- Add A Line
- Add A Tab
- Change Default Font
- Change Cell Color
- Alternate Colors
- Color Code
- Make Cells Bigger
- Make A Button
- Get Rid Of Lines
- Remove Borders
- Bold Lines
- Make Paragraph
- Set Margins
- Make A Header
- Make Categories
- Make A Template
- Shift Cells Down
- How Many Sheets Can You Have?
- Create A Header
- Content Calendar
- Make All Cells The Same Size
- Remove Cell Lines
- X Out A Cell
- Group Cells
- Format Cells
- Add Serial Number