How to solve the problem of unable to paste data in wps. How to solve the problem of unable to paste data in wps.

WPS users troubled by being unable to paste data? If you're having trouble pasting data when using WPS, you're not alone. This issue bothers many users and can be caused by several reasons. PHP editor Youzi understands that the most common culprit may be that you have copied the wrong table format. To fix this issue and get back to smooth pasting, continue reading the following step-by-step guide.

Method 1

1. The error message is, when pasting, it always prompts that the WPS table cannot paste information because the shape of the copy area and the paste area are different.

2. The copied data table is in xls format, and the table to be pasted is in xlsx format. When copying, select the entire row or column to copy, and then paste it and you will see a similar prompt. If this is the case, just select the area with data when copying or just select the first cell when pasting.

3. When copying, multiple worksheets are selected at the same time. For example, sheet1, sheet2, and sheet3 under the workbook are selected at the same time and then the data is copied. In this case, you only need to select a single worksheet for copying, and there will be no copy failure. situation.

Method 2

1. Check whether the entire workbook is protected, right-click the workbook label below.

2. Click to unprotect the worksheet.

3. Select any cell in the table and right-click.

4. Click to set the cell format.

5. Click the Protection tab.

6. Click the √ in front of the lock.

7. Click OK to solve the problem of being unable to paste information.

The above is the detailed content of How to solve the problem of unable to paste data in wps. How to solve the problem of unable to paste data in wps.. For more information, please follow other related articles on the PHP Chinese website!