| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I put out an empty cells of large list in Excel?
If the cells are truly empty...............
Select the column and F5SpecialBlanksOK EditDeleteShift Up You could do this on a copy of the column if you want to preserve the original. Gord Dibben MS Excel MVP On Fri, 8 Aug 2008 23:53:01 -0700, Ali Reza <Ali wrote: Hi I have a large column with empty cells and cells with entry. I want to collect cells with entry in a new smaller column and put out the empty cells. Please help me. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| empty cells in a vlookup list | Excel Worksheet Functions | |||
| Remove empty cells from named list / validation list | Excel Worksheet Functions | |||
| Excel - Autom. Filter "Empty / Non Empty cells" should come first | Excel Discussion (Misc queries) | |||
| Delinking (a large list of) cells? | Excel Discussion (Misc queries) | |||
| Empty Cells in validation List | Excel Worksheet Functions | |||
Hybrid Mode
