To select blank cells, do the following:
1. Select a range of cells.
2. On the Home tab, in the Editing group, click Find & Select and then click Go To Special...
3. In the Go To Special dialog box, click Blanks.
4. Click OK.
Additional Reading:
1. Select a range of cells.
2. On the Home tab, in the Editing group, click Find & Select and then click Go To Special...
3. In the Go To Special dialog box, click Blanks.
4. Click OK.
Additional Reading:
- Click CTRL + END key to know the last cell that has the data in the worksheet. Excel will select all the blank cells till this region only.
- Excel will not select blank cells in an empty worksheet.
0 comments:
Post a Comment