How to Copy Values in Excel Without the Formula?


Share This Post

Spreadsheet software, such as Microsoft Excel and Google Sheets, is ideal for data manipulation.

These programs appear to have an infinite number of possibilities for manipulating, arranging, and sifting through data. After manipulating your data using formulae and equations, you may wish to copy and paste it elsewhere. The issue is that a simple copy and paste will only transfer the formulae, not the data.

In this tutorial, we’ll teach you how to replicate data in Excel rather than using formula.

The method is equally comparable in Google Sheets, so you will learn how to do this activity regardless of the spreadsheet program you use. Let’s get started with the tutorial below.

How to Copy Values in Excel Instead of the Formula?

How to Copy Values in Excel Instead of the Formula?To copy and paste values in Excel, follow these steps:

  1. Highlight the data that you would like to copy.
  2. Press Ctrl+C on the keyboard to copy the data.
  3. Select where you would like to paste the data.
  4. Go to Paste, Paste Values, Values.

The first step is to launch Microsoft Excel and open your spreadsheet. Find and highlight the values you want to copy and paste. The values in this guide might be formulae or cells with computations.

To copy the data, use Ctrl+C on your keyboard. You may also copy the data manually by heading to the Home tab and choosing the Copy option. Alternatively, right-click the selected area and choose Copy.

How to Copy Values in Excel Instead of the Formula?

How to Copy Values in Excel Instead of the Formula?Now that your data has been transferred to the clipboard, you may choose where you want to paste it. In our case, we’ll paste it right next to the current data in column C.

Then, from the Home tab, click the down arrow next to the Paste button. In the Paste Values area of the dropdown menu, locate and pick the Values option.

Microsoft Excel – Paste Values Option

By selecting this option, the data will be pasted into your spreadsheet, beginning with the cell you have chosen.

You can also use Ctrl+V to paste the information into another application, such as Notepad, Chat, or any other software. By default, the formulae will only paste in spreadsheet tools such as Excel and Google Sheets.


Please enter your comment!
Please enter your name here

Related Posts

Learn How to Select All in VIM?

Now is the time to improve your VIM skills...

Learn How to Modify Color Syntax in Notepad++

Since it came out in 2003, Notepad++ has become...

How to Fix replaceAll is not a function in Node JS?

One of the most used string prototypes in JavaScript...

Learn How to Set the Viewport in Puppeteer?

One of the most popular headless chrome APIs for...

Learn How to Reverse Order of a ForEach Loop in PHP?

As a programmer, you'll quickly learn how to work...

How to Get Elements between Indexes in Javascript Array?

If you want to be a good programmer, you...
- Advertisement -spot_img