| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide blank cells in either of 2 columns
If I want to hide the rows of a worksheet which are blank in a particular
column, I can do that easily with Data | Filter. But now I want to hide any row where the cells in columns R and S are both blank. How can I do that? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide rows of cells that are blank | Excel Discussion (Misc queries) | |||
| Hide row if all cells in another range are blank | Excel Discussion (Misc queries) | |||
| Macro to hide the row if both columns E & F are blank in that row. | Excel Worksheet Functions | |||
| Hide columns & rows that contain "0" or blank in a range of cells | Excel Worksheet Functions | |||
| Pivot Table - hide blank cells | Excel Discussion (Misc queries) | |||
Threaded Mode
