Need to Create a new Excel Sheet Hiding All 0s

[beckerj21]

I am trying to run a cost formula narrowing it down from over 6000 cells. So I need to delete all cells with 0 in it and narrow it down to only those values >0. Is there a formula or a function I can use to do this easily in a new sheet?

[jeffreybrown]

Do you need to delete the zero's or just hide them?

Are these 6000 cells in one column?

[beckerj21]

Delete all the 0s and there are more than 6000 cells I just realized
It will be 208 columns with 6000 rows

[jeffreybrown]

The easiest method, find and replace.

[beckerj21]

I get that I can use that to find all zeros but how do I remove the empty cells

[mike7952]

I beleive you will need a macro to do what your wanting to do. Can you upload a copy of your workbook and also show your explected results you are looking for?

[jeffreybrown]

I get that I can use that to find all zeros but how do I remove the empty cells

I'm sorry, but remove empty cells, not so clear to me.

Can you provide a small sample say, A1:C10 on what you want accomplished?

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.

[beckerj21]

I have attached an example excel file. The first tab is a small version of what I would have and the second is what I would like.example.xlsx

[mike7952]

Easy way is to highlight all the cell you want to work with. Then do a replace of 0 to "". Just leave Replace with box empty. Then use goto Special. Select Blacks from the Form and click OK. This will leave all the black cells you that are blank highlighted blue. Right click on any area that is hightlighted blue and select delete>shift cells up.

[jeffreybrown]

Or

Please Login or Register  to view this content.