Paste Value with Shorcut in Excel
A free Office suite fully compatible with Microsoft Office
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 copy and paste value excel shortcut in a cell.
As when they copy data from a cell, it not only copies the content from that cell but also the form, such as background color, font color and formula within it. While you want to copy only the cell values and not the formatting and the 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 to use paste value excel shortcut in WPS office 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,
Three different ways on how to use paste value excel shortcut in Excel Spreadsheet (2016/2019/Mac/Online)
How to use paste value excel shortcut 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 paste value excel shortcut 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. After this your value will be pasted in that cell.
How to use paste value excel shortcut 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.
3.Click on the cell where you want to paste the data as values.
4.Then press CTLR + SHIFT +V on your keyboard.
The data will be pasted in cell as values.
This article has covered the methods on How to use paste value excel shortcut in excel/spreadsheet WPS (2016/2019/Mac/Online),You can use these simple steps as explained above and easily use paste value excel shortcut function in your WPS Excel/Spreadsheet (2016/2019/Mac/Online) whenever required.
Hopefully, you have learned How to paste value excel shortcut 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.
Was this helpful?
- 1. How to compare two excel sheets and highlight differences
- 2. How to expand cells to fit text in Excel
- 3. How to copy file names in Excel from a folder?
- 4. How to import external data in WPS Spreadsheet
- 5. How to use the VLOOKUP function across multiple sheets in WPS Office Excel?
- 6. Top 10 simple family tree template Excel free download