Need to Create a new Excel Sheet Hiding All 0s

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

Are these 6000 cells in one column?

The easiest method, find and replace.

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?

Originally Posted by beckerj21

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.

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.

Or

Please Login or Register  to view this content.