How to copy value without formula in Excel?

August 9, 2022
10.3K Views
0

A free Office suite fully compatible with Microsoft Office

Free Download

When you are working in excel Excel/Spreadsheet WPS, copying and pasting is frequently performed from one cell to another. Most people get confused and found very difficult to excel copy value not formula and paste  in a cell.


As when they copy data from a cell, it not only copies the content from that cell but also the format such as background color, font color and formula within it. While you only want to copy values not formula within it.


However Using WPS excel/spreadsheet is very simple and helpful only if you know the right steps and methods. This article will help you to understand the steps involves how to copy values not formula from data as values in excel/spreadsheet WPS and after reading the article you can easily perform this task in your WPS excel/spreadsheets (2016/2019/mac/online).

Followings are the simple steps to be followed to easily understand this task,

Different ways How to copy value not formula in Excel Spreadsheet (2016/2019/Mac/Online)

How to copy value not formula in cell using paste values command

1.Go to WPS office and click on excel Spreadsheet


2.Right Click on cell from which you want to copy the data,Copy the data you want to paste as values into your clipboard,

.

3.Choose a new cell in your excel/spreadsheet WPS (2016/2019/mac/online) where you want to paste the data and Then right click on that cell and go to paste special.  

4.When you click on Paste special a further tab will be shown Then click on paste as values and your data will be pasted as value in that cell.

How to copy value not formula in cell using paste special command

1.Right Click on cell and copy the data you want to paste as values into your clipboard


2.Click on the cell where you want to paste data as values

3.Go to the menu bar at top and click at paste option.A table name of paste special will be displayed on your excel spreadsheet.

4.In paste click on the values and then press ok.

5.After this your value will be pasted in that cell.

How to copy value not formula in cell using Keyboard shortcut

1.Right Click on the cell from which you want to copy the data in your excel spreadsheet.

2.Copy the data from that cell to your clipboard.Click on the cell where you want to paste the data as values.

3.Then press CTLR + SHIFT +V on your keyboard

4.The data will be pasted in cell as values.



This article has covered the methods on How copy value not formula in excel/spreadsheet WPS (2016/2019/Mac/Online) You can use these simple steps as explained above and easily copy value not formula in your WPS Excel/Spreadsheet (2016/2019/Mac/Online) whenever required.

Hopefully, you have learned How to copy value not formula in WPS Excel/Spreasheet (2016/2019/Mac/Online) by following the above steps.  


If you want to know more about Word features, you can follow WPS Academy to learn. You can also download WPS Office to edit the word documents, excel, and PowerPoint for free of cost. Download now! And get an easy and enjoyable working experience