How to Add Borders in Excel to Organize Your Data Clearly

Written By Sophanith Dith
Last Updated June 01, 2026
Applies to Microsoft Excel 365 (Windows only)
Part of the Beginner Learning Path
Module 3 Formatting and Layout
Lesson 5 of 14

When you first enter data in Excel, everything can look like it is sitting inside boxes because of the light gray gridlines on the worksheet. But those gridlines are only visual guides. They are not the same as real borders, and they may not appear the way you expect when formatting or printing a worksheet.

Learning how to add borders in Excel helps you make important cells, headers, totals, and small tables easier to read. Borders can separate sections, outline a range, highlight totals, and make a beginner spreadsheet look more organized.

In this tutorial, you’ll learn what borders are, how to add them from the Home tab, how to choose common border options, how to remove them, and how to avoid common beginner mistakes.

Before we go step by step, here is the short answer.

Quick Answer:
To add borders in Excel, select the cell or range, go to the Home tab, click the arrow next to the Borders button in the Font group, and choose a border option such as All Borders, Outside Borders, or Thick Outside Borders. Excel applies the border to the cells you selected.

Quick Reference

Use this quick reference to understand the main steps before you follow the full tutorial. Borders are simple once you know where the button is and which option to choose.

• Select the cell or range you want to format.
• Go to Home → Font group → Borders arrow.
• Choose All Borders to add lines around each selected cell.
• Choose Outside Borders to outline only the outside edge of a range.
• Choose No Border to remove borders from selected cells.
• Use More Borders when you need more control over the line style, color, or border placement.

With the basics in mind, let’s look at what borders actually do in Excel and why they are different from the lines you already see on the worksheet.

What Are Borders in Excel?

Borders in Excel are formatting lines that you apply to cells. They can appear around one cell, around a range of cells, or between cells inside a selected range.

This matters because borders are intentional formatting. Unlike default gridlines, borders stay attached to the cells you format and can be customized with different positions, thicknesses, and colors.

For example, you might add borders around a small sales report so the header row, data area, and total row are easier to scan. A beginner worksheet often becomes much easier to understand when borders are used lightly and consistently.

A simple sales list with borders might look easier to scan like this:

Item	Quantity	Price
Notebook	3	$12
Pen	10	$5
Folder	2	$8

Without borders, this data may still be readable, but it can blend into the rest of the worksheet. With borders, the range looks more like a finished table.

Beginner Tip:
Use borders to organize data, not to decorate every cell. Too many borders can make a worksheet harder to read.

Once you know what borders are, the next step is learning where to find the Borders command in Excel.

Where to Find the Borders Button in Excel

The Borders button is located on the Home tab, inside the Font group. This is the same area where you find common formatting tools such as bold, font size, fill color, and font color.

For beginners, the important thing is to click the small arrow next to the Borders button. The button itself may repeat the last border style you used, but the arrow opens the full menu of border choices.

The icon usually looks like a small square with border lines, and the small arrow beside it opens the full list of border options.

To find the Borders menu:

1. Open your worksheet.
2. Select any cell.
3. Go to the Home tab.
4. Look in the Font group.
5. Click the small arrow next to the Borders button.

After you click the arrow, Excel shows several border options, including common choices such as Bottom Border, All Borders, Outside Borders, Thick Outside Borders, and No Border.

For Microsoft’s official instructions, you can also review their guide on how to apply or remove cell borders on a worksheet.

Beginner Warning:
Do not click randomly around the worksheet after selecting your cells. If you accidentally select a different cell before choosing the border, Excel will apply the border to the wrong place.

Now that you know where the menu is, let’s use it to apply borders to a real cell range.

How to Add Borders in Excel from the Home Tab

The easiest way to add borders is from the Home tab. This method is best for beginners because it uses the visible Ribbon and does not require keyboard shortcuts or advanced formatting windows.

You can use this method for a single cell, a row of headings, a column of labels, or a small table of data. The key is to select the correct cells before choosing the border style.

Step-by-Step: Add All Borders to a Range

This example shows how to add borders around every cell in a small range. It is useful when you want each cell in a table-like area to have visible lines.

1. Select the range you want to format, such as A1:C5.
2. Go to the Home tab.
3. In the Font group, click the arrow next to Borders.
4. Choose All Borders.
5. Look at the selected range to confirm that lines appear around each cell.

Excel adds borders around every cell in the selected range. This is one of the most common ways beginners learn how to add borders to cells in excel because it creates a clear table-like layout quickly.

