How to solve the problem that data cells in Excel cannot be dragged and dropped WPS How to solve the problem that data cells in Excel cannot be dragged and dropped

How to solve the problem that data cells in Excel cannot be dragged and dropped? The method is very simple. Users can directly open the table, then left-click to select the cell and find the file options interface on the upper left side, and then find the editing function to perform the operation. Let this site carefully introduce to users the solution to the problem that WPS Excel data cells cannot be dragged and dropped. Solution to the problem that WPS Excel data cells cannot be dragged and dropped 1. First, we need to open the table. Generally, we will use the left mouse button to drag the required cells to the location to be displayed, but we find that the drag and drop function cannot be used.

2. Then we move the mouse to the [File] option on the upper left side of the page and click it.

3. Then a drop-down menu option will be displayed. Click the [Option] directly to enter the page.

4. Then we need to click [Edit], then click and check the [Cell Drag and Drop Function] option on the right, and then click the OK button.

5. Then we return to the page and use the left mouse button again to drag and drop the cell data. Then you can drag and drop at will, as shown in the figure.

The above is the detailed content of How to solve the problem that data cells in Excel cannot be dragged and dropped WPS How to solve the problem that data cells in Excel cannot be dragged and dropped. For more information, please follow other related articles on the PHP Chinese website!