how to paste link and not get a zero in the blank cell?

  • Thread starter Thread starter Margo M
  • Start date Start date
You'll have to modify the pasted formula--or type it yourself.

=if(sheet1!a1="","",sheet1!a1)


Margo M wrote:
 
You cannot when you paste link.

To prevent a zero you must manually create the link.

=IF(Sheet1!A1="","",Sheet1!A1)

Or turn off the display of zeros in Display Options.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I remove zeros from a linked blank cell? 3
Linking blank cells 1
Linking Cells 7
Zeros in Cells 6
Question about conditional formatting of zeros in Excel 0
Need linked cell to be blank not 0 2
Displaying zeros in cells 2
using 'paste link' into seperate tab 4

Back
Top