Excel Tip 22 Fill in 0 for empty cells that are not adjacent
Excel Skill 22 explains how to use [Ctrl+F] to bring up the "Find and Replace" box, replace all blank cells with "0", and solve the problem of "fill in 0 in non-adjacent blank cells".
In this article, the operation is mainly carried out by shortcut keys, which is simple and efficient.
The data this time is: book sales data, as shown in the figure below;Among them, the blank cell needs to be filled with the number "0".
1.Select a data region
Select the data region where the blank cell is located, as shown in the following figure C3 to D9 data region.
2.Press the shortcut key [Ctrl+G] to bring up the "Positioning" dialog box, and left-click [Status Condition] in the lower left corner;
3.Select [Null Value], which means that the blank cells in the data area of the status have been selected;
4.Press OK
After that, you will find that the blank cells in the data region turn gray, indicating that the blank cells in the selected data region are selected;
5.Press Ctrl+Enter
Press the number 0 in the keyboard first, and then press and hold Ctrl and enter at the same time, you can see that the blank cells are filled with the number "0";
Note] The method of filling non-adjacent blank cells with 0 is also applicable to filling in other identical numbers or characters in non-adjacent cells.