Any row containing only missing values (*) is excluded from the spreadsheet. This can be also used with table spreadsheets to hide empty rows of factor combinations that do not exist. You can combine this with other restrictions.
- From the menu select Spread | Restrict/Filter | Exclude Rows With All Missing Values.