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