Beginner Tip:
If your range includes headings, you can add All Borders first, then add a stronger border around the outside later.

Step-by-Step: Add an Outside Border Only

Sometimes you do not need lines between every cell. You may only want a border around the outside of a selected range.

1. Select the range you want to outline.
2. Go to Home → Font group.
3. Click the arrow next to Borders.
4. Choose Outside Borders.

This places a border around the outer edge of the selected range but does not add lines between the cells inside the range.

Use Outside Borders when you want to group information without making the worksheet look too busy. For example, you might outline a summary box, a total section, or a short input area.

Step-by-Step: Add a Thick Outside Border

A thick outside border makes a range stand out more strongly. This is helpful for totals, final results, or important summary areas.

1. Select the cell or range you want to emphasize.
2. Go to the Home tab.
3. Click the arrow next to Borders.
4. Choose Thick Outside Borders.

Excel applies a heavier line around the outside of the selected range. This can help readers quickly notice the most important part of a worksheet.

Beginner Warning:
Use thick borders sparingly. If everything has a thick border, nothing stands out.

Once you can add basic borders, it helps to understand which border option to choose for different situations.

Common Border Options and When to Use Them

Excel includes several border options because not every worksheet needs the same type of line. Choosing the right border style makes your spreadsheet cleaner and easier to read.

The table below explains common border options in beginner-friendly terms. Use it when you are deciding how to put borders in Excel based on the type of data you are formatting.

Border Option	What It Does	Best Used For
Bottom Border	Adds a line below the selected cell or range	Separating a heading from data
Top Border	Adds a line above the selected cell or range	Marking the start of a section
Left Border	Adds a line on the left side	Separating labels or categories
Right Border	Adds a line on the right side	Separating columns visually
All Borders	Adds lines around every selected cell	Small tables or practice data
Outside Borders	Adds a line only around the selected range	Grouping a section
Thick Outside Borders	Adds a heavier outside outline	Totals, summary boxes, key results
No Border	Removes borders from selected cells	Cleaning up formatting

For most beginner worksheets, All Borders, Outside Borders, and No Border are the options you will use most often.

A practical approach is to use All Borders for small data ranges and Thick Outside Borders only for important summary areas. This keeps your worksheet structured without making it crowded.

If you are also learning how to position content inside cells, review How to Align Text in Excel because alignment and borders often work together to improve readability.

After choosing a basic border option, you may want to adjust the line style or color for a clearer layout.

How to Make Borders in Excel with Different Styles

Basic borders are usually enough, but Excel also lets you use different line styles. For example, you can use a thicker line around a total row or a lighter line inside a data range.

This is useful when you want to guide the reader’s eye. A slightly stronger outside border can show where a report begins and ends, while thinner inside borders can keep the details organized.

Use Line Style from the Borders Menu

The Borders menu includes a Line Style option. This lets you choose a different type of border line before drawing or applying it.

1. Select the cells you want to format.
2. Go to the Home tab.
3. Click the arrow next to Borders.
4. Point to Line Style.
5. Choose the line style you want.
6. Apply the border option you need.

For beginners, it is best to start with simple line styles. A regular thin line is usually enough for most cell borders. Thick lines should be saved for totals, headings, or important sections.

Beginner Warning:
After choosing a line style or color, Excel may expect you to apply that border style. If the result is not what you wanted, press Esc or use Undo.

Use More Borders for Custom Borders

The More Borders option opens the Format Cells dialog box on the Border tab. This gives you more control over where the border appears.

1. Select the cell or range.
2. Go to Home → Font group.
3. Click the arrow next to Borders.
4. Choose More Borders.
5. Select a line style.
6. Choose where the border should appear, such as outline or inside.
7. Click OK.

This method is helpful when you want a specific combination, such as an outside border plus inside horizontal lines. It is more detailed than the basic menu, so beginners should use it only when the normal options do not give the result they need.

Beginner Tip:
If you are not sure what to choose, start with All Borders or Outside Borders. You can always remove the border and try again.

Once you know how to change line style, the next simple customization is border color.

How to Change Border Color in Excel

Border color can help certain parts of a worksheet stand out, but it should be used carefully. For beginner spreadsheets, dark gray or black borders are usually easiest to read.

Changing border color is most useful when you want to match a worksheet theme or separate different sections visually. However, too many colors can make the worksheet look less professional.

Change Border Color from the Borders Menu

