Tip of the Day | Sunday February 8th, 2026

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

Fill Blank Cells with Value from Above

This tool fills each empty cell in your selection with the value from the first filled cell directly above it.

It is useful when preparing data for sorting, filtering, or creating a pivot table, where each row needs to contain complete information.

Only blank cells are changed. Filled cells remain untouched.
It works across multiple columns in your selection.

Example:
Before:
Department
Sales
(blank)
(blank)
Marketing
(blank)

After:
Department
Sales
Sales
Sales
Marketing
Marketing

This helps create a clean, fully populated dataset that is easier to analyze and report.

Click ASAP Utilities › Fill › 3. Fill Blank Cells with Value from Above
Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...

©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.