Tip of the Day | Friday 23 October 2026

This tool fills all blank or empty cells in your selection with a given value.

It also works on cells that seem empty but aren't detected by Excel's Go To > Special > Blanks or the ISBLANK() function. These are cells that contain a zero-length string, a term Microsoft uses for values that look blank but actually contain invisible content, such as a single apostrophe or the result of a formula like "" that was pasted into the cell as a value.

It is helpful when cleaning up spreadsheets with missing values, such as:

• Filling blanks with 0 in financial data
• Replacing empty cells with "N/A", "Not Available", or "-"
• Inserting placeholder text like "To be updated"
• Standardizing tables before exporting, printing, or sharing

It can save time when working with large datasets, especially after importing, pasting, or sorting.

Note: If you select only one cell, you'll be asked if you want to fill all empty cells in the used area of your worksheet.

Starting this tool