| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide errormessages
Hi!
How can I hide error messages in my spreadsheet cellsquick and easy? Errors like #I/T etc. Kathrine |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Hide errormessages
Highlight your range
Conditional Formatting Formula Is: =A1=#I/T (Format your text color same as your background color) "Kathrine" wrote: Hi! How can I hide error messages in my spreadsheet cellsquick and easy? Errors like #I/T etc. Kathrine |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table: How do I hide calculated items that result in zero? | Charts and Charting in Excel | |||
| Need a macro to hide certain columns | Excel Discussion (Misc queries) | |||
| How can I hide a range of columns without hiding charts there? | Charts and Charting in Excel | |||
| Can anyone tell me how to hide rows that have 0 values and text. | Charts and Charting in Excel | |||
| Macro to hide blank cells in a range | Excel Discussion (Misc queries) | |||
Linear Mode
