Fill empty Excel cells in 1 click: down, up. Optipe DTS → Perfect!
Fill Empty Cells in Excel application of Optipe Data Tools Suite allows you to fill the blank cells in an Excel table or database with a text, number or reference to a cell.
Use this application to:
- Complete tables or databases with blank cells that difficult calculations.
- Fill empty cells in a column with the upper cell value.
Features:
- You can choose to fill the empty cells in the selected range, in a column or row, or even in the entire table.
- Fill with:
- The upper cell value
- A constant
- A formula
- A reference to a cell
- Clipboard Contents
Examples:
Video Example. Fill empty cells with value of upper cell.
Video Example. Fill empty cells with a value, a formula, a reference or the clipboard.
