How to paste in Excel with formatting

Microsoft Excel is a powerful tool that is widely used in businesses, academic institutions, and personal finance. One of the most common tasks in Excel is to copy and paste data from other sources. However, when you paste content into Excel, the formatting may not always carry over, resulting in a disorganized and difficult-to-read spreadsheet.

Here we have a dataset related to patients as an example. We will copy this data with formatting using two different methods and paste it by following the steps below. Let’s have a look at the dataset first above.

Method 1 – Move or Copy:

Step 1 – Select the Data

  • Select the data you want to move.
  • Right click on the current sheet tab below.
  • Click on Move or Copy.

Step 2 – Choose where to paste data.

  • After clicking on the Move or Copy option, choose the book where you want to paste the data.
  • Check the box below of Create Copy.
  • Click Ok.
  • Data will automatically be pasted in the selected cell with the format.

Method 2 – Paste Special:

Step 1 – Open Paste Special.

  • Copy the data you want to paste.
  • Select the cell where you want to paste data.
  • Right click on the cell and open dropdown menu of Paste Special.

Step 2 – Keep source Formatting.

  • After opening the dropdown menu for Paste Special.
  • Click on Keep Source Formatting.