blank cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to find a blank cell in an area (a1:bb100). I would also like
the cursor to move to that cell. Is this possible using a formula?
 
If you select the the data range (A1:BB100) and then press F5. In the Go To
dialog box click the SPECIAL and in the list of options click the BLANKS
option button.

This selects all the blanks in the selected range.
 
Select the range
Use Edit : Go To ; click the Special button and specify Blanks; press OK
All blank cells are selected
best wishes
 
Not using a formula. Formulas return values. They don't move to other cells.

But you could use:
edit|goto|Special|Blanks
and you'll have all the blanks in that range selected.
Then you could just click on the cell to select a single cell.
 
great!

Kevin B said:
If you select the the data range (A1:BB100) and then press F5. In the Go To
dialog box click the SPECIAL and in the list of options click the BLANKS
option button.

This selects all the blanks in the selected range.
Click to expand...
 
Back
Top