How To Paste Without Formatting In Excel

In today’s fast-paced business world, Excel has become an essential tool for data management, analysis, and reporting. Whether you are creating a financial report, analyzing sales figures, or managing a project, Excel’s features can help you organize and analyze data more efficiently. However, one common issue users face is pasting data with formatting, which can make your spreadsheet look cluttered and difficult to read. In this article, we’ll show you how to paste without formatting in Excel, so you can streamline your workflow and make your data easier to read and understand.

Suppose we have the following dataset above & we want to paste it without its formatting.

Method 1 – Paste Special Dialog Box

Step 1 – Select Data

Select data which you want to paste to another location.

Step 2 – Copy The Data

Right click on the selection and select copy or select data & press CTRL + C on your keyboard.

Step 3 – Use Paste Special Options

Now select the cell where you want to paste your data (cell F1 for our example).
Right click on the cell & click Paste Special.
Select Values & click OK button.

Step 4 – Data Pasted Without Formatting

Through this method you can paste your data to the desired location.

Method 2 – Paste Without Formatting Using Shortcut Key

Step 1 – Select Data

Select data which you want to paste to another location.
Press CTRL + C on your keyboard to copy it.

Step 2 – Use Shortcut Key for Paste Special Options

Now select the cell where you want to paste your data (cell F1 for our example).
Press CTRL + ALT + V. Paste Special dialog box will appear on your screen.
Select Values & click OK button.