| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding zeros on my worksheet
This may be so simple however I cant figure it out. I do not want to see zeros, I only want the cells that have a value of greater that zero to show on my totals page. Sheet 1 is my total page sheet 2 -13 are the monthly numbers. How do I hide the value of zero on my total page? Scott -- thesuperhero ------------------------------------------------------------------------ thesuperhero's Profile: http://www.excelforum.com/member.php...o&userid=29828 View this thread: http://www.excelforum.com/showthread...hreadid=495323 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hiding zeros on my worksheet
Tools Options, on the View tab under Window otpions uncheck the "Zero
values" box. "thesuperhero" wrote: This may be so simple however I cant figure it out. I do not want to see zeros, I only want the cells that have a value of greater that zero to show on my totals page. Sheet 1 is my total page sheet 2 -13 are the monthly numbers. How do I hide the value of zero on my total page? Scott -- thesuperhero ------------------------------------------------------------------------ thesuperhero's Profile: http://www.excelforum.com/member.php...o&userid=29828 View this thread: http://www.excelforum.com/showthread...hreadid=495323 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hiding zeros on my worksheet
Thanks, worked perfectly. I knew it had to be simple -- thesuperhero ------------------------------------------------------------------------ thesuperhero's Profile: http://www.excelforum.com/member.php...o&userid=29828 View this thread: http://www.excelforum.com/showthread...hreadid=495323 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA code to Add data to exsiting worksheet | Excel Discussion (Misc queries) | |||
| Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) | |||
| Protected worksheet, showing and hiding Grouped detail | Excel Discussion (Misc queries) | |||
| Weekly Transaction Processing | Excel Worksheet Functions | |||
| copyright and worksheet protection | Excel Discussion (Misc queries) | |||
Linear Mode
