How to Add Box Around Text in Excel

Ever found yourself wanting to highlight a specific piece of information in Excel, but the standard text formatting options just don't cut it? There's a simple way to add a box around text in Excel, making your data stand out and easier to understand. Let's dive into a step-by-step guide to help you achieve this.

How to wrap text in Excel automatically and manually
How to wrap text in Excel automatically and manually

Before we begin, ensure you're using one of the latest Excel versions. Our guide will work with Excel 2016, 2019, and Office 365, but not with older versions. Now, let's get started!

How to Build a Search Bar in Excel | Search Box Template with
How to Build a Search Bar in Excel | Search Box Template with

Adding a Border to a Single Cell

If you want to add a box around a single cell, using the 'Border' option is the quickest way.

How to use VBA Message Box in Excel
How to use VBA Message Box in Excel

Here's how you can do it:

Step 1: Select the Cell

Excel Ribbon - Text
Excel Ribbon - Text

First, click on the cell you want to surround with a box. A single cell should be selected, and it should be outlined in white.

Step 2: Apply the Border

Next, go to the 'Home' tab in the ribbon. Click on 'Border' in the 'Styles' group. Here, you'll see various border styles. For a simple box, select 'All Borders'. You'll notice the cell changes to reflect your chosen border style.

Insert a Checkbox in a Cell in Excel
Insert a Checkbox in a Cell in Excel

Adding a Border to a Range of Cells

But what if you want to add a box around a range of cells, not just one? Here's how to do that:

Step 1: Select the Range of Cells

How to Wrap Text in Excel
How to Wrap Text in Excel

Click on the first cell in the range you want to box in. Then, drag your mouse to select as many cells as you need. You should see a box around the selected range, but it's not the border we want – yet.

Step 2: Apply the Border

Insert A Check Box In Microsoft Word 2010
Insert A Check Box In Microsoft Word 2010
Publisher 2010 Tutorial Inserting Text Boxes Microsoft Training Lesson 3.1
Publisher 2010 Tutorial Inserting Text Boxes Microsoft Training Lesson 3.1
Get Textbox Value in VBA
Get Textbox Value in VBA
How to Add Check Boxes In MS Excel Sheet (Easy)
How to Add Check Boxes In MS Excel Sheet (Easy)
How to Use the Name Box in Excel
How to Use the Name Box in Excel
MsgBox in Excel VBA
MsgBox in Excel VBA
How to Insert a Checkbox in Excel (In 5 Easy Steps)
How to Insert a Checkbox in Excel (In 5 Easy Steps)
Excel Tips
Excel Tips
How to extract text between commas/brackets/parentheses in Excel?
How to extract text between commas/brackets/parentheses in Excel?

Follow the same steps as before (go to 'Home', click 'Border', and choose 'All Borders'). This time, though, you'll see the border applied to the entire range of cells.

Adding a Custom Border

For more advanced formatting, you can also apply custom borders to your cells. This can help you create unique, attention-grabbing visuals for your data.

Step 1: Select the Cells

First, select the cell or range of cells you want to apply the custom border to.

Step 2: Apply the Custom Border

Instead of clicking on 'Border', click on 'Border' again (yes, twice). This will open a more detailed Border tool. Here, you can choose which sides of the cell(s) you want to add borders to, along with the style and color. Once you're happy with your custom border, click 'OK'.

And there you have it! You now know how to add a box around text in Excel. This simple trick can make your data stand out and be easier to read. Happy formatting!

Related Articles

How Do I Upload Photos From Google Drive To Canva How To Upload Images From Pinterest To Canva How To Add Color To Text Boxes In Canva How Do I Upload Multiple Photos To Canva How To Make An Image A Circle Shape In Canva How To Change The Fill Color Of A Text Box In Canva How To Add A Box Around A Text Box In Canva How To Fill Text Box In Canva With Color How To Add A Decorative Border To A Text Box In Word How To Upload Pictures From Pinterest To Canva