Excel lets you choose a border color before applying the border. This means you choose the color first, then choose or draw the border.

1. Select the cell or range you want to format.
2. Go to the Home tab.
3. Click the arrow next to Borders.
4. Point to Line Color.
5. Choose the color you want.
6. Open the Borders menu again.
7. Choose the border option you want, such as Outside Borders or All Borders.

If the result does not look right, select the same range and choose another border color or remove the border completely.

Beginner Warning:
Avoid very light border colors if the worksheet may be printed. Light colors may be hard to see on paper or in a PDF.

Borders work well with other formatting tools, but they are not the same as worksheet gridlines. That difference is important for beginners.

Borders vs Gridlines in Excel

Gridlines are the light gray lines you see by default on a worksheet. They help you see the cell structure while working, but they are not the same as borders.

Borders are formatting that you apply to selected cells. They are better when you want certain lines to stay visible, print more reliably, or make a specific area stand out.

Feature	Gridlines	Borders
Appears by default	Yes	No
Applied to selected cells	No	Yes
Custom line style	No	Yes
Custom color	Limited for worksheet display	Yes
Useful for formatting reports	Not usually	Yes
Good for printed layouts	Less predictable	Better choice

A common beginner mistake is thinking the default worksheet lines are already borders. They are not. If you want clear lines around a report, list, or total area, use actual borders in Excel instead of relying only on gridlines.

This is especially important if you plan to share, export, or print the worksheet. For deeper print layout work, save that for a later printing lesson so this tutorial stays focused on cell formatting.

After learning the difference between borders and gridlines, you should also know how to remove borders when your formatting does not look right.

How to Remove Borders in Excel

Removing borders is just as important as adding them. Beginners often test several border options before finding the one that looks best, so it helps to know how to clean up formatting quickly.

The good news is that removing borders does not delete the data inside the cells. It only removes the border formatting from the selected cells.

Remove Borders with No Border

Use No Border when you want to clear border lines from selected cells.

1. Select the cell or range that has borders.
2. Go to the Home tab.
3. Click the arrow next to Borders.
4. Choose No Border.

Excel removes the borders from the selected range. The cell values, formulas, and other formatting may remain unless you remove those separately.

Remove Borders from the Correct Range

If only part of the border disappears, you may not have selected the full range. For example, if you originally added borders to A1:C5, select A1:C5 again before choosing No Border.

This is one of the most common beginner issues with borders. Excel only changes the cells you select, so the selection matters.

Beginner Tip:
If you are practicing, use a small sample range first. It is easier to see what changed and undo mistakes.

Now that you can add and remove borders, let’s look at common beginner problems and how to avoid them.

Common Beginner Mistakes with Borders

Borders are easy to use, but small selection mistakes can create confusing results. Knowing these common issues will help you fix problems faster.

Most border problems happen because the wrong cells were selected, gridlines were mistaken for borders, or too many border styles were used in the same area.

Mistake 1: Selecting Only One Cell by Accident

If you want borders around a full range, make sure the full range is selected before choosing a border option. If only one cell is selected, Excel applies the border only to that cell.

For example, if your data is in A1:D10, select A1:D10 before choosing All Borders.

Mistake 2: Using Too Many Borders

Adding borders to every part of a large worksheet can make it look crowded. Borders should help readers understand the data, not distract them from it.

A cleaner approach is to use borders around important sections, header rows, and totals.

Mistake 3: Confusing Borders with Gridlines

Gridlines are the default worksheet lines. Borders are formatting you apply yourself.

If you need visible lines around specific cells, add actual borders. Do not rely only on gridlines.

Mistake 4: Forgetting to Remove Old Borders

Sometimes a worksheet looks messy because old borders are still applied. Select the affected range and use No Border before applying a cleaner border style.

This gives you a fresh start and helps avoid overlapping or inconsistent lines.

Once you understand the common mistakes, it becomes easier to use borders in practical workbook situations.

Practical Examples of Using Borders in Excel

Borders are most useful when they make a worksheet easier to read. You do not need to use them everywhere.

The examples below show simple ways beginners can use borders in real workbooks without over-formatting the sheet.

Example 1: Add Borders to a Small List

Suppose you have a small list in A1:C5 with headings in row 1. You can select A1:C5 and choose All Borders.

This makes the list easier to scan because each item, quantity, and price is separated clearly.

Borders can make a normal range easier to read, but they are not the same as an Excel Table. If you want built-in table formatting, filter arrows, and structured table features, see our guide on how to create Excel tables.

