Omit missing

You can hide rows or columns that contain no data without removing them from the database using the Omit Missing command. Right-click anywhere in a data area and select Omit Missing. Select from:

• By Column. This command hides all columns with no data.
• By Row. This command hides all rows with no data.
• Both Row and Column. This command hides all rows and columns with no data.
• None. This command restores any previously hidden columns or rows with no data.

If you export to Excel, the Excel report respects the current setting for this command.