What should I do if the excel filter turns gray?

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!