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) |