WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android

banner

How to Refresh the Pivot Table in WPS Spreadsheet

October 19, 2021
7.3K Views

“data information report statistics strategy”

In the world of document formatting, borders play a crucial role in enhancing the richness and diversity of our content. They allow us to meet the unique needs of different customer groups and provide an effective way to emphasize and highlight essential data. However, many individuals struggle to achieve the desired effect or are unaware of the hidden functions that can elevate their files to the next level. If you find yourself wondering how to add borders in Excel, fear not. This article aims to provide a detailed, step-by-step guide that will empower you to transform your spreadsheets into professional, attractive, and organized masterpieces. So, let's dive in and discover the art of adding borders together!

In the realm of Excel software, I will be demonstrating the process of adding borders. However, if you find it challenging to locate the desired border options within Excel or seek a more efficient office experience, an alternative worth exploring is WPS, a user-friendly office software. WPS offers convenient features and can provide an enhanced border-adding experience. For further guidance, you can refer to the following resource: Quick Tip: How to Add Borders in Excel - Quick Tutorials. Let's embark on this journey of border customization in Excel and discover the possibilities together!

How to add borders in excel in simple steps?

Adding borders in Excel can be done easily using the built-in options, although they may not always meet specific needs. Follow these simple steps to add borders to your cells:

1. Select the Cells: Choose a cell or a range of cells to which you want to add borders.

“excel data report screenshot”

2. Access the Borders Options: On the Home tab, located in the Font group, click the down arrow next to the Borders button.

3. Choose a Border Style: A list of popular border styles will appear. Select the desired border style by clicking on it. (The border style you choose will be automatically added to the selected cells).

“excel data report border screenshot”

If you are using different versions like Excel  2016 or on a Mac, Ipad and wondering how to add borders, you can also follow these steps with slight changes.

By following these straightforward steps, you can easily add borders to your Excel cells, giving your spreadsheets a polished and professional appearance.

How to Create a Custom Border Style in Excel?

Excel provides the flexibility to create custom border styles, allowing you to add unique and personalized borders to your cells. Follow these steps to create your own custom border style:

1. Access Cell Styles: On the Home tab, locate the Styles group and click on the Cell Styles button. If you don't see the button, click the More button in the lower right corner of the Styles box to reveal additional options.

“excel data border report screenshot”

2. Open New Cell Style: Scroll to the bottom of the dropdown menu and click on "New Cell Style."

“excel data cell style screenshot”

3. Name Your Style: In the Style Name box, enter a name for your new cell style, and then click on the "Format" button. This will open the Format Cells dialog box, where you can customize various formatting options.

“excel data cell name screenshot”

4. Customize Border Settings: In the Format Cells dialog box, switch to the Border tab. Here, you can select the desired line style, a thin borders you want to apply, and even choose the line color. Take your time to configure the settings according to your preferences. Once you are satisfied, click "OK" to apply the changes.

5. Finalize and Apply: Back in the Style dialog box, review the formatting options. If there are any additional formatting aspects you don't want to include in the new style, clear the respective checkboxes. Finally, click "OK" to create and apply your custom border style to the selected merge cells.

By following these steps, you can create your own custom border styles in Excel, allowing you to add a touch of uniqueness and personalization to your spreadsheets. With this newfound ability, you can further enhance the visual appeal and organization of your data.

How to add custom borders in excel?

If you have created a custom border style in Excel and want to apply it to your desired cells, follow these simple steps:

1. Select the Cells: Begin by selecting the cells you want to format. Then, navigate to the Home tab and locate the Border group. In this group, click on the new custom style. Sometimes, the style may appear in the upper left corner of the Styles box. If you don't see your custom style there, click on "More" to explore additional options. Look for your new style under the "Custom" section and click on it.

“excel data select cells screenshot”

2. Apply the Custom Style: After selecting your custom style, click "OK." The custom border style will be applied to the selected cells, giving them a distinct and personalized appearance.

“excel data options screenshot”

The process of adding custom borders in Excel is simple and allows you to highlight different sections of your worksheet according to your preferences. By using custom borders, you can create visually appealing and organized spreadsheets that effectively present your data.

Have you successfully learned how to add borders in Excel? With Excel's versatile features, you can create more attractive and well-structured worksheets. If you're interested in discovering new Excel features and enhancing your skills, you can also explore the resources provided by WPS Academy.

