Problem with Copy & Paste

Hi,

I have 2 questions: -

1. I have quite a large workbook with formulas connected to several sheets; the problem is when I go to copy (highlight the column, right click, copy) Excel freezes and I get the error message 'not responding', then it closes. I'm using Excel on Office 10. Any suggestions?

2. I want to hide all zero amounts and have done this by tools, options, unticked zero values and just to be sure conditional format using white text; even after this there are some zero amounts that are still visible, why is this?

Any help appreciated.

Don't know the answer to Q1, but for Q2 this is probably because the values are not exactly zero - they maybe something like 0.00000001 which will display as zero, but which will not respond to your settings. If these are the result of some formula then you could use ROUND to set the result to a fixed number of decimal places, like:

=ROUND(your_formula,2)

to set to 2 dp.

Hope this helps.

Pete