How to Paste External Content to Excel Always Match Destination Formatting?

Excel is an effective tool for manipulating and analysing data, and we frequently need to import data from many outside sources. However, formatting errors that can interfere with your work flow and analysis might appear when you copy and paste text from external files or programmes into Excel.

By the end of this tutorial, you will have a strong grasp of the many strategies you can use to guarantee that the formatting of the destination cells for copied data in Excel always matches. You will be given the information and resources you need to manage data imports successfully, saving you a lot of time and effort in the process. So let's get started and learn how to format copied external text consistently in Excel!

Paste External Content to Excel Always Match Destination Formatting

Here we will first insert a VAB module, then assign it to a shortcut to complete the task. So let us see a simple process to know how you can paste external content to Excel and always match destination formatting in Excel.

Step 1

Consider any Excel sheet.

First, right-click on the sheet name and select View code to open the VBA application.

Right Click > View Code.

Step 2

Click on Insert and select Module, then copy the below code into the text.

Insert > Module > Copy.

Code

Sub PasteWithDestinationFormatting()
ActiveCell.PasteSpecial (xlPasteValues)
End Sub

Step 3

Then close the VBA using Alt + Q. Then click Alt + F8 to open the macro window, then click on Options.

Alt + Q > Alt + F8 > Options.

Step 4

Finally, assign a shortcut and click OK to complete the task. From there, you can use the shortcut to achieve the task.

Shortcut > Ok.

This is how you can paste external content into Excel and always match the destination formatting in Excel.

Conclusion

In this tutorial, we have used a simple example to demonstrate how you can paste external content into Excel and always match destination formatting in Excel to highlight a particular set of data.