Catalog

Excel Border Mastery: The Complete Guide to Adding, Copying, Customizing, and Removing Borders

January 15, 2024 2.5K views

In the realm of Excel, organizing data is paramount. Without well-defined borders, data sets can become an unmanageable mess. Discover how to select the perfect border style to categorize your data effectively and enable seamless analysis.

What are the borders in Excel

the borders in Excel


Borders are lines that can be added around cells or ranges of cells in Excel. They can be used to highlight important data, separate different sections of a worksheet, or simply make a spreadsheet look more visually appealing.

Types of borders

There are several different types of borders available in Excel. These include:

  • Solid: A solid line border.

  • Dashed: A dashed line border.

  • Dotted: A dotted line border.

  • Medium: A thicker line border.

  • Thick: A very thick line border.

  • Double: A double line border.

How to Add A Border in Excel

Here are the steps on how to add a border in Excel, with pictures and text:

Step 1. Open the Excel spreadsheet that contains the cells you want to add borders to.

Step 2. Select the cells by clicking and dragging the mouse over them.

Select the cells



Step 3. On the Home tab, in the Font group, click the Borders button.

the Home tab



Step 4. A menu will appear with different border options.

border options.


To add a solid border:

  • Click the Solid option.

  • The border will be added to the selected cells.

To add a dashed border:

  • Click the Dashed option.

  • The dashed border will be added to the selected cells.

To add a dotted border:

  • Click the Dotted option.

  • The dotted border will be added to the selected cells.

To add a custom border:

  • Click the More Borders option.

  • The Format Cells dialog box will appear.

  • In the Border tab, select the type of border you want to add from the Style list.

  • Select the color and thickness of the border from the Color and Weight lists.

  • Click OK.

The border will be added to the selected cells.

Here are some additional tips for adding borders in Excel:

  • You can also add borders to individual cells, rows, or columns.

  • To add a border to an individual cell, select the cell and then click the Borders button.

  • To add a border to a row or column, select the row or column and then click the Borders button.

  • You can also use the Format Cells dialog box to add borders to individual cells, rows, or columns.

How to Copy And Paste Borders

Here are the steps on how to copy and paste borders in Excel, with images:

Step 1: Select the cells that have the borders you want to copy.

Select the cells



Step 2: Click on the Home tab.

Step 3: In the Clipboard group, click on the Format Painter icon.

the Format Painter icon.



Step 4: Click on the cells where you want to paste the borders.

Click on the cells



The borders from the selected cells will be copied and pasted to the new cells.

Here are some additional tips for copying and pasting borders in Excel:

  • You can also use the keyboard shortcut Ctrl+C to copy the borders and Ctrl+V to paste them.

  • You can only copy and paste borders between cells that have the same formatting.

  • If you want to copy and paste borders between cells with different formatting, you can use the Format Painter Options button.

  • The Format Painter Options button is located in the lower-right corner of the Format Painter icon.

How to Customize Border 

To customize your own border in Excel, you can use the following steps:

Step 1. Select the cells that you want to add borders to.

Select the cells



Step 2. On the Home tab, in the Font group, click the Borders button.

the Font group



Step 3. A menu will appear with different border options.

different border options.


To customize the border style:

  • Click the More Borders option.

  • The Format Cells dialog box will appear.

  • In the Border tab, select the style of the border you want from the Style list.

To customize the border width:

  • In the Border tab, select the width of the border you want from the Weight list.

To customize the border color:

  • In the Border tab, select the color of the border you want from the Color list.

To customize the border on all sides:

  • Click the All Borders option.

To customize the border on specific sides:

  • Click the checkbox next to the side of the border you want to customize.

  • Select the style, width, and color of the border.

To preview the border:

  • Click the Preview button.

To apply the border:

  • Click the OK button.

Here are some additional tips for customizing borders in Excel:

  • You can also use the Format Painter tool to copy and paste borders from one cell to another.

  • You can use the Conditional formatting feature to automatically apply borders to cells that meet certain criteria.

