Paste Values Using Shortcut 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 values 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 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 in paste 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,
Three different ways How to Paste values in Excel Spreadsheet (2016/2019/Mac/Online)
How to paste values 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 values 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 valuesGo to the menu bar at top and click at paste option A table name of paste special will be displayed on your excel spreadsheet.
3.In paste click on the values and then press ok After this your value will be pasted in that cell.
How to paste values 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 keyboardThe data will be pasted in cell as values.
This article has covered the methods on How to paste values in excel/spreadsheet WPS (2016/2019/Mac/Online),You can use these simple steps as explained above and easily paste values in your WPS Excel/Spreadsheet (2016/2019/Mac/Online) whenever required.
Hopefully, you have learned How to paste values 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
- 1. How to get month name from a date in Excel (3 easy ways)
- 2. Check if value is in list in Excel (3 easy methods)
- 3. How to Copy File Names in Excel from a Folder?
- 4. How to add text to beginning or end of all cells in Excel
- 5. How to color cell based on value in Excel?
- 6. How to compare two excel sheets and highlight differences