Zeros for blanks in Excel linked cells — Business Management Daily: Free Reports on Human Resources, Employment Law, Office Management, Office Communication, Office Technology and Small Business Tax Business Management Daily

Zeros for blanks in Excel linked cells

by on
in Excel Training,Office Technology

Q. When I link two sheets together and a cell in the source sheet is blank, I get a 0 in the target sheet. How do I get rid of the 0’s?

A. If you don’t have a valid 0 value in a cell, there is an Option under Advanced, you can set for a particular worksheet called “Show a zero in cells that have zero value." It is specific to that workbook and that worksheet in that workbook.

Leave a Comment