How to hide rows if cell is blank in Excel?
Supposing you have a large worksheet which populated with both values and blank cells, and now you want to hide the rows if there is blank cells filled in the row. How could you solve this problem in Excel?
Recommended Productivity Tools for Excel
Office Tab: Bring powerful tabs to Office (include Excel), just like Chrome, Safari, Firefox and Internet Explorer. Save you half the time, and reduce thousands of mouse clicks for you. 30-day Unlimited Free Trial
Kutools for Excel: Save 71% of your time and solve 82% Excel problems for you. 300+ advanced tools designed for 1500+ work scenario, make Excel much easy and increase productivity immediately.60-day Unlimited Free Trial
With the Go To Special function, you can select the blank cells first and then apply the short cut keys to hide the rows which contain blank cells. Please do with following steps:
1. Select the data range which contains the blank cells you want to hide.
2. Then click Home > Find & Select > Go To Special, see screenshot:
Tip: You also can press Ctrl + G to open Go To dialog and click Special to get the Go To Special dialog.
3. And in the Go To Special dialog, select Blanks option, and then click OK button.
4. All of the blank cells in the selection have been selected, see screenshot:
5. Then you can press Ctrl + 9 keys together to hide the rows which have blank cells.