logo ASAP Utilities

The ASAP Utilities menu in Excel (English)

Excel 365, 2021, 2019, 2016, 2013, 2010 or 2007 with ASAP Utilities in its menu

Copy values to empty cells below filled cells in selection

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

Fill  ›  Copy values to empty cells below filled cells in selection

This utility fills all empty cells in your selection with the value from the first filled cell found above.

This can be very useful if you want for example to prepare your data for a pivot table.

Screenshots

Fill  ›  Copy values to empty cells below filled cells in selection
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


Download
Additional keywords for this tool:
copy down several values in a column, fill blank cells with value above, Repeat all Item Labels
Overwrite filled cells in selection...



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