How to Cancel Moving Border in Excel (4 Quick Tricks)

In this tutorial, I am going to show you 4 quick tricks to cancel the moving border in excel. You can quickly use these steps even in large datasets after copying the data cells. Throughout this tutorial, you will also learn some important excel tools and techniques which will be very useful in any excel related task.


Download Practice Workbook

You can download the practice workbook from here.


4 Quick Tricks to Cancel Moving Border in Excel

We have taken a concise dataset to explain the steps clearly. The dataset has approximately 6 rows and 2 columns. Initially, we formatted all the cells containing dollar values in Accounting format. But you can use the methods of this tutorial for other types of data like currency, percentage, time, etc although you might have to do some minor modifications.

how to cancel moving border in excel


1. Cancel from Clipboard

The Clipboard task pane in excel can keep track of data that you copy and paste individually or using a single click. We can also modify data histories from this feature. In the following steps, we will see how to use this feature to cancel the moving border in excel.

Steps:

  • First, copy the dataset as you regularly do, and then click on the Clipboard icon on the top left.

using clipboard to cancel moving border in excel

  • Now, click on the drop-down beside your data set name and select Delete.
  • Alternatively, you can also click on Clear All and this should also work the same.

using clipboard to cancel moving border in excel

  • Consequently, this should cancel the moving border from your dataset.


2. Using Escape Key

The Esc key can perform many useful tasks in excel including canceling entries in a cell or formula bar, closing an open menu, message window, etc. Let us see how to use this key to cancel the moving border.

Steps:

  • After copying the dataset, press the Esc key on your keyboard.

using escape key to cancel moving border in excel

  • Immediately, this should remove the moving border and cancel copying.


Similar Readings


3. Double Clicking on Empty Cell

In this method, we will see how to cancel the moving border in excel using double-click.

Steps:

  • To begin with, simply copy the desired cells, and then to remove the border, double click on any of the empty cells.
  • As a result, the moving border should no longer exist.

Read More: How to Add or Remove Cell Borders in Excel


4. Applying VBA to Cancel Moving Border

If you are familiar with VBA in excel, then you can also use that to cancel the moving border from a dataset. Follow the steps below to do this.

Steps:

  • First, go to the Developer tab and select Visual Basic.

  • Now, select Insert in the VBA window and click on Module.

  • Next, type in the formula below in the new window:
Public Sub CancelMovingBorder()
Application.CutCopyMode = False
End Sub

  • Then, click on the Run button as in the image below.

  • Finally, you should find that the VBA code has canceled the moving order from the dataset.

Read More: How to Apply Borders in Excel with Conditional Formatting


Things to Remember

  • In Windows 10 and 11, you can configure the clipboard to copy data from one device to another.
  • If you are on Mac, then you can use the Cmd+period(.) instead of the Esc key.

Conclusion

I hope that you were able to apply the methods that I showed in this tutorial on how to cancel the moving border in excel. As you can see, there are quite a few ways to achieve this. So wisely choose the method that suits your situation best. If you get stuck in any of the steps, I recommend going through them a few times to clear up any confusion. Lastly, to learn more excel techniques, follow our ExcelDemy website. If you have any queries, please let me know in the comments.


Related Articles

Nazmul Hossain Shovon

Nazmul Hossain Shovon

Hello, I am Nazmul Hossain. I am currently working full-time in Exceldemy as an Excel & VBA Content Developer. I have completed my bachelors in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology. I am interested in working with MS Excel. I also like coding web applications a lot.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo