| Home |
| Search |
| Today's Posts |
|
#2
|
|||
|
|||
Autofilter all the non-blank rows F5 - Special - Visible cells only - Delete mzafar Wrote: Folks - I have a spreadsheet with two columns Database Name Status ABC Checked ABC Checked ABC Checked Here is a Blank Row Checked XYZ Checked XYZ Modified XYZ Modified XYZ Modified Here is another blank row How can I get rid of Status value for blank rows? Can someone please help? Regards, mzafar -- Morrigan ------------------------------------------------------------------------ Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094 View this thread: http://www.excelforum.com/showthread...hreadid=388352 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel2000: Data Validation to restrict entries | Excel Discussion (Misc queries) | |||
| Empty Cells in validation List | Excel Worksheet Functions | |||
| Effect of Conditional Formatting, Data Validation | Excel Discussion (Misc queries) | |||
| Data Validation List =Name | Excel Discussion (Misc queries) | |||
| data validation on sth else | Excel Worksheet Functions | |||
Threaded Mode