By mastering the art of adding borders, you'll be able to elevate the visual impact of your Excel worksheets and impress others with your well-designed and professional-looking data presentations.

Best Alternative-WPS

“WPS all apps screenshot ”

In addition, I would like to introduce you to WPS Office, a more convenient and efficient office software that can greatly enhance your border-adding capabilities and overall office productivity.

To add borders in WPS Office, simply follow these step-by-step instructions:

  1. Launch WPS Office: Open the WPS Office program on your computer and open the document in which you wish to add a border.

  2. Select the Desired Portion: Choose the portion of the document where you want to apply the border. This can be the entire document or a specific section.

  3. Access the "Home" Tab: Navigate to the "Home" tab, which can be found in the menu bar at the top of the screen.

  4. Locate the "Borders" Section: In the "Home" tab, locate the "Borders" section. It is typically located within the "Paragraph" group, although the exact placement may vary depending on your version of WPS Office.

  5. Click on the "Borders" Button: Click on the "Borders" button, and a drop-down menu will appear, presenting you with various border options.

  6. Choose Your Border Style: Select the border style that best suits your preferences from the available options. You can choose from solid lines, dotted lines, double lines, or even customize your own unique styles.

  7. Customize the Border Appearance: After selecting the border style, you can further customize its appearance. Adjust options such as line thickness, color, and border placement (top, bottom, left, right) to achieve your desired effect.

  8. Apply the Border: Once you have finalized the border settings, the selected portion of your document will now display the applied border, enhancing its visual appeal and organization.

Please note that if you wish to remove the border at a later time, simply select the portion with the border and click on the "Borders" button again. From the drop-down menu, choose the option to remove the border or select the "No Border" option.

By following these simple steps, you can effortlessly add borders to your documents using WPS Office, enjoying enhanced efficiency and a seamless office experience.

FAQs

1. How do I change the color of a border in Excel?

To change the color of a border in Excel, follow these steps:

  • Select the cells or range to which you have applied the border.

  • On the Home tab, locate the Font group and click on the Borders button.

  • In the Borders dropdown menu, click on "More Borders" at the bottom.

  • In the Format Cells dialog box, go to the Border tab.

  • Select the desired line style under "Style" and then choose the desired color from the "Color" dropdown.

  • Click OK to apply the new color to the border.

2. Can I use borders to create custom cell styles in Excel?

Yes, you can create custom cell styles using borders in Excel. Here's how:

  • Select the cell or range of cells you want to format.

  • On the Home tab, go to the Cell Styles group and click on the "More" button at the bottom-right corner.

  • In the Style dialog box, click on "New Cell Style."

  • In the Style Name box, type a name for your new cell style.

  • Click on the "Format" button and go to the Border tab in the Format Cells dialog box.

  • Choose the desired line style and border options.

  • Click OK to save the custom cell style.

3. Can I add borders to a pivot table in Excel?

Yes, you can add borders to a pivot table in Excel. Follow these steps:

  • Select the pivot table cells or range where you want to add borders.

  • On the Home tab, in the Font group, click on the Borders button.

  • Choose the desired border style from the Borders dropdown menu.

  • The selected border style will be applied to the pivot table cells, helping to improve the visual presentation and organization of the data.

By using these border customization options in Excel, you can enhance the appearance and readability of your worksheets, including pivot tables

Final Thought on Ways to Add Borders in Excel

In conclusion, adding borders to your Excel spreadsheets is a simple yet effective way to enhance the visual appeal and organization of your data. By following the three easy methods discussed in this article, you can quickly and efficiently add borders to your cells, ranges, and pivot tables.

The first method demonstrated how to use the pre-defined borders included in Excel, offering a convenient solution for most users. However, for those who require more specific border styles or a seamless office experience, we introduced an excellent alternative - WPS Office. With its user-friendly interface and advanced border customization options, WPS Office provides a convenient and efficient solution for adding borders in Excel. Additionally, WPS Templates offer a wide range of pre-designed spreadsheet templates with various border styles, helping you save time and achieve professional-looking results.

By incorporating borders into your Excel worksheets, you can emphasize important data, improve readability, and create visually appealing documents. Whether you choose to use Excel's built-in borders or explore the capabilities of WPS Office, adding borders will undoubtedly elevate the presentation and organization of your data, making your spreadsheets more professional and engaging.


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