| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
remove blank records (row) in worksheet
Large number of records with many blank records (row) are there. I want to
remove all blank records from it. I dont want to sort it. just squeeze it, means removal of blank records. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
remove blank records (row) in worksheet
hit F5
select Special mark Blanks ok rightklick on 1 selected cells select move cells up ok "sahusir" skrev: Large number of records with many blank records (row) are there. I want to remove all blank records from it. I dont want to sort it. just squeeze it, means removal of blank records. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
remove blank records (row) in worksheet
F5SpecialBlanksOK
EditDeleteShift up or Entire Row Gord Dibben MS Excel MVP On Sat, 14 Oct 2006 08:33:02 -0700, sahusir wrote: Large number of records with many blank records (row) are there. I want to remove all blank records from it. I dont want to sort it. just squeeze it, means removal of blank records. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete ANY blank rows on worksheet | Excel Discussion (Misc queries) | |||
| How can I print a worksheet excluding blank rows? | Excel Worksheet Functions | |||
| Comparing a list to a Calendar worksheet. | Excel Worksheet Functions | |||
| I want a blank space on a worksheet when the question is blank? | Excel Discussion (Misc queries) | |||
| Remove ALL duplicated records, leaving behind NONE | Excel Discussion (Misc queries) | |||
Hybrid Mode
