Delete the blank rows

  • Thread starter Thread starter Earl
  • Start date Start date
E

Earl

I was able to filter non-blanks. Now how dow I delete
those blank rows and turn off the filter?
 
just highlight the row numbers and right click & delete.
Then data>filter>autofilter
 
Earl

If your non-blank rows are hidden, select to the bottom of the blank rows and
Edit>Go To>Special"Visible cells only">OK

Now Edit>Delete>Entire Rows.

To turn off Autofilter: Data>Filter>Autofilter - click it.

Alternative: Turn off Autofilter by Data>Filter>Autofilter - click it.

Select your data range in a column including blank rows.

Edit>Go To>Special>Blanks>OK

Edit>Delete>Entire Rows.

Gord Dibben Excel MVP
 
Thanks Don, that was too easy!
-----Original Message-----
just highlight the row numbers and right click & delete.
Then data>filter>autofilter

--
Don Guillett
SalesAid Software
(e-mail address removed)



.
Click to expand...
 
thi help me alot for autofilter...


just do

Alt D F F to turn on and then

Alt D F F to turn off.

cheer
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filter and delete 1
Arrange to present in continuous format 4
How to find and replace with blanks or actually delete row 1
Auto Filter Blank Rows 0
Advanced Filter return blank 0
Lookup Formula 4
How do I insert cells in a macro? 7
filtering: sometimes data below blank lines is &isnt available? 2

Back
Top