Invisible Cells are being copied

[Guest]

When pasting cut or copied "filtered" data the invisible cells are in the copy. What has gone wrong?

 

[JulieD]

Hi

before you copy the cells choose
edit / goto / special / visible cells only
then copy & paste as normal
and you'll only get the cells that you can see not the stuff behind.

Hope this helps
Cheers
JulieD

When pasting cut or copied "filtered" data the invisible cells are in the

copy. What has gone wrong?

 

[Frank Kabel]

Hi
try the following
- select your range
- before copying hit F5
- click 'Special' and choose 'only visible cells'
- now copy and paste your data

--
Regards
Frank Kabel
Frankfurt, Germany

When pasting cut or copied "filtered" data the invisible cells are in

the copy. What has gone wrong?

 

[Guest]

Thanks for your reply. However, for the past two years I have been cutting and pasting filtered data without any problems with invisible cells until this past week. In fact, When reading from help in Excel for moving & copying cells I quote the following

When you copy or past hidden hidden or "filtered" data to anothere application or another instance of Excel, only the visible cells are copied.

 

[Guest]

Thanks JulieD but.....

Reading from the help files in Excel on moving and copying cell I quote

"When you copy or paste hidden or "filtered" data to another application or another instance of Excel, only visible cells are copied.

This has been the case for me for the past two years until just this past week when all of a sudden invisible data was in my cuts of filtered data

Your suggestion works but only for copied not cut data

Thanks and keep helping me

MrP

 

[Gord Dibben]

MrP

"Cutting" filtered cells will always cut the entire range, visible and hidden.

"Copying" filtered cells copies only visible cells. No need to go to "Visible
cells only".

If you try to cut "visible cells only" you will get an error message "cannot
be done with multiple ranges".

How you were cutting and pasting visible cells only for two years is a mystery
to me.

XL2002 and XL97 both the same.

Gord Dibben Excel MVP