How to Remove Borders

Here are the steps on how to remove borders in Excel, with pictures and descriptions:

Step 1. Select the cells that have the borders you want to remove.

Select the cells



Step 2. On the Home tab, in the Font group, click the Borders button.

the Home tab



Step 3. A menu will appear with different border options.

Delete Border



To remove all borders:

  • Click the No Border option.

To remove borders on specific sides:

  • Click the checkbox next to the side of the border you want to remove.

To preview the border removal:

  • Click the Preview button.

To apply the border removal:

  • Click the OK button.

Here are some additional tips for removing borders in Excel:

  • You can also use the Format Painter tool to copy and paste border removal from one cell to another.

  • You can use the Conditional formatting feature to automatically remove borders from cells that meet certain criteria.

Best Free Alternative to Microsoft Excel - WPS Office

WPS Office logo



The following methods are applicable to both Microsoft Excel and WPS Office. However, we recommend you download and use WPS Office for several reasons:

  • Free download: WPS Office is a freemium office suite that offers a fully-functional spreadsheet application called WPS Spreadsheets. It is a great alternative to Microsoft Excel and can be used on Windows, macOS, Linux, Android, and iOS devices.

  • Compatibility: WPS Spreadsheets is compatible with Microsoft Excel files. This means that you can easily open, edit, and save Excel files in WPS Spreadsheets.

  • Features: WPS Spreadsheets has a wide range of features that are comparable to Microsoft Excel. These features include formulas, functions, charts, macros, and more.

Here are some additional reasons to choose WPS Office:

  • It is easy to use and has a user-friendly interface.

  • It is regularly updated with new features and bug fixes.

  • It has a large community of users who can provide support and help.

If you are looking for a free and reliable alternative to Microsoft Excel, WPS Office is a great option. You can download it from the WPS Office website: https://www.wps.com/

Trustpilotstars4.8
WPS Office- Free All-in-One Office Suite
  • Use Word, Excel, and PPT for FREE, No Ads.

  • Edit PDF files with the powerful PDF toolkit.

  • Microsoft-like interface. Easy to learn. 100% Compatibility.

  • Boost your productivity with WPS's abundant free Word, Excel, PPT, and CV templates.

5,820,008 User
avator
Algirdas Jasaitis
logo

Frequently Asked Questions (FAQs)

How to Copy And Paste Borders

Step 1. Select Source Cell: Choose the cell with the desired border style.

Step 2. Activate Format Painter: Click the paintbrush icon in the "Home" tab.

home tab


Step 3. Apply Border: Click the cell(s) where you want the same border.

Step 4. Done: Press "Esc" or click Format Painter to finish.

Effortlessly maintain a consistent and neat look for your spreadsheet elements using this simple copy-paste technique.

How to Customize Border 

Customizing Borders in Excel: Quick Steps

Step 1. Select Cells: Pick the cells.

Step 2. Access Borders: Go to "Home" tab, find "Borders."

Step 3. Choose Style: Click sides to add borders.

Step 4. Advanced Options: "More Borders" for detailed customization.

more border



Step 5. Preview and Apply: Review changes, hit "OK."

Elevate your spreadsheet's look and clarity by adding personalized borders effortlessly.

How to Remove Borders

Removing Borders in Excel: Quick and Easy

Step 1. Select Cells: Pick the cells with borders to remove.

Step 2. Access Borders: Go to "Home" tab, find "Borders."

Step 3. No Border: Click "No Border" to remove all borders.

No Border



Step 4. Borders Dialog: Choose "More Borders" to customize removal.

Step 5. Apply Changes: Click "OK" to remove selected borders.

Simplify your spreadsheet by swiftly removing unwanted borders.

Summary

This guide equips you with the skills to create, copy, customize, and remove borders in Excel, enhancing data clarity and presentation. While applicable to both Excel and WPS Office, the latter offers a free, versatile solution for efficient work. Seamlessly organize your spreadsheets with borders and explore WPS Office's features to elevate your productivity and creativity.


15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.