E
Earl
I was able to filter non-blanks. Now how dow I delete
those blank rows and turn off the filter?
those blank rows and turn off the filter?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Don Guillett
just highlight the row numbers and right click & delete.
Then data>filter>autofilter
Then data>filter>autofilter
G
Gord Dibben
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
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
E
Earl
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)
.
S
sokevin
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
just do
Alt D F F to turn on and then
Alt D F F to turn off.
cheer