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

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

Aug 28, 2024 pm 01:11 PM

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

Excel表格中明明有数据但筛选空白怎么回事

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

Excel表格中明明有数据但筛选空白怎么回事

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.

Excel表格中明明有数据但筛选空白怎么回事 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.

Excel表格中明明有数据但筛选空白怎么回事 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, Excel表格中明明有数据但筛选空白怎么回事 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!

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undress AI Tool

Undress AI Tool

Undress images for free

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

How to enable the Adobe Acrobat extension in Chrome? How to enable the Adobe Acrobat extension in Chrome? Jul 02, 2025 am 12:51 AM

To solve the problem that Chrome browser cannot preview PDFs online, 1. Install the official Adobe Acrobat extension; 2. Enter the extension page to make sure it is enabled and set to allow incognito mode to run; 3. Turn off the built-in PDF reader option in Chrome settings to set it to be opened by default with Acrobat; 4. If you encounter a prompt "Managed by Organization", you need to contact the administrator to handle it. After completing the above steps, you can directly view PDF files in your browser.

Why are my lines not showing up in AutoCAD? Why are my lines not showing up in AutoCAD? Jul 01, 2025 am 12:04 AM

Problems are usually caused by layer settings, viewport display, line-type scale, or graphic refresh. 1. Check whether the layer is closed or frozen, and confirm that the color is different from the background; 2. Use ZOOMEXTENTS in the viewport to ensure that the geometry is within the visual range; 3. Adjust the LTSCALE value to fix the linear scale abnormality; 4. Check whether there are color output restrictions in the printing style sheet; 5. Try the REGEN command or switch the visual style to solve the graphics rendering problem. Check the reasons in order to quickly locate the reasons.

How to send a document for signatures with Adobe Acrobat Sign? How to send a document for signatures with Adobe Acrobat Sign? Jul 02, 2025 am 12:44 AM

The steps to send documents for others to sign with Adobe AcrobatSign are as follows: 1. Prepare the final version of the PDF file. If there is no PDF, you can upload it to other formats to automatically convert it, and ensure that the content is correct; 2. Create a new signing process after logging in, add recipient information and set the signature location, assign permissions to each signer, and adjust the signing order; 3. Optionally set email reminders, deadlines and signature methods to improve signing efficiency; 4. Send the document after confirming that it is correct, track the signing status through the system in real time, and download a copy or resend a reminder to complete the signing process.

How to create a neon effect in Photoshop How to create a neon effect in Photoshop Jul 02, 2025 am 12:16 AM

The key to making neon light effects in Photoshop lies in the matching of layer style and overlay method. The specific steps are as follows: 1. Use "Inner Glow" and "Gradial Overlay" to create basic luminescence, select neon tones and adjust parameters to simulate the brightness of the lamp; 2. Add "Outer Glow" and combine "Gaussian Blur" to enhance the three-dimensional sense of the halo; 3. Improve the texture by adding noise to make the effect closer to the real neon; 4. Use dark backgrounds, projections and atmosphere materials to enhance the overall visual impact.

How to make an image look old in Photoshop How to make an image look old in Photoshop Jul 02, 2025 am 12:47 AM

To make pictures look age-like in Photoshop, you need to imitate the characteristics of old photos and master the key steps. First, add warm tones to increase yellow and red to reduce blue by Color Balance, or use Gradient Map to select brown and yellow gradients and adjust blending mode and opacity. Secondly, adding texture and noise can be used to control the values ​​using the Add Noise filter, or overlay old photo textures and set blending mode. Again, make scratches and edge wear to download scratch maps as layers and adjust positions and modes, or use built-in filters to simulate effects. Finally, pay attention to moderate processing, use adjustment layers and masks to facilitate modification, and appropriately reduce contrast to make the picture softer and more natural.

How to change the default comment font in Adobe Acrobat? How to change the default comment font in Adobe Acrobat? Jul 03, 2025 am 12:30 AM

In AdobeAcrobat, the default annotation font is usually Arial or similar sans serif fonts, but can be changed by setting. 1. Create a new text comment and right-click to select "Properties"; 2. Switch to the "Font" tab page and select font, font size and color; 3. Check "Set as Default" to make subsequent comments use the font. If you need global settings, you should go to Preferences > Comments > Multi-appearance > Edit Properties to adjust the font options. Notes include: Settings may only be valid for the current document, non-standard fonts, or protected PDFs may restrict changes, and it is recommended to test common fonts in advance to ensure compatibility.

How to colorize a photo in Photoshop using neural filters How to colorize a photo in Photoshop using neural filters Jul 02, 2025 am 12:33 AM

When using neural network filters to color photos in Photoshop, you need to pay attention to key steps and details. First, make sure that the software version supports this function, log in to the Adobe account and download and install the filter plug-in; then open the "Smart Coloring" option, and let the AI ​​automatically finish the coloring after downloading the model; then check the results, use the brush tool, local application filters or combined with desaturation to manually color the error area; finally, after confirming that the effect is correct, export and save, it is recommended to keep the two versions of the AI ​​layer and the final product. Although the entire process is simple, you need to pay attention to network connection, model loading and post-adjustment techniques.

How to transfer an Adobe Acrobat license to a new computer? How to transfer an Adobe Acrobat license to a new computer? Jul 04, 2025 am 12:01 AM

To transfer the Adobe Acrobat license to a new computer, you must first log out on the old device and release the activation permission, and then complete the activation with the new computer login account. The specific steps are: 1. Open Acrobat on the old computer and click on the avatar or "Help" > "Log out" to log out; 2. Download and install Acrobat for the new computer and log in with the original account to automatically identify the license; 3. If the activation fails, check the network, clear the cache, unbind the old device through the Adobe account page, or contact customer service to solve the problem. The key point is to ensure that the old device has been logged out, clear the local cache and update the online device list before the migration can be completed smoothly.

See all articles