| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Range from x to first non-blank cell?
It's for use in a cell formula.
"WSI" wrote in message ... Hi Bill - Do you simply want to highlight it? If you click on the first cell, then hold down ctrl+shift, then hit the down arrow it will highlight everything until the first blank cell. If you just want to find the next blank cell and not highlight, only use ctrl and hit the down arrow. Hopefully this helps "Bill" wrote: How do I do a column range from a starting cell until the first non-blank cell? Also, is there a function, etc. that will return the row number of the first non-blank cell in a column? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return of blank cell if lookup fails | Excel Worksheet Functions | |||
| Counting blank and filled cells within a range. | Excel Discussion (Misc queries) | |||
| blank cell turns to 0 | New Users to Excel | |||
| Cell set to wrap text and blank line -- fix? | Excel Discussion (Misc queries) | |||
| VLookup resulting in a blank cell... | Excel Worksheet Functions | |||
Threaded Mode
