I have a workbook with two worksheets. On Sheet2 I want to display the values of some cells on Sheet1, so I type the formula =Sheet1!A1. I now expand the formula by dragging into adjacent cells so that the values of contiguous cells on Sheet1 will appear.
The problem is that some of the cells on Sheet1 are empty, so on Sheet2 they display as 0 (zero). This is the case even though the cell format is General, not Number (even Text has the same result).
How do I get rid of the 0's from my cells without having to go in and delete them manually?
Another question: If I expand Sheet1 by adding rows and/or columns, is there any way I can have an automatic, corresponding update occur on Sheet2? Or at least prevent overwriting of the cells on Sheet2?