Data Import & Export

How to Find Blank Excel Cells and Export Missing Student Work

Maira Mehtab Sep 21, 2026 869 views

Question details

The user wants to identify blank cells in an Excel grading sheet and generate a list of missing assignments for each student on a separate worksheet, without altering the original data structure.

Product: Excel
Device & OS: not provided
Scenario: Tracking student grades and finding missing assignments to export into a dedicated tracking sheet.
Observed behavior: The user needs to extract and associate blank cells with correct student names into a new sheet while preserving the original blank cells in the grading sheet.

Before you start

Ensure your student data is organized in a clear tabular format with student names in one column and their assignment grades in adjacent columns.

Solution 1Recommended

Extract Missing Student Assignments Using Formulas

Use Excel formulas to automatically check for empty cells and list the corresponding students and missing assignments on a new sheet.

Instead of manually searching for empty cells or risking data loss by deleting rows, you can use specialized formulas. These formulas cross-reference your main grading sheet and populate a separate 'Missing' sheet with the names of students who have blank entries.

Create a Missing Worksheet

Click the '+' icon at the bottom of your Excel window to create a new sheet and rename it to 'Missing'.

Set Up Headers

In the new sheet, create headers such as 'Student Name' and 'Missing Assignment' in row 1 to organize the extracted data.

Apply the Extraction Formula

Use a combination of IF, INDEX, and MATCH (or the FILTER function if available) in your new sheet to reference the original grading sheet. The formula should check if the grade cell is blank, and return the student's name if true.

Review the Sample Workbook

To see the exact formulas in action, download and review the official sample workbook which demonstrates how to create a Missing sheet while preserving the original blank cells.

Sample Workbook Available: You can download a complete sample workbook demonstrating this setup at: https://www.dropbox.com/scl/fi/up24tik333x4sny5vd1jt/MissingAssignments.xlsx?rlkey=7tnbeqroxh0h5vn4z2fgg971e&dl=1

Free Spreadsheet Software

Find Blank Cells Easily with WPS Spreadsheet

WPS Spreadsheet offers powerful formula support and data extraction tools to help educators and professionals quickly identify missing data, seamlessly tracking student progress without modifying original records.

1. Open Data: Open your grading file in WPS Spreadsheet.
2. Add Sheet: Click the '+' button to create a new worksheet dedicated to missing assignments.
3. Insert Formulas: Use WPS's comprehensive formula library to reference and extract data from the blank cells.
4. Save File: Save your work seamlessly in .xlsx format for easy sharing with colleagues or students.

Fully compatible with Microsoft Excel formulas and .xlsx formatAdvanced filtering and data extraction capabilitiesFree, lightweight, and easy to use

microsoft office alternative - wps office

Frequently Asked Questions

Can I find blank cells without using formulas?

Yes, you can use the 'Find and Replace' feature or 'Go To Special' -> 'Blanks' under the Home tab to highlight missing data directly in the original sheet, though this won't automatically export them to a new sheet.

Will identifying blank cells alter my original grading sheet?

No. By extracting the data to a separate 'Missing' worksheet using referencing formulas, your original student grading sheet remains completely untouched.

What if a student has an excused absence instead of a missing assignment?

Instead of leaving the cell blank, you can enter a specific text like 'Excused'. Your formulas targeting blank cells (such as ISBLANK) will then ignore these entries, ensuring they aren't incorrectly marked as missing work.

Excel & Data Problems