logo ASAP Utilities

The ASAP Utilities menu in Excel (English)

Excel with ASAP Utilities in its menu

Fill Blank Cells with Value from Above

ASAP Utilities  › Fill  ›  3. 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.

Screenshots

Fill  ›  3 Fill Blank Cells with Value from Above
ASAP Utilities makes YOU rock in Excel!

Practical tricks on how this can help you

Practical 'real world' examples on our blog that show you how this tool can help you in Excel. Enjoy!

Starting this tool


Fill  ›  3 Fill Blank Cells with Value from Above
Additional keywords for this tool:
Fill down missing values, Copy value above into empty cells, Repeat previous value in blank cells, Copy down until next filled cell, Fill empty cells in column with above value, Auto fill blank rows with value above, Repeat item labels in pivot table format, Fill down in selection, Fill gaps in Excel data, Fill down values in multiple columns, Repeat non-empty cell in empty cells below, Copy top value to empty cells below, Bulk fill blank cells, Excel carry down previous value, Fill down until next group starts Excel, Excel fill missing values from above row, Repeat group headers, Fix blanks before pivot table, Fill between values, Fill empty cells based on neighbors

Choose your language preference below

English (us)NederlandsDeutschEspañolFrançaisPortuguês do BrasilItalianoРусский中文(简体)日本語

Download
Overwrite Filled Cells with a Specific Value...




Home Privacy Policy Cookie Policy EULA Download All added Excel tools Sitemap Contact Us


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