Japanese version. There are times when a cell is blank except for a cell with a number, and you want to fill it with zeros.This is a common situation when using pivot tables. You may enter the data manually, one cell at a time,However, if the number of target cells is large, the time and effort required will increase.Here we introduce an efficient solution. Steps First, enter 0 in only one cell, anywhere. Copy the cell with the 0 entered and range-select the other cells. From the right-click menu, select “Paste Special”. Select “Add” and press the “OK” button. All blank cells will be populated with zeros. Links Tips. Others.(Microsoft … Continue reading How to efficiently enter 0 in a blank cell.(Microsoft Excel)