Copying Worksheets

D

dpridemore

I have a large workbook in which I have a saved worksheet that is used to
make other identical worksheets. The saved worksheet is working properly in
regards to formulas, leaving cells blank, etc. However when I copy this
worksheet to another worksheet in the workbook one column which uses the SUM
function changes from a blank cell to one containing a 0 if there is no data
in any of the fields that it is summing. I cant have this.

I have tried clear formatting only with the result that the 0 just reduces
in size - as does anything in the column that has real results.

Thanks
 
J

Jim Rech

If a formula evaluates to zero but the zero doesn't display it would seem
you have unchecked "zero values" under Tools, Options, View. You'd need to
do that for every sheet where you wanted this result.

--
Jim
|I have a large workbook in which I have a saved worksheet that is used to
| make other identical worksheets. The saved worksheet is working properly
in
| regards to formulas, leaving cells blank, etc. However when I copy this
| worksheet to another worksheet in the workbook one column which uses the
SUM
| function changes from a blank cell to one containing a 0 if there is no
data
| in any of the fields that it is summing. I cant have this.
|
| I have tried clear formatting only with the result that the 0 just reduces
| in size - as does anything in the column that has real results.
|
| Thanks
|
|
 
D

dpridemore

Thanks Jim - I now only have 78 worksheets to make this change on.......fun,
fun, fun.
 
G

Gord Dibben

Right-click and "select all sheets" before going to Tools>Options>View


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

Top