If your list includes prices, quantities, or totals, you may also want to format the values correctly. See our guide on how to format numbers in Excel for the next step.

Example 2: Outline a Total Row

If your total is in C10, you might add a Top Border above the total row. This separates the total from the detail rows above it.

For a stronger result, you could select the full total row and use Thick Outside Borders.

Example 3: Create a Simple Input Box

If you want someone to enter a value in a specific cell, you can add an outside border around that cell.

For example, if B2 is where a user should enter a monthly budget, adding a border around B2 makes the input area easier to notice.

Example 4: Format a Simple Report Header

If your report title is in A1:D4, you can use a bottom border below the title or heading row. This separates the heading from the data below it.

If you also want to improve the spacing and position of the heading, review How to Align Text in Excel instead of trying to fix everything with borders alone.

If your report includes dates, you can also learn how to display them clearly in our guide on how to format dates in Excel.

Borders are a formatting tool, and like most formatting tools, they work best when combined with simple practice.

Quick Practice

Practice helps you understand borders faster than reading alone. Use a blank worksheet or a small sample list so you can test each border option without worrying about important data.

Try this quick exercise:

1. Enter Product in A1, Quantity in B1, and Price in C1.
2. Enter three rows of sample data under the headers.
3. Select the full range, such as A1:C4.
4. Go to Home → Borders → All Borders.
5. Select the header row.
6. Apply Bottom Border.
7. Select the full range again.
8. Apply Thick Outside Borders.
9. Select the same range and choose No Border to remove the borders.
10. Reapply only the borders you think look cleanest.

The goal is not to make the worksheet fancy. The goal is to understand how each border option changes the selected cells.

After practicing, review the main points so you know what to remember when working on your own spreadsheets.

Key Takeaways

Borders are one of the simplest ways to make a worksheet look more organized. They help separate data, highlight important areas, and make small reports easier to read.

Remember these key points:

• Borders are different from default worksheet gridlines.
• The Borders menu is on the Home tab in the Font group.
• All Borders adds lines around each selected cell.
• Outside Borders outlines only the edge of a selected range.
• Thick Outside Borders is useful for totals or important summary areas.
• No Border removes border formatting from selected cells.
• Simple borders usually look better than heavy or colorful borders everywhere.
• Select the correct cells before applying or removing borders.

With those basics covered, here are answers to common beginner questions about borders.

Frequently Asked Questions (FAQs)

Beginners often have similar questions when they first start using borders. These answers focus on the most common issues without going beyond the scope of this lesson.

What is the easiest way to learn how to add borders in Excel?

The easiest way is to select a small range, go to Home → Borders, and try All Borders, Outside Borders, and No Border. These three options teach you the most important border behavior quickly.

How do I put borders around a single cell in Excel?

Select the cell, go to the Home tab, click the arrow next to Borders, and choose Outside Borders. Excel adds a border around that one selected cell.

How do I add borders to multiple cells at once?

Select the full range first, then choose a border option from the Borders menu. For example, select A1:C5 and choose All Borders to add lines around each cell in that range.

Why do I already see lines in Excel before adding borders?

Those lines are gridlines. They help you see the worksheet structure, but they are not the same as borders. If you want visible formatting around selected cells, add actual borders.

How do I remove borders without deleting my data?

Select the cells with borders, go to Home → Borders, and choose No Border. This removes the border formatting but keeps the cell contents.

Should I use borders on every cell?

Usually, no. Use borders where they improve readability, such as around small tables, headings, totals, or input areas. Too many borders can make a worksheet look crowded.

Can I change the color of borders in Excel?

Yes. Open the Borders menu, choose Line Color, select a color, and then apply the border. For beginner worksheets, simple dark borders are usually the easiest to read.

Now let’s wrap up with how this skill fits into the broader beginner Excel learning path.

Conclusion

Learning how to add borders in excel is a simple but useful formatting skill. Borders help you separate sections, outline important ranges, highlight totals, and make your worksheets easier for other people to read.

Start with basic options like All Borders, Outside Borders, and No Border. Once you are comfortable, try line styles and border colors only when they make your worksheet clearer.

This lesson is part of the Beginner Learning Path, a structured series designed to help you learn Microsoft Excel step by step from the basics.

← Previous Lesson
How to Align Text in Excel to Make Spreadsheet Easy to Read

Next Lesson →
How to Merge and Center Cells (And When Not to Use It)

More Lessons in Module 3 – Formatting and Layout