There is clearly data in the Excel table, but what's going on when filtering out the blanks?

Excel is an easy-to-use office software that can be used to perform many operations. Recently, when some people use this software to perform filtering operations, they find that there is data in the table but cannot be filtered out. What is going on? In fact, there are two reasons for this problem. For this reason, follow the editor to see how to solve it and share it with everyone. There is obviously data in the Excel table, but what's the matter with filtering out the blanks? The first reason is that the table contains blank rows

We want to filter all people with the surname Li, but we can see that the correct results are not filtered out because the table contains blank rows. How to deal with this situation? Solution: Step 1: Select all the content and then filter

Press ctrl shift l to cancel the filter, then select all the contents of the table, and then press ctrl shift l to filter. You can see that the table with blank rows can be filtered. . Step 2: Delete empty rows in the table in batches. Don’t delete them one by one. Select a column, then ctrl g, positioning conditions - null value, delete, select the right row, so that you can filter correctly. The second reason is that there are merged cells that cannot be filtered. Use ctrl + shift + l to filter the table. You can see that there are three people in the sales department, but only one person is filtered out. There are two ways to deal with it.

Abstract: In PHP development, file upload problems are often encountered. Due to PHP's overall security settings, the file upload process may be restricted. PHP editor Strawberry provides a detailed guide here to help you understand the reasons for PHP file upload restrictions and provide effective solutions. This article will delve into the principles of PHP file upload restrictions, including the superglobal variable $_FILES, ini configuration, server configuration, and other potential issues. In addition, the article will provide specific solutions for different scenarios, such as how to adjust PHP configuration, modify .htaccess files, and use third-party libraries. By reading this article, developers can have a comprehensive understanding of PHP file upload restrictions and master the skills to solve related problems to ensure that the file upload process is safe and efficient.

Step 1: Cancel the merged cell filter

① Select the column of the merged cells, and then cancel the merged cells

② ctrl + g, select null value for the positioning condition, enter =C2 (that is, the previous cell), Then ctrl + enter to fill in the content, and you can filter accurately.

Step 2: Do not merge cells manually

①Select the table, then

Data-Subclassification-Selected Summary Items--Select Department.

②Select the summary column, Ctrl + G

, Positioning conditions, select null value

, Center merged cells. ③Click any area of ​​the table, Data - Classification Summary - Delete all . ④Then use

to copy the blank merged cell column

, then Format Painter,

refresh the data

, and the cells are merged in batches. Merge cells in this form and you can filter.

The above is the detailed content of There is clearly data in the Excel table, but what's going on when filtering out the blanks?. For more information, please follow other related articles on the PHP Chinese website!