Sometimes my management ask to create PivotTable and share PivotTable data in a excel workbook. When I copy data from Pivot Table and paste the data into different excel sheet, I faced problem due to blank cell. Therefore me and my management team can't use filter option. 

So today I will share tips to fill blank cell with above or below cell data. Also users can fill the blank cell data with fixed value with simple replace option.

Please follow the data which is copied from PivotTable

Now I need to fill the blank cell with the above cell value

STEP -1
Choose the selection area

STEP - 2
Access FIND AND SELECT
Seelct GoTo Special


STEP - 3
Select Blank

STEP - 5
Now need to select Above/Below cell 

STEP - 6
Type =Cell Code like below

Press CTRL + ENTER

STEP - 7
Follow the result

If you want to fill the cell with any specified value, users need to follow the REPLACE function


STEP - 8,
Replace the blank cell with 0 value


Clink on Replace ALL



Done