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.

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!

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.

Here's how you can do it:
Step 1: Select the Cell

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.

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

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









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!