![]() Lastly, type in the value 0 in the formula bar and press Ctrl+Enter.Įach of the blank cells in the Points column will automatically be replaced with zeros. ![]() In the new window that appears, select Blanks and then click OK:Īll of the blank values in the Points column will automatically be highlighted: Then click the Special button in the bottom left corner of the Go To window. To do so, type Ctrl+G to bring up the Go To window: Suppose we would like to replace the blank cells in the Points column with zeros. Suppose we have the following dataset that shows the points scored by various basketball teams: Example: Replace Blank Cells with Zero in Excel The following example shows how to use this function in practice. The easiest way to replace blank cells with zeros in Excel is to use the Go To Special function. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2023
Categories |