Deleting rows with blank cells
 

How do I delete rows that contain blank cells in an Excel Worksheet?

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?

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?

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?

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?

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?

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?

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?

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?

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?

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?