Autofilter Issue

  • Thread starter Thread starter Jeff Ignatovich
  • Start date Start date
J

Jeff Ignatovich

Right up front, I am no Excel expert by any means, so I
hope all this makes sense. If I copy a section of a
spreadsheet using the Auto Filter to hide certain sections
or lines, then paste it into a Powerpoint presentation,
the hidden lines become visable as blank lines at the
botton of the import. Can someone tell me what I am doing
wrong. Or is this just normal?
 
Before copying the cells, use Edit/Goto Special, click on VisibleCells, THEN
copy/paste.
Bob Umlas
Excel MVP
 
Bob,

That solution did not work. Might you have anotther trick
up your sleeve?

Jeff
 
I don't use powerpoint, but how about if you have an intermediate stop first.

Do what Bob Umlas suggested, but paste it to a different range (new temporary
worksheet???) first.

Then another copy from there, then paste to ppt.
 
Back
Top