Connect with us

Hi, what are you looking for?

Microsoft Excel
Microsoft Excel
Microsoft Excel


Microsoft Excel : How to create a custom border in Microsoft

Microsoft Excel : You have many options for adding cell parameters to Microsoft Excel. But if you want to create a little more or use a border that has more meaning for you, you can create and use a custom border in Excel.

Advertisement. Scroll to continue reading.

The default border options in Microsoft Excel are correct in most cases. You can use the cell border up, down, left or right, around a group of cells inside and out, and choose the thickness and style of the line.

But perhaps you are doing a lot of data analysis and looking for something other than these options that you can use quickly and without conditional formatting automatically.

Advertisement. Scroll to continue reading.

Create a Border Cell Custom style in Microsoft Excel:

Using Cell Styles, you can create and customize a cell border that you can reuse throughout your workbook.

To get started, open your workbook in Microsoft Excel and go to the Home tab. In the carbon style section, click “Cell Styles” and select “New Cell Style.”
In the style window that appears, click “Format.”
Format a custom border
When opening the Format Cells window, select the Border tab. On the left, select a line style and color it to your liking

Advertisement. Scroll to continue reading.

On the right, use the Presets and Border boxes to select where and how your border will be displayed. You can select a border up, down, left, or right, and use separate lines in the middle. As you click on each Border box in Microsoft Excel , you’ll see a preview of what your border will look like.
In our example, we will create a red cell border with both thick and thin lines that cross over the content of the cell. This allows us to easily eliminate certain cells as we update our data.
With flexible options, you can combine colors, line styles and sizes, with different sides or center line for you. So you have complete control over your border preferences.
When done, click “OK” and you will return to the style window to finish setting your cell style.

Microsoft Excel
Microsoft Excel

Finish setting cell style in Microsoft Excel

Enter a custom name for the custom border. After that, don’t check everything except Border. If you want to use one of the additional styles and your custom border, just check the box.
Next to the Border option, you’ll also see the newly selected border settings. Click “OK” to complete the new cell style border.
Use your Border Cell Custom style
If you want to use your new custom border, select a cell or cell width. Go to the Home tab and click “Cell Styles” on the button. You will see your new style at the top under Custom. Click to use it in stock.
You can also apply your custom border (Cell Style) to any sheet in your workbook, making it a quick and easy formatting option.

Advertisement. Scroll to continue reading.
Click to comment

Leave a Reply

Your email address will not be published. Required fields are marked *

You May Also Like


Tmz Baltimore Tzz TMZ Baltimore Twitter Full Video Explained Virus Reddit!Here we share with you the latest news, that the Twitter video “Tmz Baltimore”...

Science and Technology

Two non-executive directors of Huawei UK have resigned due to the company’s position regarding the Ukrainian conflict. The BBC understands that Sir Andrew Cahn...


Afghanistan Cricket Board (ACB) to carry on its activities as usual, sources told Geo News Thursday.According to the sources, Afghanistan Cricket Board ACB has...


Viral leaked videos, the referee Diana Di Meo victim of revenge porn: “I denounce the video with my head held high,” Says Diana Diana...


“@Mariaramirez96 goes viral frog video” shared an original frog video. A live frog emerges from a South African woman’s v****a. On Twitter, who is...


Mr Beast, a Famous YouTuber, has made news after his obscene video leaked on social media. Mr. Beast’s video is leaked on Twitter and...


The Crypto Boom SYDNEY, Nov 8 (Reuters) – On Monday. Bitcoin surged near its all-time high. While ether set a new high as cryptocurrencies...


In the event that you’ve known about any digital currency trade, it’s likely Coinbase. Bitcoin early adopters have been purchasing and exchanging coins on...