Gradebook report to differentiate if there are missing assignments

When I download the gradebook there are blank cells. These belong to assignments I have not graded and also assignments that have not been submitted.   I would like to see a gradebook report...