Home Screenshots 10 Languages Why use it?

Tip of the Day | Saturday February 28th, 2026

Discover new tools to get things done. ASAP Utilities makes YOU rock in Excel!

Fill Blank or Empty Cells with a Specific Value...

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

Click ASAP Utilities › Fill › 1. Fill Blank or Empty Cells with a Specific Value...
Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...

Fill › Fill Blank or Empty Cells with a Specific Value...

Choose your language preference below

English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語

Yesterday's Tip

Tomorrow's Tip

Download

©1999-2026 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands

🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 26 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.