Paste Special Feature

[Sue]

Hi There,
I'm running Excel 2000.

I have a range of cells in Worksheet B that I would like
to paste special/ paste link into Worksheet A. The data
in Worksheet B is only three columns, but about 20 rows.
Among the 20 rows are some blank rows put in just to make
things easy to read. But after I do the paste special,
the blank rows show up in Worksheet A with 0 (zero) in the
cells. Any ideas on how I can get rid of them?

I know I can edit them out of the Worksheet A. I'm
wondering if there is a way that I can tell Excel to
ignore the blank values when doing the paste link.

Thank you! Sue

 

[Guest]

Dear Sue

If you open the Tools menu and select "options", on the
View Tab, in the "Windows Options" section, second column,
third tick box, you will see an item called "Zero Values".
Untick this box. GO back and do your copy/paste
special/paste link and those pesky zeroes will not be
visible

Hope this helps

Paul Falla