I added a work sheet by copying selected data from main worksheet (copy, paste special, link) and where there were blank cells in original worksheet, Excel inserted 0's. Is there a quick way to get rid of them. Blank cells are to be expected in this database of names, info, etc.

My approach was to turn on auto filter and select for 0, highlight column and delete contents. Hoping there is a less tedious way to do this.

Thanks,
Trudy