Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Deleting rows with blank cells
How do I delete rows that contain blank cells in an Excel Worksheet?
|
#2
|
|||
|
|||
Select the range, press F5, special and select blanks, press Ctrl and minus
(dash), select entire row -- Regards, Peo Sjoblom "Batman" wrote in message ... How do I delete rows that contain blank cells in an Excel Worksheet? |
#3
|
|||
|
|||
I have four columns of data, some of the cells are blank, how do I delete
those particular rows? "Peo Sjoblom" wrote: Select the range, press F5, special and select blanks, press Ctrl and minus (dash), select entire row -- Regards, Peo Sjoblom "Batman" wrote in message ... How do I delete rows that contain blank cells in an Excel Worksheet? |
#4
|
|||
|
|||
Thank you is hard to say? Use either shift left or up
-- Regards, Peo Sjoblom "Batman" wrote in message ... I have four columns of data, some of the cells are blank, how do I delete those particular rows? "Peo Sjoblom" wrote: Select the range, press F5, special and select blanks, press Ctrl and minus (dash), select entire row -- Regards, Peo Sjoblom "Batman" wrote in message ... How do I delete rows that contain blank cells in an Excel Worksheet? |
#5
|
|||
|
|||
I'm sorry - no offence meant - but I don't think you understand, when I
select all 20 000 lines of data and press F5, blah, blah...all it selects is the 1, ENTIRE ROW, of blanks. I have 20 000 lines and under one of the columns there are intermittent blanks, the adjacent cells still have data, but I want to delete the whole row anyway, data, blank cell, and all... please help I have a project due in 12 hours...thanks "Peo Sjoblom" wrote: Thank you is hard to say? Use either shift left or up -- Regards, Peo Sjoblom "Batman" wrote in message ... I have four columns of data, some of the cells are blank, how do I delete those particular rows? "Peo Sjoblom" wrote: Select the range, press F5, special and select blanks, press Ctrl and minus (dash), select entire row -- Regards, Peo Sjoblom "Batman" wrote in message ... How do I delete rows that contain blank cells in an Excel Worksheet? |
#6
|
|||
|
|||
Select just the column with intermittent blanks the follow Peo's F5 etc.
Gord Dibben Excel MVP On Tue, 15 Feb 2005 15:01:03 -0800, Batman wrote: I'm sorry - no offence meant - but I don't think you understand, when I select all 20 000 lines of data and press F5, blah, blah...all it selects is the 1, ENTIRE ROW, of blanks. I have 20 000 lines and under one of the columns there are intermittent blanks, the adjacent cells still have data, but I want to delete the whole row anyway, data, blank cell, and all... please help I have a project due in 12 hours...thanks "Peo Sjoblom" wrote: Thank you is hard to say? Use either shift left or up -- Regards, Peo Sjoblom "Batman" wrote in message ... I have four columns of data, some of the cells are blank, how do I delete those particular rows? "Peo Sjoblom" wrote: Select the range, press F5, special and select blanks, press Ctrl and minus (dash), select entire row -- Regards, Peo Sjoblom "Batman" wrote in message ... How do I delete rows that contain blank cells in an Excel Worksheet? |
#7
|
|||
|
|||
I need to delete the ROW, not just the blank, thanks anyway
"Gord Dibben" wrote: Select just the column with intermittent blanks the follow Peo's F5 etc. Gord Dibben Excel MVP On Tue, 15 Feb 2005 15:01:03 -0800, Batman wrote: I'm sorry - no offence meant - but I don't think you understand, when I select all 20 000 lines of data and press F5, blah, blah...all it selects is the 1, ENTIRE ROW, of blanks. I have 20 000 lines and under one of the columns there are intermittent blanks, the adjacent cells still have data, but I want to delete the whole row anyway, data, blank cell, and all... please help I have a project due in 12 hours...thanks "Peo Sjoblom" wrote: Thank you is hard to say? Use either shift left or up -- Regards, Peo Sjoblom "Batman" wrote in message ... I have four columns of data, some of the cells are blank, how do I delete those particular rows? "Peo Sjoblom" wrote: Select the range, press F5, special and select blanks, press Ctrl and minus (dash), select entire row -- Regards, Peo Sjoblom "Batman" wrote in message ... How do I delete rows that contain blank cells in an Excel Worksheet? |
#8
|
|||
|
|||
Assume Column C has intermittent blanks.
Select Column C by clicking on the header. That's the rectangle at top with the letter "C" in it. F5SpecialBlanks and OK The blanks in Column C will be selected. Now, go to EditDeleteENTIRE ROW. Gord On Tue, 15 Feb 2005 16:43:01 -0800, Batman wrote: I need to delete the ROW, not just the blank, thanks anyway "Gord Dibben" wrote: Select just the column with intermittent blanks the follow Peo's F5 etc. Gord Dibben Excel MVP On Tue, 15 Feb 2005 15:01:03 -0800, Batman wrote: I'm sorry - no offence meant - but I don't think you understand, when I select all 20 000 lines of data and press F5, blah, blah...all it selects is the 1, ENTIRE ROW, of blanks. I have 20 000 lines and under one of the columns there are intermittent blanks, the adjacent cells still have data, but I want to delete the whole row anyway, data, blank cell, and all... please help I have a project due in 12 hours...thanks "Peo Sjoblom" wrote: Thank you is hard to say? Use either shift left or up -- Regards, Peo Sjoblom "Batman" wrote in message ... I have four columns of data, some of the cells are blank, how do I delete those particular rows? "Peo Sjoblom" wrote: Select the range, press F5, special and select blanks, press Ctrl and minus (dash), select entire row -- Regards, Peo Sjoblom "Batman" wrote in message ... How do I delete rows that contain blank cells in an Excel Worksheet? |
#9
|
|||
|
|||
Argh! It's only selecting ONE blank at a time...
"Gord Dibben" wrote: Assume Column C has intermittent blanks. Select Column C by clicking on the header. That's the rectangle at top with the letter "C" in it. F5SpecialBlanks and OK The blanks in Column C will be selected. Now, go to EditDeleteENTIRE ROW. Gord On Tue, 15 Feb 2005 16:43:01 -0800, Batman wrote: I need to delete the ROW, not just the blank, thanks anyway "Gord Dibben" wrote: Select just the column with intermittent blanks the follow Peo's F5 etc. Gord Dibben Excel MVP On Tue, 15 Feb 2005 15:01:03 -0800, Batman wrote: I'm sorry - no offence meant - but I don't think you understand, when I select all 20 000 lines of data and press F5, blah, blah...all it selects is the 1, ENTIRE ROW, of blanks. I have 20 000 lines and under one of the columns there are intermittent blanks, the adjacent cells still have data, but I want to delete the whole row anyway, data, blank cell, and all... please help I have a project due in 12 hours...thanks "Peo Sjoblom" wrote: Thank you is hard to say? Use either shift left or up -- Regards, Peo Sjoblom "Batman" wrote in message ... I have four columns of data, some of the cells are blank, how do I delete those particular rows? "Peo Sjoblom" wrote: Select the range, press F5, special and select blanks, press Ctrl and minus (dash), select entire row -- Regards, Peo Sjoblom "Batman" wrote in message ... How do I delete rows that contain blank cells in an Excel Worksheet? |
#10
|
|||
|
|||
Select to column where your blanks exist, then run this:
Sub DeleteWhereBlank() ' Selection.SpecialCells(xlCellTypeBlanks).Select Selection.EntireRow.Delete End Sub "Batman" wrote in message ... Argh! It's only selecting ONE blank at a time... "Gord Dibben" wrote: Assume Column C has intermittent blanks. Select Column C by clicking on the header. That's the rectangle at top with the letter "C" in it. F5SpecialBlanks and OK The blanks in Column C will be selected. Now, go to EditDeleteENTIRE ROW. Gord On Tue, 15 Feb 2005 16:43:01 -0800, Batman wrote: I need to delete the ROW, not just the blank, thanks anyway "Gord Dibben" wrote: Select just the column with intermittent blanks the follow Peo's F5 etc. Gord Dibben Excel MVP On Tue, 15 Feb 2005 15:01:03 -0800, Batman wrote: I'm sorry - no offence meant - but I don't think you understand, when I select all 20 000 lines of data and press F5, blah, blah...all it selects is the 1, ENTIRE ROW, of blanks. I have 20 000 lines and under one of the columns there are intermittent blanks, the adjacent cells still have data, but I want to delete the whole row anyway, data, blank cell, and all... please help I have a project due in 12 hours...thanks "Peo Sjoblom" wrote: Thank you is hard to say? Use either shift left or up -- Regards, Peo Sjoblom "Batman" wrote in message ... I have four columns of data, some of the cells are blank, how do I delete those particular rows? "Peo Sjoblom" wrote: Select the range, press F5, special and select blanks, press Ctrl and minus (dash), select entire row -- Regards, Peo Sjoblom "Batman" wrote in message ... How do I delete rows that contain blank cells in an Excel Worksheet? |
#11
|
|||
|
|||
Bat
Is it possible the blank rows are not truly blank? Try this. In a empty cell enter =ISBLANK(cellref) where cellref is one of the "blank" cells. Does it return TRUE or FALSE? Gord On Tue, 15 Feb 2005 19:23:01 -0800, Batman wrote: Argh! It's only selecting ONE blank at a time... "Gord Dibben" wrote: Assume Column C has intermittent blanks. Select Column C by clicking on the header. That's the rectangle at top with the letter "C" in it. F5SpecialBlanks and OK The blanks in Column C will be selected. Now, go to EditDeleteENTIRE ROW. Gord On Tue, 15 Feb 2005 16:43:01 -0800, Batman wrote: I need to delete the ROW, not just the blank, thanks anyway "Gord Dibben" wrote: Select just the column with intermittent blanks the follow Peo's F5 etc. Gord Dibben Excel MVP On Tue, 15 Feb 2005 15:01:03 -0800, Batman wrote: I'm sorry - no offence meant - but I don't think you understand, when I select all 20 000 lines of data and press F5, blah, blah...all it selects is the 1, ENTIRE ROW, of blanks. I have 20 000 lines and under one of the columns there are intermittent blanks, the adjacent cells still have data, but I want to delete the whole row anyway, data, blank cell, and all... please help I have a project due in 12 hours...thanks "Peo Sjoblom" wrote: Thank you is hard to say? Use either shift left or up -- Regards, Peo Sjoblom "Batman" wrote in message ... I have four columns of data, some of the cells are blank, how do I delete those particular rows? "Peo Sjoblom" wrote: Select the range, press F5, special and select blanks, press Ctrl and minus (dash), select entire row -- Regards, Peo Sjoblom "Batman" wrote in message ... How do I delete rows that contain blank cells in an Excel Worksheet? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
listing data without blank rows | Excel Worksheet Functions | |||
Non Blank - Blank Cells???? | Excel Discussion (Misc queries) | |||
In Exel 2000, stop the blank cells (with formulas) from printing. | Excel Discussion (Misc queries) | |||
how to skip the blank cells | Excel Discussion (Misc queries) | |||
Automatic copying data excluding blank cells | Excel Worksheet Functions |