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
  • LinkedIn
  • YouTube
  • Twitter
  • Facebook
  • Google+

Zeros for blanks in Excel linked cells

Get PDF file

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

Previous post:

Next post: