Go to Blanks by Color: The "Go To Special" function is the quickest way to find empty cells. Cells with formulas, constants, and blank cells can all be chosen using the "Go To Special" function.
- Select any cell within the table and press Ctrl + A.
- Select Home > Find & Select > Go To Special to find the empty cells. A Go To Special dialog box will appear.
- Choose the Blanks option in the Go To Special dialog box, then click OK.
- The dataset's black cells will be located once you click OK which is (J33)
- Select Home > Fill Color to highlight the cell. When you choose a yellow color, a preview of that color's appearance in the dataset is displayed.
- After choosing a color, the empty cells will be highlighted in that color, in which in our example is yellow.
To know more about "Go To Special" Function, visit;
https://brainly.in/question/48540134
#SPJ4
