Jeramie Posted February 6, 2008 Report Share Posted February 6, 2008 I am updating a Multi Page Spread Sheet for work orders. I have to reference different cells on different pages for multiple copies of the same information. On occasion that data may be 6 lines long. The next order it may be 2 or even 15. There in lies the problem. When I reference that cell I get a 0 (zero) that shows in my referenced cell. Id rather that cell be blank until information is entered into the referenced cell. Otherwise if I enter an order that is 4 lines long yet I have referenced 15 lines on my template I end up with 11 lines with 0 (zero) for the information. I then have to delete those lines of zero before I can print..... Savy? Who is the local Excell expert? Quote Link to comment Share on other sites More sharing options...
Texan_Til_I_Die Posted February 6, 2008 Report Share Posted February 6, 2008 If I'm following your question correctly, do this... Open the spreadsheet Click Tools>Options On the View tab uncheck Zero Values Quote Link to comment Share on other sites More sharing options...
toddyboman Posted February 6, 2008 Report Share Posted February 6, 2008 If I'm following your question correctly, do this... Open the spreadsheet Click Tools>Options On the View tab uncheck Zero Values Thats what I do with 0 values too. Quote Link to comment Share on other sites More sharing options...
Tominator Posted February 7, 2008 Report Share Posted February 7, 2008 You could also format the cells for Accounting, then the zeros would show up as dashes (-) Or, you could do a custom format. Or, if you really feel like fiddling, go to where your zeros are showing then select your range, go to Tools, conditional formatting, there's a drop down list there, then IF cell value is, equal to, 0, format, change the color to white, then they wouldn't show up. Quote Link to comment Share on other sites More sharing options...
Jeramie Posted February 7, 2008 Author Report Share Posted February 7, 2008 If I'm following your question correctly, do this... Open the spreadsheet Click Tools>Options On the View tab uncheck Zero Values I knew there had to be a place to hide the values! Thanks! Quote Link to comment Share on other sites More sharing options...
Jeramie Posted February 7, 2008 Author Report Share Posted February 7, 2008 You could also format the cells for Accounting, then the zeros would show up as dashes (-) Or, you could do a custom format. Or, if you really feel like fiddling, go to where your zeros are showing then select your range, go to Tools, conditional formatting, there's a drop down list there, then IF cell value is, equal to, 0, format, change the color to white, then they wouldn't show up. Im an "uncheck the box" kind of guy.... Id rather be effective than over productive... Quote Link to comment Share on other sites More sharing options...
Tominator Posted February 7, 2008 Report Share Posted February 7, 2008 Im an "uncheck the box" kind of guy.... Id rather be effective than over productive... Why not both? Anyway, it's in the Format menu, not the Tools. My bad. Quote Link to comment Share on other sites More sharing options...
bfletch7441 Posted February 7, 2008 Report Share Posted February 7, 2008 You could also format the cells for Accounting, then the zeros would show up as dashes (-) Or, you could do a custom format. Or, if you really feel like fiddling, go to where your zeros are showing then select your range, go to Tools, conditional formatting, there's a drop down list there, then IF cell value is, equal to, 0, format, change the color to white, then they wouldn't show up. The IF statement was going to be my suggestion, but the zero values box sounds much easier. You learn something new everyday! Ben Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.