How to Lock Borders in Excel (With Easy Steps)

Get FREE Advanced Excel Exercises with Solutions!

While working in Excel, we need to deal with a lot of tables in a dataset. Sometimes we may need to lock the borders of a table in Excel. There is a few distinct or specific way to lock borders in Excel. In this article, I am going to show how to lock borders in Excel with easy steps. I will show 4 easy steps to lock borders. Hopefully, you will find the ways interesting. To lock borders in Excel, simply follow the steps described below. Have a look at the illustrations also.

How to Lock Borders in Excel: Step-by-Step Procedures

From here I will describe the steps briefly to lock borders in Excel. Have a look at our dataset given below. The dataset consists of two columns B & C called Year and Sales. This is the dataset of Annual Sales of ABC Traders. It ranges from B4 to C10. So, without further delay, let’s jump into the solution to our problem.

Dataset of how to lock borders in Excel

Step 1: Creating a Dataset

This is the first step of this method. Our main focus is to lock the borders of a table in Excel. So, we need a dataset. In this step I am going to create a dataset, I will use this dataset throughout the whole steps and will complete the article.

  • In the very first step, I created a dataset like the picture given below. There will be no borders on the table.

Dataset of how to lock borders in Excel

Read More: How to Insert Border in Excel

Step 2: Select Conditional Formatting

This is the second step of this method. I will select the conditional formatting here. By using conditional formatting, I will lock borders in Excel. Follow the steps one by one mentioned below:

  • In the second step, first, select the whole dataset.
  • After that, select the Home tab from your toolbar.
  • Then, select the Conditional Formatting.

Similar Readings

Step 3: Applying New Rule

This is the most important step of this method. By applying the new rule, conditional formatting will work. Consequently, we will find our desired result. Hence, follow the steps mentioned with bullet points.

  • In step 3, you need to select the New Rule.

New rule of how to lock borders in Excel

  • Consequently, the window shown below will pop up.
  • Then select the option mentioned in the next picture.
  • After that, write down the following formula.
  • Next, select the Format option.

New rule of how to lock borders in Excel

  • Then, select the Border option.
  • After that, select the Outline option.
  • At last, press the OK.

new rule of how to lock borders in Excel

Read More: How to Add Cell Borders Inside and Outside in Excel

Step 4: Showing Final Result

  • As a consequence of the first three steps, you will find the result just like the picture given below.

Read More: How to Add or Remove Dotted Border in Excel

Things to Remember

  • You will find borders after pasting a table by using the Ctrl+V

Download the Workbook

Please download the workbook to practice yourself


In this article, I have tried to explain how to lock borders in Excel. I hope you have learned something new from this article. Now, extend your skill by following the steps of these methods. If you have any kind of queries feel free to ask me in the comment section. Don’t forget to give us your feedback.

Related Articles

Souptik Roy
Souptik Roy

Hello there. This is Souptik Roy. I graduated from Naval Architecture & Marine Engineering department. I am trying to explore the world of Microsoft Excel and want to increase my analytical power apart from my Engineering degree, as I have a curious mind. this is why I am trying to learn Excel Operations and write articles to help others.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF