Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
MeliDe
 
Posts: n/a
Default AutoFilter Blank Rows

After performing an AutoFilter in Excel 2002, I end up with thousands of
blank rows when I copy the filtered info to a new worksheet? Anyone else
experience this? It makes the filtered file huge, when it should be smaller
than the original! Any ideas on how to alleviate this?
  #2   Report Post  
Frank Kabel
 
Posts: n/a
Default

Hi
try using Ron's addin:
http://www.rondebruin.nl/easyfilter.htm

--
Regards
Frank Kabel
Frankfurt, Germany

"MeliDe" schrieb im Newsbeitrag
...
After performing an AutoFilter in Excel 2002, I end up with thousands

of
blank rows when I copy the filtered info to a new worksheet? Anyone

else
experience this? It makes the filtered file huge, when it should be

smaller
than the original! Any ideas on how to alleviate this?


  #3   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

Select the filtered list, press F5, select special and visible cells only,
copy and paste

Regards,

Peo Sjoblom

"MeliDe" wrote:

After performing an AutoFilter in Excel 2002, I end up with thousands of
blank rows when I copy the filtered info to a new worksheet? Anyone else
experience this? It makes the filtered file huge, when it should be smaller
than the original! Any ideas on how to alleviate this?

  #4   Report Post  
Bernie Deitrick
 
Posts: n/a
Default

Try using Edit | Go To... Special... Visible Cells only prior to
copying.

HTH,
Bernie
MS Excel MVP

"MeliDe" wrote in message
...
After performing an AutoFilter in Excel 2002, I end up with thousands of
blank rows when I copy the filtered info to a new worksheet? Anyone else
experience this? It makes the filtered file huge, when it should be
smaller
than the original! Any ideas on how to alleviate this?



  #5   Report Post  
Dave Peterson
 
Posts: n/a
Default

Maybe resetting the lastused cell would help.

Debra Dalgleish has some techniques (both manual and VBA) for resetting the used
range at:

http://www.contextures.com/xlfaqApp.html#Unused

MeliDe wrote:

After performing an AutoFilter in Excel 2002, I end up with thousands of
blank rows when I copy the filtered info to a new worksheet? Anyone else
experience this? It makes the filtered file huge, when it should be smaller
than the original! Any ideas on how to alleviate this?


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple rows of data on a single axis (charting) ramseysgirl Charts and Charting in Excel 8 December 29th 04 07:00 PM
how to skip the blank cells nayeemoddin Excel Discussion (Misc queries) 1 December 6th 04 08:07 AM
copy blank cells Vicneswari Murugan Excel Discussion (Misc queries) 0 December 1st 04 04:33 AM
Blank Rows Acesmith Excel Discussion (Misc queries) 1 November 30th 04 10:23 PM
How do I remove blank rows in Excel? m28leics Excel Discussion (Misc queries) 2 November 30th 04 12:56 AM


All times are GMT +1. The time now is 06:26 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"