How to Add Borders in an Excel Sheet? 8 Easy Steps

In this tutorial, I will explore the step-by-step process on how to add borders in an Excel sheet. It enables you to create professional and good-looking spreadsheets in Excel. It is personalized to your unique needs and improves the overall readability and report of your data. Borders not only define cells, making your data visually organized, but they can also emphasize specific information or create distinct sections within your worksheet. Excel provides different border options, allowing you to customize the style, color, and thickness of borders according to your cell or work area.

How to Add Borders in an Excel Sheet?

Below are the steps to learn about how to put borders in an Excel sheet. It defines the work area and enhances the visual presentation and organization of your spreadsheet data.

1. Open Your Excel Workbook:
   Start Microsoft Excel and open the workbook that you want to add borders to the work area sheet.
2. Select the Cells or Work Area:
   Click and drag your mouse to select the cells or work area to which you want to apply borders. You can select a single cell, a range of cells, entire rows, entire columns, or any combination depending on your requirement.
3. Go to the Home Tab:
   Navigate to the “Home” tab located on the Excel ribbon. This tab provides access to various formatting options.
4. Find the Font Group:
   In the “Home” tab, find the “Font” group. This group contains buttons and options related to text formatting. See the above screenshot.
5. Click the Border Button:
   Within the Font group, at the right corner, there is a button that looks like a down arrow. See the screenshot. Click on it, and a Format Cells dialog box will open. Now choose a border.
6. Choose a Border Style:
   In the dropdown menu, you will see various border styles, such as All Borders, Outline, Inside, or specific border options like Top Border, Bottom Border, Left Border, and Right Border. Select the desired border style by clicking on it.
7. Customize Border Color and Thickness:
   If you want to customize the border color or thickness, you can do so by choosing “More Borders” or “Borders and Shading” from the dropdown menu. In the dialog box that appears, you can select different border styles, colors, and thicknesses according to your preference.
8. Click the OK Button:
   After customizing the border settings, click the “OK” button in the dialog box. The selected cells or ranges will now have the borders applied according to your chosen style and preferences.
9. View the Borders:
   Now the borders will be visible around the selected cells or ranges. It helps you to organize your data visually.
10. Save Your Workbook:
    After putting borders in an Excel sheet, be sure to save your workbook to preserve your formatting changes.

Congratulations!
Now you learned adding borders in an Excel sheet. So, by following the above steps, you may try to add borders to your new Excel sheet.