Free All-in-One Office Suite with PDF Editor
Edit Word, Excel, and PPT for FREE.
Read, edit, and convert PDFs with the powerful PDF toolkit.
Microsoft-like interface, easy to use.
Windows • MacOS • Linux • iOS • Android
How to Cut a Cell Value in Excel
When you are working in excel Excel/Spreadsheet WPS, you need to cut a cell value excel from one cell to another in same excel/spreadsheet or different. Most people get confused and found very difficult to cut a cell value excel in a cell and move to different cell.
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 cut a cell value 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 to cut a cell value excel Spreadsheet (2016/2019/Mac/Online)
How to cut a cell value excel in cell using Keyboard Shortcut
1.Go to WPS office and click on excel Spreadsheet
2.Select the range of the data in a cell or cells you want to cut in your excel/Spread Sheet.(In our sheet we want to cut data from column C to column F).
3.After selecting the data (Column C) go to your keyboard and press “ALT+X” key at the same time.
4.Then go to the location of cell or cells (Column F) where you want to paste or move data.
5.Select the cell and press the key ALT+V. The data will be pasted in that cell.
How to cut a cell value excel in cell using excel function
1.Go to WPS office and click on excel SpreadsheetSelect the range of the data in a cell or cells you want to cut in your excel/Spread Sheet.(In our sheet we want to cut data from column C to column F).
2.Go to the Manu Bar and Click on “CUT”
3.Then go to the location of cell or cells (Column F) where you want to paste or move data.
4.Then GO to Manu bar and clink on Paste
5.And the data will be pasted in that cell.
How to cut a cell value excel in cell using Mouse
1.Go to WPS office and click on excel SpreadsheetSelect the range of the data in a cell or cells you want to cut in your excel/Spread Sheet. (In our sheet we want to cut data from column C to column F).
2.After selection the data, Right Click on the cell and a table will be displayed.
3.Click on CUT from the table.
4.GO to the cell in your excel/spread sheet where you want to paste data and right click there.
5.A table will be displayed and click on paste
6.After you click on paste the Data/values will be pasted in that cell.
This article has covered the methods on How to cut a cell value excel/spreadsheet WPS (2016/2019/Mac/Online),You can use these simple steps as explained above and easily cut a cell value excel in your WPS Excel/Spreadsheet (2016/2019/Mac/Online) whenever required.
Hopefully, you have learned How to cut a cell value excel 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
Also Read:
- 1. How to Cut a Cell Value in Excel Using Shortcut
- 2. How to cut off text in excel
- 3. Excel formula: if cell contains text then return value in another cell
- 4. How to Calculate P-Value in Excel
- 5. How to color cell based on value in Excel?
- 6. Three commonly shortcut keys in WPS Office: Copy, Paste and Cut