| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hide/Don't Display Values
I have a secondary spreadsheet that obtains its values (text and numbers)
from a primary spreadsheet. Since some of the values in the primary spreadsheet are blank, the secondary spreadsheet displays "0" for blank text and $0.00 for blank numbers. How do I hide these values in the spreadsheet, without losing the formulas? I want to make sure that the values can be seen in the secondary spreadsheet in the future if any valid values are entered. Thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a formula to hide/ display row based on cell value in Exc | Excel Worksheet Functions | |||
| I am trying to hide or display the scroll bars in Excell 2007. | Excel Discussion (Misc queries) | |||
| hide values and display a decimal point that fills the cell | Excel Worksheet Functions | |||
| Automate display/ hide rows in excel based on yes/no check box | Excel Discussion (Misc queries) | |||
| Excel Compare values in columns & display missing values in a new | Excel Discussion (Misc queries) | |||
Threaded Mode
