If you copy a range with some of the rows hidden you'll copy the hidden rows
into the Windows clipboard, but not into the Office clipboard. Do your paste
from the Office clipboard.

"MermaidHunter" wrote in message
...
I have an Excel spreadsheet that has a column of business names with
addresses and telephone numbers. I have hidden the non meaningful
information. I want to copy this list to an other column, spreadsheet, or
where ever, so that I can paste just the visual cells information.
At one time I thought that this was possible through the paste options
box.
Or am I dreaming of a different dimension?