Fill Blank Cells for Microsoft Excel

How to easily fill empty cells in Excel

Filling blanks in Excel by the values above or below

Fill Blank Cells for Excel will copy the contents downwards or upwards from the first populated cell. In addition, you can specify if your table has headers or choose to split the merged cells. This handy tool will make the filling routine a breeze!

Free Download
Free 15-day trial version, 9/8/2014



Follow these steps to fill blank ranges in your table.

  1. Select a range in your table where you need to replicate cell values.

    Tip

    If you click on any cell in your table and run the program, it will select the entire table automatically.

  2. Run the add-in by clicking on its icon The Fill Blank Cells icon in Microsoft Excel and you will see the Fill Blank Cells window with the list of your columns.
  3. Select the columns where you need to fill blanks by checking the boxes next to them. The columns you select are automatically highlighted in your table. See the list of columns on the add-in window
    If you have a lot of columns in your spreadsheet, you can benefit from the Select All and Unselect All buttons to instantly choose the needed columns.
    Use 'Select All' and 'Unselect All' buttons to instantly choose the columns
  4. It is also possible to indicate if there are header rows in your table. As a rule, the add-in identifies headers automatically. If it didn't, you can check the Table has headers option. You can also uncheck this option if you don't want header rows to be indicated. Indicate if there are header rows in your table
  5. Select the Fill cells downwards radio button if you need to fill the blanks using the value from the cell above the range with empty cells. Fill the blank range using the value of the cell above
  6. If you want to fill gaps with the value of the cell below, select the Fill cells upwards radio button. Fill gaps with the value of the cell below
  7. If there are merged cells in your table, you can unmerge them by ticking the Split the merged cells on the add-in window. Unmerge cells and fill them with the same value See the list of columns on the Fill Blank Cells window
  8. Click Run to see the results.

Featured customers

Ablebits.com featured customers
 
Contact us
 
  Publish this message on the forum
 

Please remember that we work from 8am to 4pm GMT,
this is 4:00am to 12:00pm EST, 1:00am to 9:00am PST, and our public holidays may differ from yours.

Ultimate Suite for Excel Professionals
 
 
The best spent money on software I've ever spent!
Patrick Raugh
Ablebits is a fantastic product - easy to use and so efficient.
Debra Celmer
Excel is at its best now
Annie C.
I don't know how to thank you enough for your Excel add-ins
Jennifer Morningstar
Anybody who experiences it, is bound to love it!
Kumar Nepa
It's the best $100 we've ever spent!
Mike Cavanagh
I love the program, and I can't imagine using Excel without it!
Robert Madsen
One word… WOW!
Dave Brown
Love the products!
David Johnston
It is like having an expert at my shoulder helping me…
Linda Shakespeare
Your software really helps make my job easier
Jeannie C.
Thanks for a terrific product that is worth every single cent!
Dianne Young
I love your product
Brad Gibson
Awesome!!!
Sheila Blanchard