Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
blank cell
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
blank cell
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. -- Kevin Backmann "DL9998" wrote: 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
blank cell
Select the range
Use Edit : Go To ; click the Special button and specify Blanks; press OK All blank cells are selected best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "DL9998" wrote in message ... 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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
blank cell
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. DL9998 wrote: 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? -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
blank cell
great!
"Kevin B" wrote: 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. -- Kevin Backmann "DL9998" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If cell blank return a blank | Excel Worksheet Functions | |||
add blank space in cell if first name is not blank | Excel Worksheet Functions | |||
how to get excel to display blank if reference cell blank | Excel Worksheet Functions | |||
How do I make a blank cell with a date format blank? | Excel Worksheet Functions | |||
COPY A CONCATENATE CELL TO BLANK CELL PUTTING IN THE NEXT BLANK C. | Excel Discussion (Misc queries) |