Easily select non-blank or non-empty cells in a range in Excel
Kutools for Excel
Boosts Excel With 300+
Powerful Features
Sometimes, you may need to replace all non-blank cells with same text in the selected range. To replace all non-blank cells in a range, you must select them first. With the Select Nonblank Cells utility of Kutools for Excel, you can select all non-blank cells from a range with just one click.
Select non-blank cells in a range in Excel
Click Kutools > Select > Select Nonblank Cells. See screenshot:
Select non-blank cells in a range in Excel
1. Select the range with non-blank cells you want to select.
2. Click Kutools > Select > Select Nonblank Cells. See screenshot:
3. Then a dialog box comes out and tells you how many nonblank cells have been selected in the specified range. Click the OK button to close it.
So far all nonblank cells have been selected as below screenshot shown:
Note: This feature also can be applied to multiple sections in a worksheet.
Demo: Easily select non-blank or non-empty cells in a range in Excel
Productivity Tools Recommended
Office Tab: Use handy tabs in Microsoft Office, just like Chrome, Firefox, and the new Edge browser. Easily switch between documents with tabs — no more cluttered windows. Know more...
Kutools for Outlook: Kutools for Outlook offers 100+ powerful features for Microsoft Outlook 2010–2024 (and later versions), as well as Microsoft 365, helping you simplify email management and boost productivity. Know more...
Kutools for Excel
Kutools for Excel offers 300+ advanced features to streamline your work in Excel 2010 – 2024 and Microsoft 365. The feature above is just one of many time-saving tools included.
