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
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
Data-Subclassification-Selected Summary Items--Select Department.
②Select the summary column, Ctrl + G
, 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!