| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I hide #N/A, ### in cells not yet worked on?
My spreadsheet is a pricing sheet with formulae using lookup in another
worksheet so it fills in the rest of the row automatically. All rows below what has been filled in show #N/A in one column and ### in 3 columns. How can I hide this so the sheet looks clean and still maintain the formulae? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide columns & rows that contain "0" or blank in a range of cells | Excel Worksheet Functions | |||
| Pivot Table - hide blank cells | Excel Discussion (Misc queries) | |||
| How to hide unused cells when running accumulated totals | Excel Worksheet Functions | |||
| Can I HIDE cells with a conditional argument? | Excel Worksheet Functions | |||
| copy group of cells to another group of cells using "IF" in third | Excel Worksheet Functions | |||
Threaded Mode
