Method: 1. Open the excel table and frame-select the data; 2. Right-click "Copy"; 3. Right-click on the desktop, click "New", select the excel table and click to enter; 4. Right-click and click " Just paste".
Method:
Open the excel file in protected state
Click and drag with the left mouse button to select the document data
After selecting, right-click to select the "Copy" function
Return to the desktop, right-click the mouse and select the "New" menu
Select the Excel worksheet
Open the newly created Excel and paste the content you just copied into it
As shown in the figure, the filtering function is no longer gray and you can use the filtering function normally
Recommended tutorial: "excel tutorial"
The above is the detailed content of What should I do if the excel filter turns gray?. For more information, please follow other related articles on the PHP Chinese website!