Copy and paste special

  • I have 2 excel files. One links to the other. It is a payable spreadsheet. Sometimes I have 1 item listed on file one, sometimes it's more than 3. I did a copy and paste special link from file 1 to file 2. The thing is than when I only have 1 item on file 1, file two will show a "0" when I don't have any data on file 1 to link to file 2. How can I eliminata the "0" from showing when I have no data on file one? Hope I made sense.


  • Re: Copy and paste special

    I'm assuming that you mean that the calculations in file2 show as 0 and you want to keep the calculations but not see the zero's.

    Tools Options and remove the tick from Zero Values should do the trick.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!