How to Fill Blank Cells with Value Above or 0 in Excel Office 365?
Tags: fillblankcellswithva, kutoolsexceltutorial, kutools
Published: 2020-10-20 12:10:38

---
title: How to Fill Blank Cells with Value Above or 0 in Excel Office 365?
published: true
date: 2020-10-19 12:14:11 UTC
tags: FillBlankCellswithVa,KutoolsExcelTutorial,Kutools
canonical_url: https://geekexcel.com/how-to-fill-blank-cells-with-value-above-or-0-in-excel-office-365/
---

In this post, we describe the steps to **Fill Blank Cells with Value Above or 0 in Excel Office 365** using **Kutools.** Let’s get into this article!! Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
## Fill Blank Cells with Zero:

To fill blank cells with zero in the selected range, please do as following instructions.

- First, you need to **select a range** where you want to fill blank cells with zeros.

![Select a range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Select-a-range.png)<figcaption id="caption-attachment-16002">Select a range</figcaption>

- Then, go to the **Kutools Tab, select** the **Insert** option, **choose** the **Fill Blank Cells** option from the menu.

![Select the Fill blank cells option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Select-the-Fill-blank-cells-option.png)<figcaption id="caption-attachment-16003">Select the Fill Blank Cells option</figcaption>

- It will open the  **Fill Blank Cells Dialog box.**
- In that dialog box, you need to **select** the **Fixed value** option under the **Fill with** section.
- **Filled value box** – You need to enter 0 in this box.
- At last, **click** the **OK** button to get the result.

![Fill Blank Cells dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Fill-Blank-Cells-dialog-box.png)<figcaption id="caption-attachment-16004">Fill Blank Cells dialog box</figcaption>

- Now, you can see that all the **blank cells have been filled with zero** as shown in the below screenshot.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Output-35.png)<figcaption id="caption-attachment-16005">Output</figcaption>

## Steps to Fill Blank Cells with Value Above, Below, Left, or Right:

- You need to **select a range** in which you want to fill blank cells with existing values.

![select a range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/1-22.png)<figcaption id="caption-attachment-16006">select a range</figcaption>

- On the **Kutools Tab, select** the **Insert** option, **choose** the **Fill Blank Cells** option from the menu.

![Select the Fill blank cells option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Select-the-Fill-blank-cells-option.png)<figcaption id="caption-attachment-16003">Select the Fill Blank Cells option</figcaption>

- It will open the  **Fill Blank Cells Dialog box.**
- **Fill with section** – You need to **choose** the **Based on values** option.
- **Options section** – You can choose any one of the given types **(Down, Up, Right,** or **Left)as** you need.

![Fill Blank Cells Dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/2-17.png)<figcaption id="caption-attachment-16007">Fill Blank Cells Dialog box</figcaption>

- Then, **hit** the **OK** button and you can see that the blank cells have been filled with the existing values as shown in the below image.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/3-15.png)<figcaption id="caption-attachment-16008">Output</figcaption>

### Note:

- This tool **cannot overwrite any existing values** in the selected range.
- This utility will not copy any formatting ( **color, bold, and so on** )to the blank cells in the selection.

## Fill Blank Cells with Linear Values:

If you want to fill blank cells with linear values either from top to bottom or from left to right in Excel, do the below steps.

- You need to **select a range** in which you want to fill blank cells with linear values.

![Input Range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/4-9.png)<figcaption id="caption-attachment-16009">Input Range</figcaption>

- On the **Kutools Tab, select** the **Insert** option, **choose** the **Fill Blank Cells** option from the menu.

![Select the Fill blank cells option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Select-the-Fill-blank-cells-option.png)<figcaption id="caption-attachment-16003">Select the Fill Blank Cells option</figcaption>

- It will open the  **Fill Blank Cells Dialog box.**
- **Fill with section** – You need to **choose** the **Linear values** option.
- **Options section** – You need to select the array format of the linear values. Here, we **choose** the “ **From top to bottom** ” option.
- Finally, **click** the **OK** button to see the output.

![Fill Blank Cells dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/5-9.png)<figcaption id="caption-attachment-16010">Fill Blank Cells dialog box</figcaption>

- Now, you can see that all the blank cells have been filled with linear values from top to bottom as shown in the below image.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/6-6.png)<figcaption id="caption-attachment-16011">Result</figcaption>

### Note:

- This utility can fill the blank cells between the cells which contains data in the same columns or rows.
- You can also fill linear values in rows by selecting the **From left to right** option from the dialog box.

## Verdict:

In this post, you can learn the steps to **Fill Blank Cells with Value Above or 0 in Excel Office 365** using **Kutools.** Share your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Read Ahead:

- [Insert a Monthly or a Yearly Calendar in Excel](https://geekexcel.com/how-to-insert-a-monthly-or-a-yearly-calendar-in-excel-office-365/)
- [Unmerge Cells and Fill Down Values in Excel](https://geekexcel.com/how-to-unmerge-cells-and-fill-down-values-in-excel-office-365/)